Skip to Content
0
Former Member
Feb 23, 2009 at 03:07 PM

Hierarchy Modelling

21 Views

Dear Experts,

I am new to SAP BI world. I need your expert advice.

I am modelling a hierarchy for 0material. My client has 5 different levels for each material.

Business Unit

Department

Category

Class

Sub Class

0MATERAIL

A Business Unit can have multiple departments, a department can have multiple categories etc.

All the tranactional data will be posted at 0MATERIAL level and reports needs to be generated to allow the customer to drill down and up along the material hierarchy.

- Do i need to include all the 5 levels as NAV attributes in 0MATERIAL attributes tab ?

- We have business unit heads and Departments heads. When they execute the queries, they should get their own department of business units. Is it possible to model this in BI ?

- What will happen to history, when a material moves from one sub class to another sub class. I am not using any time dependency?

Any help is highly appreciated.

Regds,