Can I create 2 dynamic selection entity based on cube in screen or dataflow?

Ilham Maulana Habibie

Hi all,

I want to know that, can we create 2 dynamic selection entity based on cube in screen or dataflow?

For example : Entity A, Cube A, Cube B

I want to make :

Select Entity A based on Cube A
Select Entity A based on Cube B

Is it possible if the scenario should be like that?

Thank you.

Find more posts tagged with

Selection

Accepted answers

All comments

Samir Jones

Hi @Ilham Maulana Habibie,

In a Procedure, you can use the Keep Mode functionality when using the step Select Entity Based on Cube.

In a screen, I'm not aware that you can use two cubes. Instead, maybe you can combine the two cubes in to one cube, that you can use for screen selections.

Ilham Maulana Habibie

Hi @Samir Jones

If I use it in procedure,should I remove the selection after dataflow process? because I want to filter the cube by using dataflow after Select Entity Based on Cube

Samir Jones

Hi @Ilham Maulana Habibie,

I hope I understood your question correctly.

Continuing after the dataflow, if you only need to use the data within the current selection, I don't see a reason why you need to remove the selection. On the contrary, if you see a posibility to reduce your selection even further, after the dataflow, you can do another Select Entity Based on Cube using the keep mode.

If you have very large datasets which makes your Procedure "slow", reducing the selection can help.