Combining data from multiple Subject Areas in FDI generates wrong results

Roelof de Groot

We tried to combine data from multiple FDI Subject Areas (2 or more) into one report according to the design principles. In some cases the results are good, but in many cases not. We always use a common dimension/attribute and at least one fact from each subject are. Several issues can occur:

• multiple amount or quantity than the real amount or quantity
• multiple rows for the same attribute (e.g. Inventory Item)
• only one fact from one Subject Area is shown

It happens with seeded Subject Areas and also combined with a local Subject Areas.

Does anybody has the same experience and what can be the cause and solution?

RajeshPolavarapu-Oracle

Hi @Roelof de Groot

This is expected behavior in some cases. It all depends on how modelling was done internally, how joins are in place between columns across subject areas.

We advice you to raise an SR with FDI and provide more details of your reports having issues. We will go through the logs and advice accordingly.

Subha_Tripathy-Oracle

Hi @Roelof de Groot

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Please refer to below document for combining the data from multiple subject areas:

Using Oracle Fusion Analytics Warehouse

https://docs.oracle.com/en/cloud/saas/analytics/24r1/fawug/data-sources-and-subject-areas.html#GUID-30D29128-4CE9-4DF0-B408-98B004AAC18E

You can combine data sources with subject areas to explore and analyze the data.

Make sure you follow the requirements mentioned in the above document. Provide us more details on your requirement and the subject area you are combining to assist you further.

Thanks

Subha

pwc123

Are there any standard guidelines somewhere for combining multiple subject areas within an FDI workbook?