Forum Discussion

thiagoreale's avatar
thiagoreale
Regular Visitor
7 years ago

Calculated Measures - Grand Total Frozen (SSAS OLAP Cube / Live Connection)

Hello!   I have 2 measures (screen 1), with the same value when there is no filters.   On the LEFT, the regular measure that comes from the database field. On the RIGHT, a calculated measure. The...
Need Help
thiagoreale's avatar
thiagoreale
Regular Visitor
7 years ago

Hey v-chuncz-msft, thanks for the reply.

 

Since I'm not used to Dynamic Sets, I tried to create the dynamic set with all dates and use in the calculation like here:

 

 

CREATE DYNAMIC SET CURRENTCUBE.[Selected Date]
 AS { EXISTING [DIM - Time].[Hierarchy].[Date].MEMBERS } ;

and in the simple calculation:

 

CREATE MEMBER CURRENTCUBE.[Measures].[VL Charge € - Pro Rata]
AS 

SUM( [Selected Dates] , [Measures].[VL Charge € - Pro Rata HDN] ),

VISIBLE = 1;

 

But... it worked for the grand total but if I get the time dimension, I got some "cross-join like" results.