Skip to Content
0
Dec 23, 2022 at 07:51 AM

How to define Calculated Dimension based input variables of multiple dimensions in SAC Table

267 Views

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 same thing in SAC table. Please see the attached screenshot of a balance sheet report which is created in SAP BPC. Basically I want to define the following reports headings:

1) Actual --> Based on version "Actual" and selected month

2) Forecast --> Based on version "Forecast" and selected month (e.g., March 2022)

3) Budget Final --> Based on version "Budget Final" and selected month (e.g., March 2022)

4) SPLY --> Based on version "Actual" and Sames Period Last Year (based of selected month: e.g., March 2022)

5) Last Month --> Based on version "Actual" and Previous Month (based of selected month: e.g., March 2022)

6) Variances and Full year

image.png

Kind regards,

Reza Ghazvini

Attachments

image.png (65.2 kB)