Intelligent cube
Intelligent cubes are multi-dimensional, in-memory copies of data that can be queried and accessed by many different documents and reports. Basically, the cube is allocated on the Intelligence Server machine and uses either memory or disk to store the definition and perform fast data retrieval.
We can treat it as a database where data is pre-cached and quickly accessed. To improve the report execution performance and response time, it's good to run the report with significant wait time and high usage against intelligent cubes. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube.
The steps to create an intelligent cube are as follows:
Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports.
Select the report from which you want to build an intelligent cube. Edit and enter the report editor.
Select Data | Intelligent Cube Options | Convert...
