Skip to Content
0
Dec 09, 2021 at 09:05 AM

SAP Analytics Cloud for Planning - Advanced Formulas in Data Action not working

200 Views Last edit Dec 10, 2021 at 12:23 PM 2 rev

I have an issue when I use the advanced formulas in a Data Action.

I am making a demo and I have created a Model with some related objects such as stories and Data Actions, both standard and advanced. I have done some tests on the demo and the only structural change I made was to add a date dimension that I eliminated later on.

Standard Data Actions (e.g. copy step) still work. The Data Actions with advanced formulas that I created do not show errors when I validate the formulas and they execute successfully when I trigger the Data Action inside a story but they don’t generate any data.

An example of Data Action that I have created is the following. The idea is to take the data from a source version and, setting a specific factor (“02_Percentuale”) inside the story, it should give back the recalculated values.

CONFIG.TIME_HIERARCHY = CALENDARYEAR

CONFIG.GENERATE_UNBOOKED_DATA = OFF

MEMBERSET [d/Date] = (BASEMEMBER([d/Date].[h/YQM], %01_Periodo%))

DATA() = RESULTLOOKUP() * ( 1 + %02_Percentuale% )

I even tried to simplify the formula as DATA( ) = 0 but the Data Action still don’t generate the new data.

Has someone had the same problem?

Thanks