3.3 Materialized View

You to create a derived entity based on a dataset, an entity or a union of derived entities. For union and union all options, the metadata used in the participating derived entities determine the columns of the physicalized materialized view. For union based derived entity, even if the participating derived entities have metadata in common, the resultant materialized view in database will ensure unique columns. The supported materialized views are:

• FCT_CRA_AGG_SUMMARY_MV - Account Dimension Materialized View
• FCT_CRA_AGG_SUMMARY_MV_APPLN - Application Materialized View

Note:

To customize or modify the derived entities, ensure that you make a copy of the derived entities and do your modifications on them since the default derived entities are overwritten with the new derived entities as part of the upcoming releases.

• To enable partition for the derived entity, turn on the toggle button in the Derived Entity Details page. For more information, see the Creating Derived Entity section in the Oracle Financial Services Analytical Applications Infrastructure User Guide.
• Ensure that you add the partition values for the Derived Entity definitions that are created with prebuilt table flag set as Y. For more information see the Adding Partition Values section in the Oracle Financial Services Analytical Applications Infrastructure User Guide.