Hi ,

Iam using LookUpCube function to get some measure value from cube A to
Cube B based on the dimensions selected in Cube B.

I have two date dimensions one for calender and one for fiscal. In Cube
B , I need to know which time dimension has been dragged , based on
which I need to pass the relevant time dimension value in Lookupcube
function.

would like to know which mdx function would help to know which time
dimension has been dragged.


Thanks, Siva

Hi Siva,

If you included the current member of both dimensiona in LookupCube()
(assuming no multi-select of members), why would you need to check which
one has been dragged?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

You are right deepak, Assuming Calender and Fiscal will not be
multi-select, We can do with current member. But I have problem. In my
source cube I have Time Dimension for Calender and Fiscal.

But in my destination cube, I have 4 time dim's
Last Modified _Calender
LastModified_Fiscal
CreationDate_Calender
CreationDate_Fiscal

all these 4 should map to TimeDim_Calender and TimeDim_Fiscal in my
source cube.

So If i know which dimensions are dragged in destination cube, Using
the value of dimension , I can pass that value to TimeDim of source
cube.

Hope this is clear. Do help. Thanks

Well, does this mean that the user would only make a selection for
Creation or for Last Modified Date, but not for both? At any rate, you
could compare the current member of a dimension with its default
members, to see if the user has selected something different. Something
like:

iif(CreationDate_Fiscal.CurrentMember is
CreationDate_Fiscal.DefaultMember, ...)

Of course, a user could explicitly select the default member, which
won't be detected by such logic.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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