Data Flow with Change of Entity Element

Wolfgang Dödlinger · 2023-04-07T13:39:36+00:00

There was an error rendering this rich post.

Wolfgang Dödlinger

Hello :)

I want to make a DataFlow that shifts the value from one Element to another (in the same Cube)

e.g.:

Test_Entity: element1, element2

before DataFlow:

cube:

element1: 0

element2: 10

after DataFlow:

cube:

element1: 10

element2: 0

Thank you

Kind regards

wolfgang

Find more posts tagged with

Accepted answers

All comments

Daniele Santandrea

Hello Wolfgang Dödlinger,

you can create a simple procedure as follow:

Select element1
DF from official cube to a Temp Cube (without entity "Test_Entity")
Select element2
DF from Temp Cube to official cube

Regards,
Daniele

Bettina Clausen

Hi Wolfgang,

I recommend our "Best Practices" section: https://community.board.com/categories/best-practices
This section is constantly releasing new articles.

Your question is also covered here:

https://community.board.com/discussion/16351/moving-data

Kind regards,
Bettina

Neha Hasija

Hi Wolfgang,

You can also use also TMP cube to save the values of element 1 and element 2 with the test_entity and move it to element 2 and element 1 respectively and then move to main cube.(To swap the values on element 1 and element 2)

Selection on element 2

Main Cube (Block reference on element 1) = TMP Cube

Selection on element 1

Main Cube (Block reference on element 2) = TMP Cube

This way element 1 has element 2 value and vice versa in the TMP cube.

2. Remove all selection on test_entity

3 . Move values from TMP cube to main cube.

Regards,

Neha

Neha Hasija

Hi Wolfgang,

You can also use the TMP cube with the test_entity to save values for element 1 & 2 at element 2 & 1 respectively(to swap the values) and then move to main cube without selections.

Select Test_Enity = Element 1

Main Cube(with block reference on element 2) = TMP Cube

2. Select Test_Enity = Element 2

Main Cube(with block reference on element 1) = TMP Cube

This way swapped values are stored.

3. Remove selection on test_entity

4. Move values from TMP Cube to main Cube

TMP Cube = Main Cube

Regards,

Neha