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?