Hello Joel, Thanks for reaching out promptly. I have access to OBIEE and I am able to create Analysis; I also have access to Fusion. However my limits are as follows: 1) I am not given access to create Report in OBIEE. 2) In OBIEE's pre-built analyzes "Costed BOM" and "Where Used" (both located in folder "/Supply Chain…

THANKS x2!

Actually once you wrote out the e.g. example, I thought about the data again and in fact item number and raw materials relationship is indeed 1 to 1. Hope this correction help simplifies the work to come up with a solution. The number of NULL values changes continuously as item number gets added or removed. Transactions…

Hello Tom, Thanks for reaching out. I enclosed a screenshot showing the BI platform that I am working on. In case it doesn't answer your tool question, please let me know what type of functions or interface are you referring to when you say "tool"? Noted inner query option and you are one step ahead by postulating that…

Hello Christian, Thanks for pointing me to the correct forum and posting its link. All the best. Jon

Thanks for reaching out Gianni. Good point. How do I determine whether the cells are empty or NULL? The following properties are observed from empty cells in my OBIEE analysis, which the chart is mimicking: 1) The null cells are result of parsing strings from another other columns/attribute. 2) When I ran IFNULL(Raw…

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

Thank you for the detailed explanation and pointing me to OBIA. I will post my query over there. Wish you a Happy Seasons in advance. Best

Thanks for reaching out Gianni. Meanwhile, I just came across a pre-built analysis "Inventory - Onhand Balance" (located in "Shared Folder /Supply Chain Management/Warehouse Operations/Inventory") and it provides inventory on-hand value for all items. However when I filter the report to show the most recent record for each…

Can I conclude that I do not have privilege to view the report if no content is shown after I click on the report via the "Catalog" path (per enclosed screenshot) that you suggested? Meanwhile, I found out the report can be scheduled from Oracle Fusion Cloud platform. Thank you for your advise and wish you a Happy Seasons…

Thanks for reaching out. I like to export a report/analysis containing on hand inventory value for all items (finished goods and raw materials) at present. Changes depend on whether the report has already included all relevant attributes, if not, additional attributes might need to be added.