Limitations when using dimensional data sources

There are limitations when authoring or running reports against dimensional data sources.

Data modules that contain dimensional data sources
Data modules that contain dimensional data sources such as PowerCubes, dynamic cubes, TM1 data sources, and dimensionally modeled relational (DMR) data sources are not supported for reporting. Data modules that contain IBM Planning Analytics cubes are supported in reporting.
Running a Report Against a Dimensional Data Source
You can cancel a report that is running against Microsoft SQL Server Analysis Services only during the initial portion of its execution. After this time, the report runs to completion.
Limitations When Using Set Expressions in List Reports
In list reports, we recommend that you avoid using set expressions. When in a list, set expressions, such as TopCount, may produce fewer rows than in the corresponding crosstab.
Limitations When Using Clauses in Summary Functions
A summary function that uses a for clause may yield unexpected results. These may include error messages, warnings, incorrect numbers, and more or fewer than expected rows, columns, or chart points and lines.
Limited Support for Relational Functions When Used with OLAP Data Sources
When working with an OLAP data source, we recommend that you not use relational functions, such as substring and concatenation functions, in a report that also contains a measure with the Aggregate Function property set to Calculated or Automatic in the model. If you do so, you may encounter unexpected results. For example, some summaries are calculated using the Minimum function instead of the aggregate function derived from the individual query items.
Limitations When Summarizing Measures in DMR Data Sources
There are limitations when summarizing dimensionally-modeled relational (DMR) measures and semi-additive measures in crosstabs using the aggregation function count distinct, median, standard-deviation, or variance.
Limitations when filtering dimensional data sources
Avoid combining context filters (slicers) with dimensional constructs that involve members from hierarchies that are used elsewhere in the report. This combination gives results that are often not what you might expect and that may change in a future release.
Considerations when Creating Calculations
Consider the following information and limitations when creating dimensional calculations.
Limitations When Formatting Empty Cells in SAP BW Data Sources
When working with SAP BW data sources, if the SAP BW server administrator configured custom formatting for empty cells on the SAP BW server, this custom format does not appear in IBM® Cognos® Analytics reports. Ask your administrator to configure the formatting of empty cells in IBM Cognos Analytics.

Parent topic: Reporting