Use Business value instead of unique identifier - Microsoft SQL Server Analysis Services and MDX forums-SSAS

Welcome, Guest
Please Login or Register. Lost Password?

Microsoft SQL Server Analysis Services and MDX forums

SSAS Forums

MDX Studio

Use Business value instead of unique identifier

(1 viewing) (1) Guest

Please post here just questions about MDX Studio. All other questions will be moved to "Analysis Services Forum".

Page: 1

TOPIC: Use Business value instead of unique identifier

Forum Tools

#1579

Use Business value instead of unique identifier 9 Months, 2 Weeks ago Karma: 0

Hi,

I am pretty new to writing MDX queries so I'm sure this question might seem quite basic.

I am navigating values in a dimension in SQL Server Management Studio. When I select the value I want (LNABC) in my query and drag it into Query Analyser I get the unique identifier for the member value, e.g.,

Code:

[Book].[Book].&[1.5779510140419006E-2]

Instead of using the unique identifier [1.5779510140419006E-2] in the query, how do I access the book name directly,i.e., LNABC.

I have tried

Code:

[Book].[Book].[LNABC]

but that doesn't work.

Any help would be greatly appreciated.

Thanks

Jones28