You should investigate the Cognos 8 BI Server Updater 8.1.209.78 Hotsite.
The bug fix list includes:
529478 Cross-Join error when viewing level joined between regular and measure dimension.
Perhaps this will address your problem.
Contact cognos for the details.
This is the most complex join expression I've used between two tables.
HR.PERIOD_CODE BETWEEN
MAP.FROM_PERIOD_CODE AND MAP.TO_PERIOD_CODE
AND HR.FIGURE_TYPE LIKE MAP.FIGURE_TYPE
The query generates OK and it runs without problems.
I've had a similar problem and had it confirmed that it's a ReportNet bug. Basically, in a crosstab conditional formatting can only be applied to the same column that the value resides in. It can't be applied to another column.
Here is an excerpt of a response from Cognos support:
"I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.