Extended Fact (similar to an Extended Dim)?

R. Park

Oracle provides many good subject areas and fact tables in the Autonomous Data Warehouse. If I need to provide additional custom "fields", I can create a custom extended dim and join the extended dim to an out-of-the-box dim, allowing you to pull in those custom columns into an existing subject area on a dimension.

Is there a way to do this for a fact table—an extended fact? We know that you can create some "calculated"/derived objects in the Semantic model for the Fact table, but there are two concerns with this approach. 1) We we have some complex calculations that we want to store in the database itself. 2) running complex calculations as a "calculated"/derived object in the semantic model happen at runtime, so performance on the query is slower.

Ashish-Oracle

@R. Park There is no way to extend a fact table as of now using Semantic Model Extensions.

In case you feel this feature will be helpful I would suggest you log an Idea Labs request with the Business justifications for the PM team to check on the feasibility of the feature being requested.

Oracle Fusion Data Intelligence Idea Lab