P&L - Hierarchy of P&L Group, P&L Position and Account

Simon Eich

Hello,m

I’m working with a rule on the “P&L Group” entity and want to show the full account hierarchy in a Data View.

Setup / requirement

• Entities / hierarchy for account:
  Account → P&L Position → P&L Group
• In the Data View I can pull in the cube and activate the rule on P&L Group.
• With only the P&L Group level in the rows, everything works:
  • Row 1: Revenue
  • Row 2: Material
  • Row 3: Personnel
  • Row 4: Z1–Z2–Z3 (calculated by rule) → works

Now I want to expand the rows so that I can also see P&L Position (and ideally Account) as drill-down:

• Row 1: Revenue
• Row 2: Material
  • Sub-row 1: Domestic
  • Sub-row 2: International
• Row 3: Personnel
  • Sub-row 1: Salary
  • Sub-row 2: Ancillary costs
• Row 4: Z1–Z2–Z3 → this no longer works

The reason seems to be: the total row for the P&L Group has no corresponding P&L Position entry, so the rule is not triggered / cannot be evaluated correctly when the hierarchy is expanded.

Question

How can I set up the rule and the Data View so that:

1. I can see the hierarchy Account → P&L Position → P&L Group (expandable rows), and
2. The calculated total row (Z1–Z2–Z3 on P&L Group) still works, even though there is no direct P&L Position entry for that total row?

Any tips on how to model this in the hierarchy or how to adjust the rule context (e.g. aggregation level, parent calculation, or a dedicated “total” member) so that the calculation also works with the expanded P&L Position / Account levels would be very helpful.

Björn Reuber

Hello @Simon Eich ,

if you use multiple Entities in by Row, the Entity on which the Rule is defined needs to be the most nested one (so the last in the list). Otherwise it won't work:

Use of Rules in Board Layouts

Maybe it make sense to use the Quick Layout:

The Quick Layout – Configure End-User Layout Options in Board

regards

Björn