Drill down in EPM 10

[ashwin_kulkarni2]

Dear BPC Experts,

Is there any way where we can stop drill down in EPM 10?

Actually, we have a report where we have selected all the nodes in the report. Now we want to restrict user to drill down on these nodes.

How do we achieve this?

Please help.

Regards,

Ashwin.

[bishwajit_das]

You can go to User Options in EPM sheet and uncheck enable double click as shown below..

[ashwin_kulkarni2]

Hi,

thank you.

This is a user option, user can turn them on anytime they want. We want to restrict users.

Is there any other option?

Regards,

Ashwin.

[Former Member]

Hi Ashwin

There are ways ->( I have not tried it)

1)Disable Double click in that excel report using macro..

or

2)Under Expand button -> Custom Expand select some level which is not present in your dimension as shown

Now using some API you can disable Data Analysis tab

Please check more on this..

or

3)Task profile which disable this feature..

I tried to check any task profile related to it but couldn't find..

JAck