Wednesday, March 7, 2012

retrieve Primary key value from OLAP Cube

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].&&
#91;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 Patelthere 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].ALLMEMBE
RS
> ) } ON ROWS
> FROM [OLAP Test Cube]
> Dinesh Patel|||Thanks for info.
"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 ar
e
> 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...
>
>

No comments:

Post a Comment