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,