About Importing Metadata From Oracle EPM Cloud Planning Data Sources

Use this topic to understand how Semantic Modeler structures the data you import from an Oracle EPM Cloud Planning data source.

When you import an Oracle EPM Cloud Planning data source into the semantic model:

• The imported data source contains multiple value columns to support measures of different data types.

• Some measures specific to Oracle EPM Cloud Financial Consolidation and Close aren't imported with Oracle EPM Cloud Planning data sources.

• The Attribute property has additional sub-properties, such as IsReadOnly. These properties are also exposed as additional columns.

All Oracle EPM Cloud Planning dimensions are modeled as parent-child hierarchies in the physical layer. Shared members, alternate hierarchies, and unbalanced hierarchies are supported.

Dimension member properties are exposed as columns such as Name, Description, and ShortName. An additional column called Sort Order is also displayed for each dimension. This column contains custom sort information retrieved from the data source.

Each Oracle EPM Cloud Planning dimension has a corresponding Point of View (POV) value that provides customized information for different users. This POV value is used as the Default Member in the physical hierarchy's properties upon import. You might need to update the default values according to the users' needs.

Be careful to not set the Default Member property to All for Oracle EPM Cloud Planning hierarchies.