Intelligent Cubes provide access to a single set of data that can be shared among multiple reports and analyzed with OLAP Services,while reducing access to the data warehouse.
Intelligent Cube Creation
There are two ways to create an Intelligent Cube:
From scratch using an Intelligent Cube editor
From an existing report
Sharing of Intelligent Cubes
Intelligent Cubes provide the fast response time and analytic calculations that are often associated with Multidimensional Online Analytic Processing(MOLAP) cubes.
They also provide the ability to use Relational Online Analytic Processing (ROLAP) by drilling into the full set of data outside of the Intelligent Cube
The following list of objects and features cannot be included in the definition of Intelligent cubes:
Consolidation and Custom groups
OLAP services features
View Filter
Derived Metric
Derived Elements
Prompts
The following prompts are supported in Intelligent cube only in design mode:
Element Prompt
Attribute Qualification Prompt
Metric Qualification Prompt
Value Prompt
Object Prompt
Advantages
of Intelligent cubes
Executes against Intelligent Cubes instead of data warehouse
Improved performance
Single Intelligent Cube for multiple prompted reports
Can only access data available within Intelligent Cube
Dynamic sourcing is of the added feature in I-cube
