3. Create a New Profitability Model

A profitability model contains the following tables:

• Behavior
• Period Dimensions
• Transaction (organized into table groups)
• Custom Dimensions
• Report Hierarchy
• Report Layout

To create a new profitability model, perform the following steps:

1. Open the Model wizard.
   1. Click the Organize Models icon (or select File Organize Models ).
      

      The Organize Models window opens.
   2. Click New Model.
      
      The Model wizard opens.
2. Name the model and select the time dimension.
   1. On the Information page, name the model.
   2. Click Select to select the time dimension for the model.
   3. To preview the data in the time dimension table, click Preview.
   4. Click OK, and then click Next.
3. Select the analysis view and output libraries.
   1. On the Analysis View and Output Library page, name the analysis view.
      
      The analysis view name is used as the name of the database view that is created to join the transaction output tables into a single virtual fact table that the OLAP cube is built from. By default, its name is the same as the model name.
   2. Click Select to select the analysis view library (the library in which the analysis view is stored).
      
   3. Click Select to select the output library for analysis results. The output library can be the same as the analysis view library, but doesn't have to be.
      
      Note: To use a non-SAS database for the output library, you must specify its DBMS type.
      
   4. Click Next.
4. Confirm storage locations.
   1. On the Data Location page, verify storage locations for external data.
      
      Note: The storage locations were established during installation. You do not have to change them now.
   2. Click Next
5. Identify fields in the behavior table.
   1. On the Behavior table page, select a behavior table.
   2. To preview the data in the behavior table, click Preview.
      
   3. Identify each of its required fields, and click Next.
6. Identify dimension tables.
   1. On the Dimension Tables page, select the dimension tables.
      
      Note: It is not necessary to add the time dimension because it has already been identified as such in step 2.
   2. To preview a dimension table, select one either from the list in the Add Dimension Tables window from or the list on the Dimension Tables page, and click Preview.
      
   3. Click Next.
7. Identify the report hierarchy and report layout.
   1. On the Report Tables page, select the report hierarchy.
   2. Select the report layout.
   3. To preview the data in either the report hierarchy table or the report layout table, click Preview.
      
   4. Click Finish.
8. The new profitability model appears in the Organize Models window. Click Close.

Related Topics:

• Edit a model