Mapping Hierarchies from relational DB into BW / BI

[Former Member]

Hello Specialists,

I built an InfoCube based on a relational database. This DB follows the “star schema” with 2 levels depth as follow:

1. The Facts table, where each entry represents a transaction with Material_ID and date of sale.(more than 300.000 entries)

2. The Material table ( Material_ID, Manufacturer_ID, Material_NM ) (about 10.000 entries)

3. The Manufacturer table ( Manufacturer_ID, Manufacturer_NM, Manufacturer_Region) (about 20 entries)

I followed an intuitive logic:

- I set Manufacturer_ID, Material_NM InfoObjects as attributes to the Material_ID InfoObject.

- I set Manufacturer_NM, Manufacturer_Region InfoObjects as attributes to the Manufacturer_ID InfoObject.

All the master/transaction data are extracted and transferred correctly.

1. My Problem is how to query on sales according to Manufacturer_Region?

2. Is there any solution to map the relational DB hierarchy to BW InfoObjects hierarchy? I looked around; all I found is to load a hierarchy from an extra flat file or BAPI, whereas I’d like to transfer data from the DB directly.

I’m using SAP NetWeaver 2004s BI 7.0.

Thanks in advance

Karim

[former_member181887]

Hi Karim,

I would suggest that you post this in the 'Data Warehousing' or 'BI General' forum under the Business Intelligence area. I don't think you will find too many BI people in the platform forum so your question might not get answered - I might be wrong, I frequently am so this is just a recommendation!

All the best,

Mike,

[Former Member]

Thank you Mike, I'll move it now