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

[CC] List of problem after Migrating C7 reports to C8

Started by sili, 20 Jun 2007 01:41:40 AM

Previous topic - Next topic

sili

Hi all,

We have around 200 ReportNet (C7) reports just migrated to C8 and we have around 10% of them got problems in running. To list of a fews them:

Problems:
1) Error Message saying:
The level reference based on the item 'More General Statistics Dimension Key' in the query 'Query2-a' is not used as grouping key in the result.
2) Error Message saying:
An error on or around the position '7'. The variable named '[Query1].[Unit Price Summary Code (All)]' is invalid.

Resolution
1) No clue at all.
2) It is related to Conditional Style. I used "Copy Report to Clipboard" and remove the <conditionalsytle> section. The report runs fine (with no conditional style). The quirks are when I RECREATE the conditional style, the error come again.

Other question:
1) Can I get a particular query (may/may not based on another query) "Generated SQL/MDX" (Cognos+Native SQL)?