Oracle Fusion Data Intelligence Idea Lab

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

Ability to change common time joins

Needs Votes
62
Views
3
Comments
Branden Pavol
Branden Pavol Rank 6 - Analytics Lead

In the FDI subject areas, the time dimensions are usually anchored to a date. I need to have the ability to change those anchor dates. For example, the SCM - Sales Orders subject area is anchored to the Ordered Date. That does me no good when I want to trend open sales orders. I might be unique but no one cares when the order was taken. They want to know when the order is scheduled to ship. And if I need to combine this with another subject areas like SCM - Manufacturing Work Orders, it's going to join based on the ordered date. I want to be able to see a combination of when my work orders are going to complete as well as my when my sales orders are scheduled to ship. Then I can make sure those dates are aligned. I have no ability to do that without creating a custom data set. I can't even create my own subject area with a different common time. My hands are tied. Please give us back control of the semantic layer!

image.png
8
8 votes

Needs Votes · Last Updated

Comments