Data Flow functions

Pontus Andersson Frid · 2024-02-29T08:56:14+00:00

There was an error rendering this rich post.

Pontus Andersson Frid

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

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.
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".

Find more posts tagged with

Open For Voting

Dataflow

Status: Open For Voting

Comments

Hamza Mesbahi

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.

Regards,

Hamza

Pontus Andersson Frid

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…