Ability to extend facts in SME and inherit hierarchy level-based aggregation

Branden Pavol

The out-of-the-box quantities for subject areas do not work with my company. I need to do a very specific UOM conversion to get everything into Lbs. Using the primary and secondary quantities do not work with our setup. I created a table in the DW that has all items and how to convert them from their primary UOM to Lbs with conversion rates. That means I need to be able to multiply every out-of-the-box metric by my conversion rate. I attempted to do this and failed quickly.

Oracle needs to add:

• Ability to extend the fact tables
• Ability to create new metrics and then choose to inherit content leveling from another metric

For example. I am taking Quantity Ordered from SCM - Sales Orders times UOM Conversion Rate. I should not need to add the hierarchy level-based aggregation since that is already established for Quantity Ordered. Or if I need to, I should to be able to copy the hierarchy from an existing measure. Depending on how big the subject area is, there can be dozens of dimensions that would need to be added. Plus there is no documentation on what those logic dimensions even are.

I would have to add all of these dims in the aggregation.

OR….

Let me create a View of the out of the box facts and then let me copy all the existing joins and content leveling based on an existing SA.

Ramamurthy Shankarachetty-Oracle

Hi Branden, Thank you for sharing the Idea. Today we dont support converting all UOMs into one UOM for analysis. Krishna Prasad Kotti from our team had discussed with you regarding this. We will look into this and wait for voting from other customers. Mean time, we will do analysis and suggest you a work around to handle this need.

Regards,

Ramamurthy