Print Page - Error when adding Total to Crosstab

Title: Error when adding Total to Crosstab
Post by: Stejawh on 02 Dec 2008 04:14:50 AM

Hi,

When i add a total to a crosstab. I get the following error:

GEN-ERR-0011 Pattern 'manyDimensions' is not supported in 'RelationalQueryProvider'. GEN-ERR-0009 Data Source type(s) 'OL' Function 'loap_sum' is not supported in 'RelationalQueryProvider'. QFS-ERR-0130 The query is not supported. RSV-SRV-0042 Trace Back.

Any ideas?

Thanks,

Steve

Title: Re: Error when adding Total to Crosstab
Post by: Luhaine on 02 Dec 2008 08:05:32 AM

Considering that the error message contains words such as "many dimensions" and "Relational Query" it might have something to do with combining two facts from different tables without a common dimension or at least one that operates on the same level.

If this is the case, have another look at your framework and see if the two facts operate on the same grain.

Title: Re: Error when adding Total to Crosstab
Post by: wyconian on 04 Dec 2008 05:23:52 AM

Hi

How are you adding the total? From the error it sounds like you may be trying to use an olap function with a relational data source which is a no no.

Title: Re: Error when adding Total to Crosstab
Post by: Stejawh on 04 Dec 2008 10:34:42 AM

Hi,

Just the usual Aggregate and then Total....allways been ok up to now.

Thanks,

Steve

Title: Re: Error when adding Total to Crosstab
Post by: DanSev on 04 Dec 2008 11:43:44 AM

Crosstabs do not 'total' data. If you want a total, you have to add a crosstab space instead, with text to get that result.

Years
2007 2008 Crosstab Space
product Line product Type
product Type
Crosstab Space

Crosstab Space

Turn the render fact cells on in the crosstab spaces. Here is a sample using go datawarehouse (analysis)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Stejawh on 02 Dec 2008 04:14:50 AM