How to display item structure entries/data in Analysis in OBIEE

Jonathan Chan gmg

Hello Oracle Community,

Could you help comment on the possible resolution on how to setup the following on-hand inventory analysis in OBIEE please?

1) Application: OBIEE v.11.1.1.9.0

2) Question: In Analysis, which dimension(s) should be included in order to show entries/data from Item Structure Details (per enclosed picture attachment "Item Structure") in Fusion?

3) Goal: Setup an analysis report that shows the following entries (per enclosed picture attachment "Goal - Analysis"):

i) On-hand quantity for a bottom level item (Lowest level raw components).  The correct dimension in OBIEE has been found.

ii) Raw component item description (ex. Lemon).  The correct dimension in OBIEE has been found.

iii) Level 1 (one level above raw component) component/product item description (ex. Lemon soda single can).  Unable to find the correct dimensions(s) to show relevant entries/data.

iv) Top level finish product item description (ex. Lemon soda 4 can casepack).  Unable to find the correct dimensions(s) to show relevant entries/data.

4) Below attempts to add item 3iii) & 3iv) from above had resulted in errors:

• Including "Item Structure Type" dimension from the following dimension folders under "Supply Chain Planning Real time" subject:

- "Order Details", "Inventory Item", Planning Item 1".

• Including "BOM Level" dimension from the "Rollup Details" folder dimension under "Costing - Cost Rollup Details Real Time" subject.

• Including "BOM Level" dimension from the "Where Used Details" folder dimension under "Costing - Where Used Details Real Time" subject.

Your comments or insights are much appreciated.

Thank you.

Jon