Creating Intelligent Cubes

The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. This stores the data as an Intelligent Cube, which allows you to take advantage of various Intelligent Cube features, including the improved response time of reporting against Intelligent Cubes.

After an Intelligent Cube is created, reports can be created based on the Intelligent Cube. These reports can analyze the Freeform SQL or Query Builder data, while also taking advantage of OLAP Services analysis features such as derived elements.

The steps below show you how to create an Intelligent Cube using Freeform SQL or Query Builder.

You must make the data sources to report on available for use with Freeform SQL and Query Builder. You can make data sources available for the following tasks:

To access data sources such as databases, Microsoft Excel files, and text files using the Freeform SQL Editor, see Access and Analyze Multiple Data Sources with Freeform SQL.
To access web services using the Freeform SQL Editor, see Allowing Connections to Web Services in a Project.
To access data sources such as databases, Microsoft Excel files, and text files using the Query Builder Editor, see Access and Analyze Multiple Data Sources with Query Builder.

You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. This privilege is part of OLAP Services.

To Create an Intelligent Cube Using Freeform SQL or Query Builder

Using MicroStrategy Developer, log in to a project connected to an MDX cube source.
Choose File > New > Intelligent Cube.
On the Freeform Sources tab, select one of the following options:

To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report.
To create an Intelligent Cube by creating XQuery statements using the Freeform SQL Editor, select Create Freeform XQuery report.
To create an Intelligent Cube using the Query Builder Editor, select Create Query Builder report.

In the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. Click OK.
You can now begin to create the Intelligent Cube using the standard techniques to create a Freeform SQL report or Query Builder report, which include:

Choose File > Save.
In the Object name field, enter a descriptive name for the Intelligent Cube.
Click OK.
Select Run Report to make the Intelligent Cube available to be reported on.
For important details on publishing Intelligent Cubes, including prerequisites to consider before publishing an Intelligent Cube, see the In-memory Analytics Help.
After the Intelligent Cube is published, reports can be created on the Intelligent Cube.
For steps on how to report on Intelligent Cubes, see the In-memory Analytics Help.