Chapter 6 Working with PDMs

Creating a relational to multidimensional mapping for a dimension

Steps To create a relational to multidimensional mapping for a dimension:

  1. Double-click a dimension to display its property sheet.
  2. Click the Mapping tab.
  3. Click the Create Mapping tool beside the Mapping list to create a mapping for the current dimension. If several data sources are available, you have to select one or several data sources in the selection list and click OK.
  4. In the Dimension Sources sub-tab, click the Add Objects tool to select the source tables you want to map to the current dimension.

    The name and code of the tables appear in the list.
  5. Click the Attributes Mapping sub-tab and click the Add Mapping tool in the toolbar.
  6. Select the attributes that will be mapped to columns in the source tables or views and click OK.

    The selected attributes appear in the first column of the list.

    Note   Generate mapping
    You can click the Generate Mapping to tool to automatically create the mapping between attributes and columns with identical name or code in the data source.

  7. Click the down arrow in the "Mapped to" column to select the column in the data source table to which the selected attribute will be mapped.

    You have to repeat this operation for each attribute you want to map to the data source.
  8. Click the Criteria sub-tab if you want to specify join criteria between the source tables.
  9. Click the Select sub-tab if you want to visualize the entire statement.
  10. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.