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

Conditional Formatting in DMR

Started by deepak2k2, 15 Feb 2011 03:05:54 AM

Previous topic - Next topic

deepak2k2

Hi,

I'm using Dimensional Model in Cognos 8.4.

I've created conditional formatting with my simple condtion in a crosstab.  But its not working.  Ex:  Crosstab with 4 columns (3 months of data and its average).   Defined a contion as
[Query1].[Revenue]>[Query1].[Avg].

Revenue   Jan   Feb   Mar   Avg
A   10   20   30   20


The above query is not working (comparing 2 data items).  If I compare with static value (revenue>20), then its working.

What was wrong in the query?