OLAP Project Wizard
Collapse the table of content
Expand the table of content

OLAP Project Wizard

SQL Server 2000

OLAP Project Wizard

Use the OLAP Project Wizard to automatically create entities and relationships for all OLAP objects in the cubes selected in the New OLAP Cubes dialog box.

The OLAP Project Wizard suggests a set of entities and relationships for all dimensions, levels, properties, and measures and the fact table for the cube.

Note  If the same OLAP level appears in more than one dimension or hierarchy, or if more than one OLAP level uses the same database table and fields, entities will not be created for subsequent levels using the same table or fields.

When creating a project using the OLAP Project Wizard, you enable OLAP only. Therefore, questions generate only Multidimensional Expressions (MDX), not SQL statements. Also, some dialog box options will not be available. For example, you cannot create relationships that associate entities with fields so there is no Database tab available in the Relationship/New Relationship dialog box.

However, after the project is created, you can enable SQL using the Data Connection tab of the Project Properties dialog box. The resultant mixed model uses data from the OLAP cube or the SQL database tables and fields that underlie the OLAP objects. Enable SQL when questions:

  • Cannot be answered using OLAP cubes only because the data is not in the cube but in the underlying SQL database.

    For example, "What is the SKU of the product that sold the most" produces no results using only OLAP cubes because the SKU data is not in an OLAP cube. It is in the underlying SQL database.

  • Are not about the aggregation of data.

    Although using OLAP cubes allows the application to answer this type of question, OLAP performance may be slower than using SQL tables. In a mixed model, English Query uses the data that produces the results in the quickest manner. For example, for questions such as "What products do people buy," enabling SQL may speed up retrieval of the data. In mixed models, English Query initially tries to answer the question using MDX. If MDX is insufficient, English Query will use SQL statements.

When using mixed models, make sure that the OLAP cube is current with the underlying SQL database. Each time that a question is asked, English Query creates a new query using the appropriate database. If the OLAP cube is not current, the user may get different results with an MDX query than with an SQL query.

See Also

Data Connection Tab (Project Properties Dialog Box)

Database Tab (Relationship/New Relationship Dialog Box)

Developing and Deploying English Query Applications

How to add or change an Analysis Services (formerly OLAP) connection

How to create a project using the OLAP Project wizard

Icons and Cursors Used in English Query

Naming Entities in the OLAP Project Wizard

New <Database Object> Dialog Box

© 2016 Microsoft