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)?