retrieve Primary key value from OLAP Cube

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dinesh Patel - 23 Aug 2006 06:55 GMT

I want to retrieve Primary key value from my OLAP Cube. can you please tell
me how can i do this in below query?

SELECT NON EMPTY { [Measures].[Total Test Count] } ON COLUMNS,
NON EMPTY { ([Dim Station].[Station Name].[Station Name].&[1ST CHOICE
EMISSIONS & INSPECTIONS] *
[Dim Test Cycle].[Test Cycle].[Test Cycle].ALLMEMBERS *
[Dim OverallResult].[Overall Result].[Overall Result].ALLMEMBERS
) } ON ROWS
FROM [OLAP Test Cube]

Dinesh Patel

Reply to this Message

Jeje - 23 Aug 2006 23:36 GMT

there is no primary keys in a cube.

I presume that you want to retrieve the drill through result?
The drill through command return the row from the source database which are
used to fill the targeted cell.
search on the web for samples and syntaxes.

>I want to retrieve Primary key value from my OLAP Cube. can you please tell
> me how can i do this in below query?
[quoted text clipped - 8 lines]
>
> Dinesh Patel

Reply to this Message

Dinesh Patel - 24 Aug 2006 14:14 GMT

Thanks for info.

> there is no primary keys in a cube.
>
[quoted text clipped - 15 lines]
> >
> > Dinesh Patel

Reply to this Message