How to realize a profit and loss statement in a Datasphere analysis model

[TF2]

I am trying to display a profit and loss statement report in SAC with an analytical model defined in Datasphere, but account dimensions are not enough, I also need
formulas. I also need formulas for operating income, net income, etc.
How can I devise a way to express this?
I would appreciate it if someone could help me.
Thank you in advance.

[ClemSteich]

Hello,

Depending on your requirements and constraints, those would be the approaches that come to mind (from better to worse in terms of ease of implementation and probably performance):

1. Use an account hierarchy defined in DSP. In case only additions are required and if it makes sense for your chart of accounts and calculations (aggregations).
2. Add calculations at story level using the 'Add row' feature + formulas
3. Add these calculated accounts in your DSP fact view by:
   • Keeping your original dataset
   • Doing an union with the same dataset where you add your calculated accounts and implement whatever calculation logic is required. Think about aggregating those newly calculated accounts as much as it functionally make sense to avoid creating too much data volume.

Regards