Data Flow functions

Pontus Andersson Frid
Pontus Andersson Frid Active Partner
Second Anniversary First Comment
in Idea Exchange

I would suggest two new functions in a procedure Data Flow.

  1. A setting in the step that would make the dataflow work similar to the Data Reader setting "Replace Time Slice". This would sometimes reduce the need to pre-clear the cube before repopulation in the datafloe.
  2. A setting in the step that would mimic the Data entry function of "Splat splatt" when we flow from a parent down to a child. This would be usefull in allocation logic or some budgeting procedure were it would replace the need for tempcubes with a "allocation purpose".

Tagged:
4
Up
4 votes

Open For Voting · Last Updated

Comments

  • Hamza Mesbahi
    Hamza Mesbahi Employee
    Second Anniversary 10 Comments April Badge of the Month 5 Likes

    Hi Pontus,

    Thanks for your suggestion.

    I just wanted to note on your first point, that data flows do run in "replace mode" by default for your active selection in Board. You only need to use the clear cube steps in very specific instances. In general, if you're flowing data between cubes, the source cube data will always replace the target cube data for the same cells, it won't add to it as the "Add" data reader option would do.

    image.png

    Regards,

    Hamza

  • Pontus Andersson Frid
    Pontus Andersson Frid Active Partner
    Second Anniversary First Comment

    Hi,

    yes a dataflow replaces based on the selection its run on. But the replace time slice replaces off values in the PERIOD its run on…

    So a dataflow run with no values on entity member Y in period p1 will not replace the target cube on Y to 0 since its not in the source.

    A datareader with replace time slice would…

Categories