Hi experts!I´ve data model on daily granularity.Quantities are stored on daily levelPrices are stored on the first of each monthGoal:Calculate Amount (per day) = Quantities (per day) x Price (per corresponding month)What´s the easiest and most perfor...
IntroductionSAP Analytics Cloud allows to create models analytics and planning stored in SAC. Models are based on measures and dimensions. Dimensions can be public or private.In case of private dimensions you may have the requirement to synchonize di...
Hi experts,for each planning model I´ve a parallel backup model. Data actions are backing up data from the planning model to the backup model. This works as long as local dimension members are synched between both models. If not, data is not copied.N...
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 @saikhancs35 ,using advanced formulas it could look like this.Regards,ThomasPS: Cloud also be solve with a data action copy step and a delete statment in a following visual advanced formula step.VARIABLEMEMBER #T1 OF [d/Version]
DATA([d/Version] ...
Hi, you can run data action / multi action it in background and start in a row. However, both are queued in the background and executed serially. Even if you use a second user to execute them in parallel they are again queued and executed serially. Y...
No. If you run the data load jobs via calendar they are typically unscheduled. Scheduling is done via calendar. If you want to pause/release the import job you have to do this directly in the calendar in the multi-action task.
Hi,you can use Multi-Actions which can be scheduled via calendar. Multi-Actions can include beside others data import jobs, which can be data model imports and/or dimension imports.BR,Thomas
