In This Section:
After the model has been created, you can query the database to display the model artifacts as output in a database view.
An Administrator can create database views in the system database that mirror the columns used in the staging tables, showing the model data that is stored in the system:
Stages (HPM_EXP_STAGE)
POVs (HPM_EXP_POV)
Drivers (HPM_EXP_DRIVER)
Driver Selections (HPM_EXP_DRIVER_SELECTION)
Assignments (HPM_EXP_ASSIGNMENT)
Assignment Rule Selections (HPM_EXP_ASGN_RULE_SELECTION)
After installation, a SQL script, create_sql, is included in the application folder. The default location is EPM_ORACLE_HOME\products\Profitability\database\Common\Oracle2. The script create_sql, which contains the SQL queries for artifacts within the model, must not be modified; however, after the database specific views are created, you can create your own views by copying existing views and then modifying the copied views.
Error messages for each table are self-explanatory, and are presented in the format ERROR_<Error Condition> For example, ERROR_NAME_NOT_FOUND, or ERROR_DUPLICATED_DIMENSIONS.
To create model definition data database views:
Connect to the database server that contains the Profitability and Cost Management application and the schema, and locate the create_sql script.
Locate the create_sql script to create Database Views in the default location for your database type:
EPM_ORACLE_HOME/products/Profitability/database/Common/MSSQLServer/view
EPM_ORACLE_HOME/products/Profitability/database/Common/Oracle/view
Run a query to create a database view against your Profitability and Cost Management database.
Open the view to display a list of the requested model definition data.
Repeat step 3 and step 4 for each view that you want to create.