Oracle AI and Analytics

Sisanda

Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has no assets. Is there a way we can remedy this on the BI Platform? we have thousands of projects, and it would take a long time for the planners to populate the data manually.

Daniel Ryan

Hi @Sisanda

This looks like an OTBI analysis. If that is the case then it can only report what is in Fusion.

If it is OAC, do you have any dataset that has all the information in it? If you do, you have two options:

1. Load the data as a dataset directly in OAC and then add it to your workbook. You should be able to combine these effectively as long as you have common key information
2. You can load the data directly into the OAC data Warehouse as a standalone table and then use the semantic modeller to combine these tables.

Personally, I am not a fan of either of these approaches as the data should really be representative of the source. Is there perhaps a spreadsheet loader you could use for Project/Asset information?

Dan