Cost centre hierarchy / groupings

[Former Member]

I'm new to BPC and currently working on creating report for my team. There is an existing cost center hierarchy but to create the report I would need to group cost centers by expense type.

Here is the current cost center hierarchy:

AllExpensesGroup:

     -> cost center

     -> cost center

     -> cost center

     -> cost center

     -> cost center

     -> cost center

     -> cost center

     -> cost center

     -> cost center

This is the structure I need to create the report:

AllExpensesGroup:

     -> WagesGroup:

           -> cost center

          -> cost center

          -> cost center

      -> BenefitsGroup:

           -> cost center

          -> cost center

          -> cost center

      -> VacationGroup:

          -> cost center

          -> cost center

          -> cost center

Here are the questions I have:

1 - to create the report do I need to add additional node to cost centre hierarchy? If yes, then should I do it through BPC admin console?

2 - Is there any other way to group cost centers in the report? Updating the hierarchy will require adding more than 8 groups of CCs which may not be the best solution?

Thanks

Eve

[cecilia_petersson2]

Hi eve,

In addition to Deepak's reply, I Think a second hierarchy is the best way to create the groupings. You select Maintain Dimension Members in the Admin Console, insert a column to the right of ParentH1 and name it ParentH2. (Unlike other properties, it's not necessary to add it to Properties first.)

/Cecilia

[Former Member]

and don't forget to add also FormulaH2 ...

[Former Member]

Hi Eve,

To create report you can make another hierarchy by adding addition node member in BPC admin. or using some property value you can group these costcenter value to create report

Best Regards,

Deepak