Drill through to dynamic view

[xinyu]

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

[Gregor Koch]

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

[xinyu]

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?