10.6 vs 11.2 dataflow with different behavior

Carlos Troncoso
Carlos Troncoso Active Partner
Second Anniversary
edited April 2020 in Platform
image
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

image

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

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

Thanks








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

Answers

  • Johannes Blischke
    edited May 2020
    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
    ------------------------------
    -------------------------------------------