OBIA Missing Relationship In C_FUNCAREA_FACTGROUP_REL For Custom Application
Last updated on MARCH 29, 2018
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.2 and later
Information in this document applies to any platform.
Missing Relationship in C_FUNCAREA_FACTGROUP_REL for Custom Application
When enabling the offerings in the BIACM for Oracle Custom Analytics, there are no Associated Dimensions and Fact Groups for the Custom Analytics Offering.
Also, there is no seeded record in the database in C_FUNCAREA_FACTGROUP_REL for the X_CUSTOM_FA FUNCAREA_KEY and X_CUSTOM_FG FACTGROUP_KEY.
In the BIACM added a new (+), but that appears to be creating a NEW fact group and/or dimension group.
However, user only want to create the relationship between the Custom Offering and existing Custom Factgroup (as seen in C_FACT_GROUP:
select * from C_FACT_GROUP where factgroup_key = 'X_CUSTOM_FG' => Custom Fact Group for Custom Facts).
User needs this to pull in the X_CUSTOM load plan with the load plan generator for a custom dimension user built.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms