Data Flow with Different Value

Hi All,

Does anyone know how to process data flow but the contents of the values are different still in one entity. For more details, I will give illustrations like the picture below.

So, how to do data flow, for example from item code W4EE14AO10 to FK14W11001 even though the item code is still in one entity. Data flow from LINI 1 to LINI 2. The code of goods from some of these lines actually has the same description name, only the codes from each production line will later form the item code for finished goods.

Thanks.

Björn Reuber

Oliver Beirne

Find more posts tagged with

Accepted answers

All comments

Previous Member

Hi,

i got two solutions; a simple one (if possible) and a more complex one:

Solution 1)

You can prove if it is possible to create a parent entity over your item entity in order to aggregate the values of production line 1 into this parent entity and write it back to production line 2. Your relationship could look like this:

This solution has some constraints however, so you have to test if it is possible to do so in your case.

Solution 2)

Define a second item entity containing the same elements as your original item entity.
Create a cube (Mapping A) with both item entities as dimensions and populate this cube with a 1 for each mapping between your source items (original entity) and your target ones (replicated entity).
You need a cube (Tech A) whith the same dimensions as your source cube (Issue) plus the second item entity
Than you can perform a dataflow Tech A = Issue * Mapping A
Than you define a second Tech Cube (Tech whith the same dimension as Tech A but without the original item entity and perform a dataflow Tech B = Tech A

Now you got the values on your target items but on the wrong entity. So you have to perform some more actions to write the values back to your original entity.

Create another Mapping Cube (Mapping with both item entities and write a 1 in every cell where orinigal item is the same as the replicated one.
Perform a data flow Tech A = Tech B * Mapping B
And Completion = Tech A

Hope this helps

Mark

Candra Aji Pamungkas

Hi mark,

Thank you in advance.

but if I have four production line processes. whether the first solution can answer.

Example,

I assume that in production line 1 there are quantity data and stored in the parent entity. The data quantity will be transferred to production line 2 based on the item code entity to the parent entity and so on until the production line 4 and this I do on the board using select and refer in the procedure. if the data flow in accordance with the mapping made as shown above is not a problem, the problem is when there is a case of rejecting items where later the FK14W15001 code will be returned to production line 1 and the item code changes from FK14W15001 to W4BB14AO00, this may not be a problem adding mappings where FK14W15001 becomes a parent entity and W4BB14AO00 becomes an item code entity, but when the FK14W15001 item code is not only returned to production line 1 but also returned to this production line 2 codes FK14W15001 as the parent entity has two item code entities, of course this very disturbing when I do data flow from the parent entity FK14W15001 to production line 1 because FK14W15001 will bring two item code data that is different from the production line. For details I update the mapping data below.

Is there a solution for this? Thank you

Regards,

Candra

Previous Member

Wahyu Nugraha can u help this mr?

Candra Aji Pamungkas

Mark Altenberg

Hi,

Do you have an idea to refer data dynamically? like the select function of the cube which contains flag data from the entity chosen by the user.