hi,
In my vertul cube I am accesseing 2 cubes.when i am giving
in the lookup function in the calculated cell of a measure
can i give dimension level? if how? for example:
Lookup("stores","(Measures,
[Sales],"+product.currentmember.name+"

In the above if i want to give for one level in product
dim should i give.
In my present and target cubes is it require to give 2
dimensions in lookup?