Hello All,
I am trying to look for an event to call a macro when a user inserts /removes new characteristics in columns in AFO workbook. I have tried counting number of columns in a cell and try to use the worksheet_calculate event on cell change d...
This month with 2023 QRC releases a lot of features were added to SAP Analytics Cloud. Also a new version (1.15.0.0) of SAC-Add-in was also released.
In this blog we will see some of the newly introduced features of the SAC Add-in for Excel
Ability...
In this blog post we will learn how to create centrally managed/maintained dynamic Forecast Layout templates to support planning and analysis process in SAC stories.
Business Scenario:
Financial forecasting is a crucial aspect of any business or fi...
Hello All,
We recently upgraded the EPM Add-in to SP37 Build 10681. The only problem we are facing is that we are not able to save favorites in this version as it throws an error.
End users used to create their own favorites for some key di...
In this blog post we will learn how to conditionally highlight Max values of any measures in a SAC story without using any scripting elements/custom css.
Example Scenario:
We often have this requirement to highlight the maximum (or minimum) of any ...
@joreta16 May be you can try the below. Assuming your import job is from a system. Create a multi action with data import Step and set to Import Model Data and select the relevant job.Next Go to calendar and create a multi Action task and set recuure...
@Riri I do not think you can. You cant keep it open for change and also prevent from deletion. I am not sure of the use case but if you have used 0 to prefill valid planning combinations then combinations could be stored on a different intersection s...
@axel_ I think its the they way SAC aggregates the result. When you say IF [d/Monat].[p/QUARTERDESC]="Q1" THEN DATA([d/Measures]=#QTR_VARIANCE_Q1,[d/Monat]=#QTR_Q1)=RESULTLOOKUP([d/Measures]="REV")+ (RESULTLOOKUP([d/Version]=%REF_VERSION_Q1Q2...
Zeba,As I had mentioned in my initial post, you would need to add more memberset for your dimensions as per your model definition. You need to provide the intersection at which you would store this FTE values against all dimension. To start with you ...
@zebashah Create a property in employee dimension of type integer. Populate it with FTE when you load master data for employees. After this step you will have FTE equivalent of the employee in this attribute.Next create a Advanced Formula Data Action...