TM1 Forum

I want the drill process can take users to the specific elements they are interested between 2 cubes, my thoughts is
1). Set parameter for end-user to input the consolidation elements they focus on
2). use MDX to create a daymic subset and view. return the view to user
Probelms here
in 1) it seems if I click drill in the view, the parameter will not be promoted
in 2) MDX can not use the parameter

Any idea? is there anyone achieve this before, thanks in advance

Hi
I am achieve this before, but you don't need to create a dynamic subset for it.

You can use a 'normal' subset in you target view and use the

SubsetDeleteAllElements
SubsetElementInsert

functions in the prolog of you drill process.

Cheers

Gregor Koch wrote:Hi
I am achieve this before, but you don't need to create a dynamic subset for it.

You can use a 'normal' subset in you target view and use the

SubsetDeleteAllElements
SubsetElementInsert

functions in the prolog of you drill process.

Cheers

Thanks Gregor
I want the subset to include consolidation elements and all its descendants, for example in cubeA I have element US as leaf element, and in cubeB, US is consolidated by US-west, US-east, then as the process runs, I want to see the subset include all descendants for US in the drill view, can this be done in SubsetElementInsert? also, when I click drill, no promote window for me to input the element I want to insert to the new subset..
Any idea?