Error Characters (--) Appear in Reports

When you run a report, you see two dash (--) characters in your report instead of values.

These characters may appear if you use an OLAP data sources other than PowerCube and Microsoft SQL Server 2005 Analysis Services (SSAS), and you apply aggregation to calculations and measures that use rollups other than Sum (Total), Maximum, Minimum, First, Last, and Count.

All other types of rollup either fail or return error cells, which typically display as two dash characters (--).

This problem occurs in, but is not limited to, the following:

footers
aggregate function
summary filters and detail filters that use a summary
detail, summary, and context filters that select more than one member of a hierarchy that is used elsewhere on the report

If you are working with a SSAS 2005 data source, these characters may also appear in summary cells if you use an OR filter in the summary. To avoid this problem, do not use OR filters in summaries.