Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to build a hierarchical BOM analysis showing on-hand quantity and item cost

Received Response
11
Views
2
Comments
Jonathan Chan gmg
Jonathan Chan gmg Rank 5 - Community Champion
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

In OBIEE, pre-built analysis "BOM" and "Where Used" did not produce any results, thereby is there a way to manually built an BOM analysis?  The output information will need to undergo further processing, so Schedule Report function in Oracle Cloud (Fusion) is not an option because the information doesn't get output in excel or .cvs formats.

The analysis needs 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

• Components on-hand quantity

• Components cost

I do not have access to Report building function in OBIEE, thus building a BOM Report is also not a feasible option in my case.

Thank you.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Jonathan,

    Your question relates to pre-fabricated content over which we (in here) have no control so I suggest you ask via an SR and in the OBIA forum.

    We could only answer this question if we had access to the full RPD and data level (meaning data model plus ETL).

  • Jonathan Chan gmg
    Jonathan Chan gmg Rank 5 - Community Champion

    Thanks for reaching out Christian.

    I don't have the data model nor ETL.

    However I will check with SR and in OBIA forum.

    Best