Chapter 6 Working with PDMs

Creating a relational to multidimensional mapping for a fact

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

  1. Open the property sheet of a fact and select the Mapping tab.
  2. Click the Create Mapping tool beside the Mapping list to create a mapping for the current fact. If several data sources are available, you have to select one or several data sources in the selection list and click OK.
  3. In the Fact sources sub-tab, click the Add Objects tool to select the tables you want to map to the current fact.

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

    The selected measures 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 measures and columns with identical name or code in the data source

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

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

For more information on the cube query, see section Defining the query of a cube.

 

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