MS SQL Server OLAP - Referencing member names of one dimension in another

Author

Referencing member names of one dimension in another

Upendra

2005-04-24, 3:23 am

Hello!

How do I pass member names of one dimension to another dimension? For
example -

1.) [Open Date].[All Open Date].[Month].[Jan 2001] -- hard coded

2.) [Open Date].([Month becomes very late].currentmember) - desired

The second MDX statement is only pseudo to illustrate my requirement. [Open
Date] and [Month becomes very late] are time dimensions.

I'd like to pass the currentmember of one dimension to another dimension in
a calculated member as shown in (2.)

Any ideas, please let me know. You can email me at upendra.rao@hp.com

Thanks a lot!

Upendra

Deepak Puri

2005-04-25, 3:23 am

Hi Upendra,

I'm not clear about the exact relationship between the 2 time
dimensions; but LinkMember() can be used to relate hierarchies with
similar structures and keys. If you want to use the name of a member in
one dimension to build a name in the other, then StrToMember() may help.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Sponsored Links