Process example

This topic outlines the typical process for adding and loading custom properties.

Assume that the Analysis 1 business object holds details of products. The Staging database has a table with the same product details but, additionally, has details of quantity per unit, reorder level, and whether a product is current or discontinued.

This outlines the process to add quantity per unit (QPU), reorder level, and discontinued as custom properties of Analysis 1.

  1. In Business Modeling, select the Analysis 1 business object.
  2. Add custom properties QPU and Reorder_Level, both of type String.
  3. Add custom property Discontinued, of type Boolean.
  4. In EPM Administration, select Dashboards > Data Integrations > Relational Modeling.
  5. Select EPM Integration as the target connection and select the Analysis table.
    Notice that, on the Schema tab, columns have been added for the three custom properties. Each column is headed by the property name, prefixed by CST_ .
  6. Click the Load Queries tab.
    Typically, this will already contain a query to load data from the Staging database. Update the query to include the new properties. For example: 
    select
ID as ID
,ParentID as ParentID
,ElementType as ElementType
,Weight as Weight
,Name as Name
,QPU as QPU
,ReorderLevel as Reorder_Level
,Discontinued as Discontinued
from 
Products
  7. Preview the data to be loaded.
  8. Click Load and select Load Data.
    In this example, the option to load columns and data is inapplicable because the columns in the integration database already exist, and they are protected.
  9. In Business Modeling, update the Analysis 1 business object.
    For example, to do a manual update, click Import and select the Add/Update option.
  10. Publish the model.
    The custom properties are available for use in, for example, custom reports.