Help with reporting layout in SAP Datasphere/ Analytics Cloud/ Web Intelligence

[saif5111]

Hello Experts,

I am using an existing model from SAP datasphere and consuming it in SAP Analytics cloud. In Datasphere I have created several Restricted measures. 

The Raw data which I am working on is as follows:

Below is the list of all Dimensions and Measures used in the model.

Below is the list of all Restricted Measures used in the model.

In the above attachment, the measures indicated with a Red Dot represent Restricted Measures in SAP Datasphere. 

The Expressions used in each of the above Restricted Measures are as follows:

• 2023 Full: Year = '2023'
• 2023 Nov: Year = '2023' AND Month = '11'
• 2024 Full: Year = '2024'
• 2024-Nov: Year = '2024' AND Month = '11'

Likewise, in SAP Analytics cloud I have also created several dimension groups to be used along with the Restricted measures which were created in SAP datasphere.

The formula used in each of the above Calculated Dimensions include the following:

• Cost: IF([d/"DS_Structure_Test":GL].[p/GL] = ("GL3")and[d/"DS_Structure_Test":"Doc type"].[p/Doc type]=("D5"),"Cost" ,"Others")
• Expense: IF([d/"DS_Structure_Test":GL].[p/GL] = ("GL2")and[d/"DS_Structure_Test":"Doc type"].[p/Doc type]=("D2","D4"),"Expense" ,"Others")
• Income1: IF([d/"DS_Structure_Test":GL].[p/GL] = ("GL1")and[d/"DS_Structure_Test":"Doc type"].[p/Doc type]=("D1","D2"),"Income" ,"Others")

In a nutshell, I was trying to group several dimensions together based on a certain condition. If the condition is true, it displays the name of the calculated dimension, else it displays "Others". 

Below is the output of the Calculated Dimensions in SAP Analytics Cloud:

The goal is to exclude the rows with "Others" in the table.

I tried using filters to the above table to exclude "Others" and below is the result:

Below is the expected output:

In SAP BW, the above output is achieved using Structures (Rows-Restricted Characteristics and columns-Restricted Key Figures) in a BeX query, but now the goal is to get the output in the same format (Rows down and Columns across) as mentioned above in SAP Datasphere/ Analytics Cloud / Web Intelligence.

Would be great if someone has encountered the above scenario and has achieved a solution.

Thanks in advance.

Regards, 

Saifullah Sharieef

[JBARLOW]

Looking at the data in the table, all rows contain an 'Others' value - so the filtered result with no data is kind of expected.

[Martin_Kuma]

Hi, did you try to suppress via a script for the table? 

DSP with SAC -> a lot of functionalities one has in BW cannot be done id DSP self, but can be easily done in SAC via scripting. You can suppress dimensions or measures, add / remove them / ... via scripting.