Oracle Fusion Data Intelligence

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

Has anyone been able to successfully add calculations to a subject area?

Question
12
Views
0
Comments

I'm trying to use the SCM - Sales Orders subject area. The metrics that it gives me are fine but not exactly what I need. I am trying to do a calculation in the subject area using existing measures on the fact. For example, Ordered Qty * conversion rate = New Ordered Qty Metric. By doing this, I am required to add the content level hierarchy for each new measure I create. This is near impossible to do because there are dozens of dimensions and there's no documentation on what the logical hierarchy is. This is a VERY time consuming task to guess at what the levels are and then add them for every new metric created.

Am I the only one trying to do this? Or is everyone else resorting to using the external RPD merge to do basic semantic modeling because the wizard lacks the ability? Or maybe someone has a shortcut they would love to share with me?