Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 196 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to change common time joins
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!
Comments
-
Hi Branden,
You should be able to resolve this with Semantic Model Customizations. Do you have Admin access or able to work with an Admin on this? See "
Customize Oracle Fusion Data Intelligence" chapter below.
https://docs.oracle.com/en/cloud/saas/analytics/25r1/fawag/customize-oracle-fusion-data-intelligence.html
Thanks, Jay0