How to manually map OLAP objects to the underlying SQL database objects

English Query

English Query

How to manually map OLAP objects to the underlying SQL database objects

When English Query is unable to acquire the information from a Microsoft® SQL Server™ 2000 Analysis Services server to map an OLAP cube to its underlying SQL table while creating a mixed model, the mapping information must be obtained manually or the project will not build properly.

To manually map OLAP objects to the underlying SQL database objects

  1. In the Project Explorer window, double-click the module (.eqm).

  2. On the Model menu, click Import Tables.

  3. On the Provider tab of the Data Link Properties dialog box, double click Microsoft OLE DB Provider for SQL Server.

  4. On the Connection tab, select or enter the name of the server on which the SQL database resides.

  5. Enter the log on information.

  6. Select the database containing the SQL database objects.

  7. Click OK.

  8. In the New Database Tables and Views dialog box, select all of the tables used by cubes and dimensions that are being mapped.

  9. Click the OLAP tab and expand Cubes.

  10. Double-click each cube to map.

  11. In the OLAP Cube dialog box, select the appropriate table and field for each measure that needs to be mapped and then, click OK.

  12. Repeat steps 10 and 11 until all of the cubes are mapped.

  13. Expand Dimensions.

  14. Double-click each dimension that to map.

  15. In the OLAP Dimension dialog box, select the appropriate table and field for each level and member property and then, click OK.

  16. Repeat steps 14 and 15 for each dimension to map.

    Note  All OLAP objects except calculated measures must be mapped to a SQL database object.