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.