SAP Analytics Cloud | How to Apply time functions in calculated members?

[former_member250923]

Hi,

I am facing an issue in SAC when trying to apply a Time function (for example Last Year) to a calculated KPI that results from a formula or even a hierarchy node. When we apply last year to an account member, it retrieves the correct value. However, when we apply the same function to a hierarchy node of account dimension, it retrieves no values.

Can you please help?

[gcybill]

Hi Andreia,

Please share the screenshot Account dimension and properties, especially at the account member (correct) and the hierarchy node (no values).

We have to understand account type and formula you are using if any.