Filter behaviour differs between 5.1.3 and 5.1.4

[promero]

Supose you have two providers:

Provider P1:
D1 (Dimension)
---
A
B
C

Provider P2:
D2 D3 (Both are dimensions)
--- ---
C X
D Y
E Z

Supose <D1> and <D2> are linked. Making a table with <D1> and <D3> shows the following:

D1 D3
--- ---
A
B
C X
D Y
E Z

Up to this point, versions 5.1.3 and 5.1.4 behaves the same.

The diference arises when a filter is applied to the preceding table. The filter is applied over <D3>, and has the following expression:

=IsNull(<D3>)

On 5.1.3, the resulting table is:

D1 D3
--- ---
A
B

But on 5.1.4, the resulting table is empty:

D1 D3
--- ---

¿It's a bug on version 5.1.4? ¿How can achieve the behaviour of version 5.1.3 on version 5.1.4?

 

[promero]

I have found a solution. the trick is to force the existence of value to be filtered. The solution to the example exposed on the first message is:

1) Create a variable, call it <D3*>, with the following formula:

=Left(<D2>,0)&<D3>

Since <D2> is the linked dimension, <D3*> has value even if <D3> has not. When <D3> does not exist, <D3*> is &quot;&quot;.

2) Substitute the filter over <D3> with a filter over <D3*>, but use the original expression with <D3> for it:

=IsNull(<D3>)

This solved the problem to me. If anyone has a better solution, post it please.

 

[promero]

Following the example, I have found that combining variables of the two providers in the definition of <D3*> works better:

=Left(<D1>,0)&<D3>

With the original definition (=Left(<D2>,0)&<D3>), some measures do not show anything, and Multicube() must be used to make them work.

¿Nobody has encountered this problem (the title of the thread)?