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

Crosstab limitation of nesting measures from 3 or more facts?

Started by CognosDeveloper, 15 Apr 2009 10:49:58 AM

Previous topic - Next topic

CognosDeveloper

Hello,

I am currently receiving an error when I add a measure into a crosstab
from a third underlying fact table.  At least this is the reason that
I believe is the cause for the relatively uninformative error below.

RQP-DEF-0177 An error occurred while performing operation
'sqlPrepareWithOptions' status='-9'.

Details contain info about table or view does not exist.

I have confirmed that all measures exist and return successfully
within cognos connection tools (report studio, query studio, and analysis studio).  The database is Oracle (mostly star schema) with a FM DMR built.

Crosstab structure that errors:

Columns (Level 1): Fiscal Months
Columns (Level 2): Sales measures, Inventory measures, Markdown measures

Rows: Stores

In this example, the Sales measures, Inventory measures, and Markdown
measures are located in separate database fact tables.  I am able to
return successfully the same data set within a list object and within
a crosstab object where the columns do not contain more than one
level.  If I remove any one subject of measures (either Sales, Inventory, or Markdown), then the crosstab processes successfully.

Do you have a workaround or is this a limitation within Cognos v8.3 SP3?

I appreciate your insight.