cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated dimension behavior with model measure and story date filter

andre_onusic
Discoverer
0 Kudos

I have a model wtih some model calculated measures, one of them returns values of previous year (Restricted Measure)

When I use this measure together a calculated dimensions (for grouping some members), and a date story filter for control the current date and previous date (by the measure cretaed), the calculated dimension presents a "null" member with values that i can't understand the logic, but when I take off the story filter, the calculated dimension work well.

Evidences:

  • The Calculated model Measure ("RealAA"): Representes the actuals for the same period but at previous year.

  • The calculated dimension ("Vp Gerencial"): There is a dimension in the model called "VP", I put this calculated dimension to group members that attempts to specific attributes from different model dimension and create anotther VP classification. In this case projects that belongs to IT ("TI") but originally comes into another "VP".

The issue appears when I filter the date ("Periodo") to get the actuals and the previous actuals ("REALAA") in the table. The "Null" member appears. But the calculated dimension works with other metrics that doesn't contain time period.

Accepted Solutions (0)

Answers (2)

Answers (2)

andre_onusic
Discoverer
0 Kudos

Hi Nikhil, thanks for your answer!

I already did this check, and there is no reason for this behaviour (I couldn't find a pattern for the null members) since the measure works if i put the filter fixed inside the table.

Andre

N1kh1l
Active Contributor
0 Kudos

andre_onusic

andre_onusicBring the Projetos dimension also on rows and see what Projetos members are getting categorized as Null in calculated dimension.

Br

Nikhil