I’m creating a measure in a cube as lookup from another cube:
[Cube1 DimDate].[TIME Hierarchy].[" + [Cube2 DimDate].[TIME Hierarchy].currentmember.name +
If I select in filter only January 2010 and February 2010 in Cube1, for Quarter 1
I obtain 100; in Cube2 I obtain 150. Even if March 2010 is not selected in Cube2 the aggregation level (the Quarter) considers it.
Could someone help me?
Thank you very much,
View Complete Post