Hi,I´m using a planning model with time dimension on daily granularity.In a data action I want to read the Actual data for the last 3 full months and create Projection data for the current month.Currently my data action has 4 parameters to define tho...
Hi!I´m using new unified story and scripting like to get (first) selection in a table.var selection = Table.getSelections()[0];The result contains the id´s of the different dimensions selected. E.g. for cost centert.S:SAP_ALL_COSTCENTER: "[t.S:SAP_AL...
Hi experts,
it is possible to define a parameter for a measure (of a new model) with cardinality "any" (=parameter with multiple measures)
I´m using an Advanced Formula Step to manipulate data and would like to apply those (complex) steps for all...
Flexible Time in SAP Analytics Cloud was introduced with Q2/2022. It allows to support special periods and date hierarchies to show data with or without special periods.
Unfortunately I couldn´t find any blog where how this feature is configured as...
Hi experts!
I´ve an quite easy and I guess common case for asymmetric reporting and wonder if this is possible in SAC.
Data Model has the following dimensions:
Data model contains the following data:
Note the following: ...
Good feature, but not fully implemented in SAC. Data Analyzer is still not supporting user managed time dimension. Hope this gap will be closed soon. You can vote hereImprovement Request Details - Customer Influence (sap.com)
Hi,this should work.IF [d/Customer] != "#" THEN
DATA(...) ....
ENDIFFor each DATA and RESULTLOOKUP statement where [d/Customer] should be different as in the IF you have to define it explicitly (e.g. [d/Customer] = "#"BR Thomas(If helpful thanks for...
Hi, the general structure of the statement isDATA([d/Measures] = "ABC")
= RESULTLOOKUP([d/Measures] = "M1")
* RESULTLOOKUP([d/Measures] = "M2")This results in an inner-join that the measure ABC is calculated only in the case where values for M1 and M...
Hi edgar, & is unfortunatley not the solution (see edited post before). The solution to read all dimension members is currently the only way to solve it. The problem with it is, that I have to read 150.000 products and have to loop trough them. This ...