"Dinesh Patel" <DineshPatel@discussions.microsoft.com> wrote in message
news:1EA5DE29-39D8-4002-BD57-C19998A18832@microsoft.com...
>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

"Jeje" wrote:

> 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.
>
>
> "Dinesh Patel" <DineshPatel@discussions.microsoft.com> wrote in message
> news:1EA5DE29-39D8-4002-BD57-C19998A18832@microsoft.com...
> >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
>
>