10.6 vs 11.2 dataflow with different behavior

Carlos Troncoso

I create a dataflow that works fine in 10.6 and has different behavior in 11.2. The dataflow layout has a cube called Cubo1 type Integer, an entity called Seleccion1 which has 2 members and a target text cube called dummy2. with no selections, I expect at the end of the dataflow that cube dummy2 should have value "2". That is what it has in 10.6. In 11.2, it has "1".
This is the inspect data

which says that Seleccion1 (block b) and calculo (block c) has value 2
but, after running the dataflow, we have

I think that it does not make sense...
Did anyone find the same problem?

Thanks

------------------------------
Carlos Troncoso
Manager
Intuitive BI (BOARD Argentina)
Argentina
------------------------------

Johannes Blischke

Hello,

did you test the new feature "temporary cubes" in dataflows?

Do you just want to know, which number of entity elements do you have?

I suggest to try the following:

1. Create a temporary cube with two dimensions --> entity which should be counted and target entity of your Cube
2. First dataflow should be "Temporary Cube = 1"
3. Second dataflow should be "Target Cube = Temporary Cube"

This should give you the desired result. 
If you have any further questions, don't hesitate to reply.


Best regards
Johannes

------------------------------
Johannes Blischke
Consultant
Board Community
Germany
------------------------------
-------------------------------------------