Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Building BOM using analysis
Summary
How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levelsContent
In OBIEE, pre-built analysis "BOM" and "Where Used" did not produce any results, thereby is there a way to manually built a BOM analysis?
The output information will need to undergo further processing, so Schedule Report function in Oracle Cloud (Fusion) is not an option because information doesn't get output in excel or .cvs formats.
The analysis would need to include the following information:
• Finished product Item Name
• Finished product on-hand quantity
• Finished product ordered (sold) quantity
• Components (For all levels) Item Name