Suppress and Conditional formatting with TM1 Datasource

[manias]

Good day!

I use TM1 as datasource for Reporting.

Package with DQM enabled.
Versions: TM1/BI 10.2.2

When i creating report over TM1, i meet with trouble, i can't suppress zero values, and conditional formating with highliting zero values does not work.

I create a simple test report with crosstab, that have company in the rows and measures in column, i would like to:
1. Suppress zero value on my measure with next calculations:

detail filter:

Code Select Expand

[Measure] > 0 or [Measure] is not null
Does not suppress

filter function in dim data element:

Code Select Expand

filter([Company]; [Measure] > 0 or [Measure] is not null)
Does not suppress

2. Highlight zero values using conditional formating:

conditional style1:

Code Select Expand

[Measure] = 0 or [Measure] is null
Does not highlighting anything

conditional style2:

Code Select Expand

[Measure] > 1
Highlight everything, include zero values

For these examples, I can assume that the empty cells at the intersections in tm1 are not zero or null.
In my general report, i have many intersections which i want to suppress, but in simple test i see what i can't do it.

Someone meets with same thing? Maybe someone can explain how i need to prepare TM1 datasource (values) for reporting.

Many, thanks! Egor.

[manias]

As workaround filter and conditional [Measure] > 0.1 works fine.

But how work with TM1 empty cell in reporting still interesting.

[New_Guy]

Hi,
Did you try the suppression property of a crosstab? where you can suppress zero values.
Good luck
New guy

[manias]

New Guy, thanks for reply!
Yes, i try this feature, MDX generate with NON EMPTY function for rows, but does not result in suppression.

Blank/Zero/NULL values still available in my report output.

I already create setting in qfs_config.xml file with parameters:

Code Select Expand

<parameter name="UseProviderCrossJoinThreshold" value="10000"/>
<parameter name="UseNonEmptyOnDataQueryThreshold" value="1"/>

Additional information about qfs_config.xml (https://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page530.html)