Previous Page | Next Page

Maintaining OLAP Groups and OLAP Summary Data Stores

Example: Using One Analysis Column for Multiple Statistic Columns

Overview

Suppose you want to use a specific column from input data to generate multiple statistics for your summary data. That is, you want to use one input analysis column for multiple output statistic columns. To produce the appropriate statistics:

  1. Add the additional column(s) to the summary data store.

  2. Assign each added column as a statistic column, using the appropriate statistic.

  3. In the Mapping process for the summary data store, map the added column(s) to the analysis column.

Note:   The following explanations describe only the metadata and methods that specifically apply to this example.  [cautionend]

Add Columns to OLAP Summary Data Store

This explanation adds two numeric columns named minrevenue and maxrevenue to an OLAP Table. You add columns from the Columns tab in the object's properties window, which for this example is the OLAP Table Properties window.

Columns Tab

specifies the columns to be included in the summary data store. To add a column that does not exist in the input data, define the column's attributes (name, type, length, description, format, and informat), and then click Add. The result of adding two columns to store generated statistics is as follows:

[untitled graphic]

Assign OLAP Summary Roles to the Columns

On the Columns tab, click OLAP to open the OLAP Column Roles window from which you assign specific OLAP summary roles.

Assign the minrevenue and maxrevenue columns as statistic columns, using the statistics MIN and MAX, as follows:

[untitled graphic]

Define Mapping Process in Process Editor Job

The added statistic columns, shown in the following Mapping Process Properties window, must be mapped to the analysis column.

[untitled graphic]

To map the added statistic columns to the analysis column:

  1. From the Column Mapping tab in the Mapping Process Properties window, select the column, such as minrevenue.

  2. Click 1-to-1 Mappings to open the One-to-One Column Mapping window as follows:

    [untitled graphic]

  3. Select the analysis column from under the label Source Column.

  4. Select the statistic column from under the label Target Column.

  5. Click the right arrow to map the two columns.

    [untitled graphic]

When you click OK, you are returned to the Column Mapping tab in the Mapping Process Properties window as follows:

[untitled graphic]

Previous Page | Next Page | Top of Page

Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.