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 ...
@skcpaleti65 The type should be TEXT and the format should be as one of the belowYYYY-MM-DD, YYYYMMDD, YYYY/MM/DD, YYYY.MM.DDFinally you should construct your logic something like belowIF DATEDIFF(TODAY(), [EmpID].[d/Sales_start_date], "YEAR") > 2 TH...
@guenay If I remember correctly Advance Filtering only works on booked data. I think it does not work on unbooked data. 3028328 - Unexpected columns show in table when using advanced Filter in SAP Analytics Cloud (SAC) - SAP for MeNikhil
@Freddie I think you should improve your excel screenshot by also showing the Allocation attribute of the accounts. The reason I ask this is because Its not clear whether you use total of all accounts as denominator for allocation weight or only allo...
@Mr-Singh Not sure what was the workflow used. But once you created the the transformation and the job, you should just edit the job and replace data source and select the new file, your transformation should remain intact.Nikhil