Dear all,
We have a challenge within our organization when loading data from SAP BPC info cube with multiple Account Hierarchy into the SAC data model. When creating a SAC data model based on a SAP BPC cube, it is mandatory to select the Account hi...
Dear all,
In SAC you can easily calculate YTD and MTD measure calculations, but what I need is to calculate a measure for (YTD - Current Month) based on the given period. For example:
Select Period: June 2023
Measure calculation for range perio...
Hi all,
In SAP Bex Analyzer, it is possible to create a Structure based on group of dimensions and dynamic selection variables. You can use the structure in the rows or columns and use another structure based of measures. Has anyone created the sam...
Hi,
I would like to do dynamic version comparison when using Numeric point chart in SAC. For example, I want to compare Actual Sales value with the dynamic version selection in the story for the same sales value. Currently you can only do this only...
Hi,
What is the function in SAC to calculate the No Dim measure. In BEx you can create a formula and use the function No Dim, so the amount on Currency will be calculated as a number (Without Currency/Units of Measure).
Kind regards,
Reza
When creating without Account Hierarchy:I have chosen the H1 Account HierarchyIn this step, I do not have a choice of by passing the
Account Hierarchy and choose all the accountsHere I am checking the mappingAs you see, the standard Hierarchy column ...
Hi Geeta,As I could see, the only way to overcome this is to create the hierarchy manually in SAC on a public Account dimension and load it from the source, flat file or manually maintaining it in the master data hierarchy. I had the same issue, when...
I know all these solutions which you have proposed, but it doesn't answered my question yet. I need to know who you can create a single structure which output the month range based on select period:Select Period = June 2023Output calculation month ra...
Hi,Thanks for the response. I know this solution, but what I was really looking for is to have a selection on the period which gives me (YTD - Current Month). I know it is possible to create 2 measures and subtract it from each other, but I was more ...
Hi,
Thanks for sharing this. Could you please let me know how aI can calculate Year to To Date (YTD), but excluding the current Month. For example: Based on the given period June 2023, I would like to have the range from Jan 2023 up to May 2023....
