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 Style issue(?)

Started by MMcBride, 28 Feb 2012 11:24:21 AM

Previous topic - Next topic

MMcBride

It may be the data I am bringing in or it may be the way I set my condition...

Here is what I am seeing:
In Report Studio from a PowerPlay Cube source I have 2 measures.

Net Earned Premium
Net Earned Premium2

Net Earned Premium is calculated at the Data Mart level and in the cube is a straight mapping.
Net Earned Premium2 is a calculated within the Cube

Essentially what we are doing is the first release of the Project had General Ledger measures at a certain level, now in Release 2 we are drilling into the measures and providing much more detail. But this is just informational...

I build a Simple Cross Tab Report that allows the users to view both Measures Side by Side
I have the Measures as Columns and Business Unit as rows.
Both measures go to the 4th decimal in the cube.

I then created a Conditional Variable - boolean
NEP = NEP2
On the report if "N" then Color Cell Background "Red"

If the Measures don't match the Conditional Variable is 100% perfect and always shows red.
However... when the 2 do match the conditional variable is roughly 95%...

So 5% at apparent Random times I get "false positives"
I have taken the measures out to 9 decimal places thinking there was an issue in aggregation but the 2 numbers are perfect to the 9th decimal place but for some reason this conditional style still shows a "Red"

The same report in 8.4.1 never returns a "False Positive" only in version 10.1.1

Has anyone else seen anything like this?
Or should I simply stop using a Boolean for this, create a Variance Data Item and us a "if NEPVar = 0 then "White" else "Red"?  - Different Conditional Formating that I use in different reports that seems to work perfectly fine in 10.1.1