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:
[Measure] > 0 or [Measure] is not null
Does not suppress
filter function in dim data element:
filter([Company]; [Measure] > 0 or [Measure] is not null)
Does not suppress
2. Highlight zero values using conditional formating:
conditional style1:
[Measure] = 0 or [Measure] is null
Does not highlighting anything
conditional style2:
[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.
As workaround filter and conditional [Measure] > 0.1 works fine.
But how work with TM1 empty cell in reporting still interesting.
Hi,
Did you try the suppression property of a crosstab? where you can suppress zero values.
Good luck
New guy
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:
<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)