We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Combining data from multiple Subject Areas in FDI generates wrong results
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?
Best Answer
-
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.
0
Answers
-
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:
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
0
