If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Error when adding Total to Crosstab

Started by Stejawh, 02 Dec 2008 04:14:50 AM

Previous topic - Next topic

Stejawh


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

Luhaine

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.


wyconian

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.

Stejawh

Hi,

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

Thanks,

Steve

DanSev

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)