Skip to main content
Solved

Cube view filter gives strange data


The filter on the cube view does niet give the expected results. How is this possible? 

See image below, the filtered results are in the range until - 10.000, however, I see different results. It does not matter if the check ‘apply to specific level’ is on. Could anyone help me with this odd situation?

 

Best answer by Mark Jongeling

Hi,

I think this may be because of that the Filter works on the dataset whilst the GUI is showing a #value which may be something like a Sum. I doubt the component can handle filtering on values after calculations.

View original
This topic has been closed for replies.

3 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi,

The screen says its for the Column field "Eindtotaal” but the red box is around the field "Resultaat”. Are these the same fields? 


No, but this is the filter screen you get when filtering the fields ‘resultaat’. 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi,

I think this may be because of that the Filter works on the dataset whilst the GUI is showing a #value which may be something like a Sum. I doubt the component can handle filtering on values after calculations.