Create a New Profitability Model

  1. Open the Model wizard.
    1. Click the Organize Models icon (or select File Organize Models ).
    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 Add Dimension Tables window or from 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.
  8. The new profitability model appears in the Organize Models window. Click Close.

Related Topics: