Implementation Tools

Implementation Tools

You use the following tools during the implementation process:

• Tools available from the Business Intelligence section of the Management Portal:

  • Architect — Use this to define cubes and subject areas. Here you can also compile and build cubes (and compile subject areas).

  • Analyzer — Use this to examine cubes and subject areas when validating your model. Later you use it to create pivot tables.

  • User Portal — Use this to define dashboards.

  • MDX Query Tool — Use this to create MDX queries and view their query plans.

  • Folder Manager — Use this primarily to export pivot tables and dashboards so that you can package their definitions within an InterSystems IRIS class.

    You can also use it to associate resources with folders.

  • Settings option — Use this to specify the appearance and behavior of the User Portal, and to define variables that can be used in dashboards.

  • Business Intelligence Logs — Use this to see the Business Intelligence build log for this namespace.

• Terminal — You can use this to rebuild cubes and to test methods.

• MDX shell (running in the Terminal) — Use this to examine cubes and subject areas and to create custom MDX queries and see their results.

• Other sections of the Management Portal — Use these to map globals, define resources, roles, and users for use with Business Intelligence, and to examine the Business Intelligence fact tables if wanted.

• Utility methods:

  • %DeepSee.UtilsOpens in a new tab includes methods that you can use to build cubes, synchronize cubes, clear the cell cache, and other tasks.

  • %DeepSee.UserLibrary.UtilsOpens in a new tab includes methods that you can use to programmatically perform the tasks supported in the Folder Manager.

• The data connector class (%DeepSee.DataConnectorOpens in a new tab) — Use this to make arbitrary SQL queries available for use in cubes and listings.

• The result set API (%DeepSee.ResultSetOpens in a new tab) — Use this to execute MDX queries programmatically and access the results.