Calculated measures on hierarchies not working

[Former Member]

Hi all

Since this month we are working with the live system of SAC. Now I have faced an issue with a calculated measure based on a Hierarchie. The calulation is not working properly (A - B). 23-03-2019-10-18-26.png If I remove the dimension "Item Category (Main Category=Hierarchie) the calculation works. 23-03-2019-10-25-11.png This issue I didn't have in the test System.

Do you have any idea?

Thanks

Danijela

[former_member207052]

Hi Former Member

I see that you are using a linked dimension "Item category". There is a chance that you have not linked the date dimensions and hence the issue. From your screen shot I could see that "4655" is used as the baseline for all calculations as you do not have date level data from the second model.

So, linking date dimensions from the two models might fix the issue.

Regards,

Naras