Does anyone have an idea how to get the UNIQUENAME of a member from ther dimesion date given a determined value.
For example in Adventure Works
Val: 2004
UNIQUENAME: [Date].[Calendar].[Calendar Year].&[2004]
Thanks!!
Here is an example showing how to retrieve the unique member name or the key value associated with the current member:
WITH
MEMBER MEASURES.[UniqueName] AS
[Date].Calendar.CurrentMember.UniqueName
MEMBER MEASURES.[KeyValue] AS
[Date].Calendar.CurrentMember.Properties("Key")
SELECT
{[Date].[Calendar].[Calendar Year].&[2004]} ON COLUMNS,
{MEASURES.[UniqueName],MEASURES.[KeyValue]} ON ROWS
FROM [Adventure Works]
HTH,
- Steve
No comments:
Post a Comment