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