drill down option with button

[Former Member]

Hi,

        We have requirement for drill down option ,when i click on the button.

          I have entity dimension in the report as rows,when i click on drill down button, the entity should show children of the parent in the report using VBA or any work around.

Entity "abc" has b,e,f .. as children.

In current report

entity	time
abc	789

when i Click on "drill down"button, the entity dimension member "abc" should show the children of (b,e,f....), as shown below

entity	time
b	1
e	2
f	3

when I click on "back" button,

entity	time
abc	789

Please let me know , how to achieve this functionality in the report using VBA or any work around.

Thanks in advance

[Former Member]

Hi Venkata,

Use Expand - Collapse options.

Regards,

pavan

[former_member186338]

Hi Venkata,

But it's a standard functionality of EPM report - if you double click on parent it will expand, second time - it will collapse ... What's the issue?

Vadim

[Former Member]

Hi Vadim,

               Thanks for the reply, we are actually using the EPMCONTEXTMEMER() for selecting the entity value , after selecting the entity if I do the drill down with the entity values in the report , the entity values are not in relation with the EPMCONTEXTMEMBER() , so how to deal with this situation,Please suggest here.

[Astha_M]

Hi Venkata,

Use EPMDIMENSIONOVERRIDE for the member in EPMCONTEXTMEMBER to get the values in relation to the selected member.

Hope it helps.

Astha

[former_member186338]

Unfortunately - no way! If you have row axis member delivered with EPMCONTEXTMEMER then drill down will break the relation.

Vadim

[former_member186338]

With EPMDIMENSIONOVERRIDE you can at least return to the original single member after drill down - just refresh report.

Vadim

[Astha_M]

We can define members as BAS of the members selected as the context member in the EPMDIMENSIONOVERRIDE formula so it can show all the base level members.

Astha

[former_member186338]

The requirement was to be able to expand and then collapse. EPMDIMENSIONOVERRIDE for single parent is more or less ok. But if you want to dynamically create the criteria in EPMDIMENSIONOVERRIDE then VBA will be required with additional complexity...

Vadim