Skip to Content

Calculated measures on hierarchies not working

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 25 at 03:15 AM

    Hi Danijela Trisic

    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

    Add comment
    10|10000 characters needed characters exceeded