Skip to Content
avatar image
Former Member

Cost centre hierarchy / groupings

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 02, 2015 at 11:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2015 at 06:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded