a report that accesses an Intelligent Cube
You can perform
all of your reporting and data analysis requirements within an Intelligent
Cube without executing against the data warehouse. Once an Intelligent
Cube is created and then published so its data is available, multiple
reports can be created to connect to the Intelligent Cube.
Reporting on a shared Intelligent Cube provides
quick access to data as the data has been pre-aggregated. This returns
report results much faster than querying the data warehouse. Reporting
on Intelligent Cubes also allows you to use all of the OLAP Services features,
including derived elements. Derived elements allow you to group attribute
elements in a report on-the-fly to provide a new view of report data for
analysis and formatting purposes.
Reports that connect to an Intelligent Cube
are restricted to only the data available within the Intelligent Cube.
This ensures that report results are returned quickly, and it also prevents
full ROLAP analysis. Report filters, consolidations, and custom groups
are not available for reports that connect to Intelligent Cubes. For a
full comparison of personal Intelligent Cubes and Intelligent Cubes, see
the In-memory Analytics Guide.
security filters are used to maintain data access security, there are
some differences in security filter resolution for reports connected to
Intelligent Cubes. For information on these differences, see the In-memory Analytics Guide.
||To create a report from a cube source,
you must have the Web Professional privilege called Web Define Intelligent
Intelligent Cube has been created and published.
To create a report that accesses an Intelligent Cube
||Click the MicroStrategy
icon at the upper left of any page
and select New Report.
Intelligent Cube. The Select Cube Report dialog box opens.
||Browse to and select a previously
saved Intelligent Cube on which to build your report.
The report opens with all the objects of the Intelligent Cube included
in the Report Objects pane on the left.
||Drag and drop the objects into
the report grid from the Report Objects pane.