How to use entities and relationships in data flow

William Le

Hi everyone,

 

I dont know how to use entities and relationships in Data Flow. Can we use it in the algorithms? Can anyone explain it? I dont see it in document. Thank you very much for your help.

 

Thanks and best reagards

 

William Le

Helmut Heimann

Hi William Le,

 

entities and their relationships are used to dimesion your cubes and aggregate data on the defined level. This means for dataflows that the data result is aggregated to the level of dimensions defined in your target cubes. Keep in mind that data is calculated on the lowest level of your target cube (first version) and aggregated on higher levels by aligning the cube versions.

 

Kind Regards

Helmut

Johannes Blischke

Hi William Le,

 

you can use entities for different dataflow interactions.

Here are two examples:

 

1. If you like to pre-fill a textcube with text of an entity, you can use this entity as source. Therefore you need a textcube with the same dimension you like to use in your dataflow.

In this example you write the product description into your textcube:

You can use this maybe for editing entity member descriptions and so on (export this textcube and use a datareader to replace description).

 

2. You can use entities for workflow logging:

In this example I selected year 2014, salesperson = Bishop and Division = Accessories on the screen. 

In a dataview you can now see this result if you run the procedure:

 

 

There are many more cases where you need to use entities, but I hope I have given you a small overview or an impetus for more ideas.

 

 

Cheers

Johannes

William Le

Thank you very much for you help.

William Le

Thank you very much for your help.

Helmut Heimann

You're welcome, William Le  !

You might want to mark answers as correct as you received the information you requested - otherwise, feel free to ask again if anything is not clear enough.

 

Regards

Helmut