Pages

Jul 20, 2011

Hierarchies , Parenth1, Parenth2, . . .Parenthn

How hierarchies are treated in MS version of BPC.

  1. There is no hierarchy in MS version of BPC.
  2. Hierarchy is treated as BW hierarchy.
  3. Hierarchy is treated as a measure.
  4. Each hierarchy is treated as a separate dimension in the DB.
  5. The correct answer is separate dimension in the DB. So keep the hierarchies minimum in MS version.
  6. You can have more than one hierarchy for the same dimension.
  7. To define a hierarchy add the Paranet property as a column directly in a dimension member sheet via Maintain Dimension Members.
  8. Hierarchies should be named as ParentHn where n is the no of the hierarchy. For example if you have 2 hierarchies then you create as Parenth1 and Parenth2.
  9. Hierarchies are stored as SAP Net weaver BW Hierarchies in BPC Net weaver version .
  10. Hierarchies are stored as a separate dimension in MS version BPC.
  11. The order of the hierarchies are not important like Parenth1,Parenth3,Parenth2.
  12. But you should not skip a hierarchy like Parenth1, Parenth3.

No comments:

Post a Comment