Embedded Analytics - Custom Cube for Margin Analysis - Calculated Key Figure shows no data

[David_Mohn1]

Hello Experts,

let me give you some additional information before explaining the issue.

Back in R/3 we used KE35 (Form) and KER1 (Key Figure Scheme) to prepare for KE30 (Profitability Report) in SAP CO-PA modul.

So far i have done significant tests only with transient view entity … analytical query and was able to replace our custom reports from R/3 costing based COPA to S/4 Margin Analysis queries and the results are very good.

However, i noticed that using a custom consumption view offers very little reuseability. A new requirement triggers a new consumption view and copy/paste of the CDS view. So i want to achieve REUSEABILITY for restricted measures and calculated measures. Looking at the SAP VDM i think it is time to build custom cubes, which i successfully circumvented so far.

So how can i replace R/3 „Forms“, „Key Figures Schemes“ and „Reports“ with Embedded Analytics? I am trying to do a crossover to the VDM which uses cubes, querys, restricted measures, and calculated measures. (Screenshot shows R/3 setup of CO-PA reporting)

I am not trying to replicate the old world 1 by 1, but take over what is still useful e.g. „Prepare a Form“ and „Prepare Key Figures“ and reuse this in multiple querys.

I created the above „custom VDM“ and while the values of the restricted measures are shown correct (see below, RSRT) in the consumption view, the calcuated measures are always inital. What am i doing wrong?

Formulas are very simple:

Revenue - COGS = ContributionMargin1 and FIDirect - OverhAlloc = FIMinusOverhead

My guess is that the calculated measures may have lost their dimensions? Could that be the reason?

Or do i not understand how aggregation works?

Greatful for any tipps. I can share the CDS Views if needed.

Thank you

Regards

David