SAP Analytics Cloud - Sum

[dsim98]

Greetings experts,

I'm working on a project on SAP Analytics Cloud which requires me to put certain values in a table. These values are fed through a live BW connection and that in turn takes the values from a consumption cds view I created.

The issue I am facing lies in the fact that the report i'm trying to create with dynamically change according to a date input filter I have put in place. When filtering for a single PO and for a date range there might be more than one value being fed to the the table and causing SAC to hide the values.

So my question is there any way I can sum all values being returned to the table and then since its already filtering the dates, it would dynamically change said sum?

SAP Analytics Cloud 

[MKreitlein]

Hello @dsim98 

sorry, but only reading your description does not really visualize the problem to me?!

If you have a CDS Query built on a CDS Cube, then you can put annotations to your key figures for aggregation, see: https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361385699.html#CDSviews:HowTouseinBWcontexts-Ag...

So why would more than 1 record be hidden in a SAC table? I don't get this point.

BR, Martin

[dsim98]

Forgive me for not explaining correctly. I'll give an example in order to help. If I were to select the Product code as a dimension, the result would be an error stating that there are hidden elements. From my understanding and testing, this is attributed to the fact that for a single Product Code there are more than one entries with different prices and even different Billing Documents. My issue is how do I make SAC sum all of the different prices per product code and have it show those. Without using the Billing Document or any other filter at least without it being visible in my table. I've assumed it cannot be done through SAC and maybe my CDS query is supposed to aggregate.

My CDS consumption view is built on a CDS Cube. I have only used @Aggregation.default.

[MKreitlein]

Sorry, I still don't get it 😞 ... can't you take a screenshot of your current result in RSRT and describe it with real values?

[dsim98]

Certainly

Above is the result I get on SAC. As you can see some of the values are hidden. In every one of these hidden cells there's two or more values that are not identical so SAC hides them. I would like to somehow aggregate them in order for them to appear instead of adding more filters which would solve the problem but defeat the purpose of my story.

[dsim98]

If you need my CDS code and annotations i'll be happy to provide what I can to solve this..

[MKreitlein]

Unfortunately I cannot see any headline, nor the currency ... but my assumption is that some values are not displayed due to different currencies, which cannot be aggregated. If you drill-down the currency, how does the result look then?

[dsim98]

Below shown is the se16n table so you can see what I mean by multiple values in one Product Code

In the screenshot below I have the annotations I put on my cds consumption view 

and finally the annotations set on the cds feeding into the final consumption view (this one has most calculations)

 

[MKreitlein]

Ok, if you don't have currencies, then it is probably still a matter of annotations on the key figures... see this example: https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361382991.html

here you can see:

@DefaultAggregation: #SUM
seatsocc as NumberOfOccupiedSeats

Do you have the same above your key figure (I cannot see the Name)?

@DefaultAggregation: #SUM
<YOUR KEY FIGURE>

BR, Martin

[dsim98]

This is what I have on my consumption view