Hi All,I have a requirement where i need to calculate the forecast using below calculation.Fiscal Yr = Oct to Sep We are currently in 202407 then calculate SUM of Actuals of 2023 of account A / SUM of Actuals of 2023 of account X * Forecast value ent...
Hi,I want to build a model with many different KPI's created on account dimension. Some of these KPI's are coming from source system while some are uploaded via excel for actual. I want to use on the fly formula for calculated KPI's for only plannin...
Hi All,I have a requirement where i need to hide two tabs within the tabstrip in SAC.As the same cannot be done directly from the designer panel because that applies to the entire tabstrip.Has anyone implemented the same before using scripts or any o...
Hi All,
In my story i want to run data action (copy over ytd actuals to Forecast version).
But I want to set the DATE parameter dynamically on runtime without prompting the user to input the FROM_PERIOD as I want to perform this copy behind the S...
Hi All,
In our organization, we have a centralized planning model which is used across multiple stories and some data actions.
The issue we are having is, We need to update that model with new fiscal year data but we cannot run the import on the ...
Yes Sure adding example below so in order to calculate the FC values , I need to calculate sum of last year actuals of 62xxxxxx and FTE Calculated within data action and then multiply it with values entered on current FC months. Apart from this, I h...
Hi Nikhil,Please ignore my messages above.I was able to figure out my mistake it works now .Really appreciate your time and efforts.Many Thanks Regards,Sana
Adding DA configuration here.This is the hierarchy for Date in my DA and hence in my script I am using var datemembers=['[Date].[FYP].&[202301]','[Date].[FYP].&[202302]'];Is this format correct ?