Setup "Custom Analytical Query" based on CDS view in S4/HANA cloud

[DirkO]

Hi experts,

I "want" to set up a report in S4/HANA cloud to provide information related to Profit Center Plan/Actual/Diff information, as source of data I´d like to use the CDS view "C_PROFITCENTERPLANACTQ2701".

Desired output: GlAccount; ActualAmountInCompanyCodeCurrency (for a fiscal period)

Is it possible to calculate between given lines in the report or in a CDS view? Say: "revenue - direct cost"?

Thanks

Dirk

[I044433 · Accepted solution]

Hi dirk.obert ,

The consumption view - C_CNSLDTNGRPACTLCOMPRN10Q has the data category as - Query (Analytical query). So for your requirement, I can suggest creating a multidimensional report.

SAP S/4 HANA Fiori Multidimensional Reports allow us analyzing the data in a flexible way (e.g. by easily adding dimensions and measures to the rows or columns). You can follow the blog here (Creating multidimensional reports in SAP S/4HANA) by Masaki Arai from RIG team to know how to create the report.

Hope this helps!

Regards

Rohit

[DirkO · Accepted solution]

Hello Rohit,

tum kaise hain? Many thanks for your response.

Ok, I will have a look into this.

Have a nice weekend.

Kind regards

Dirk