Restricting to one hierarchy with EPMSelectMemeber

[sree_ravinutala]

I am selecting the memebr of dimension with EPMSelectmemeber wanted to restrict to a particular Hierarchy. Is there any way ?

If i use filter i am not able to see the Hierarchy when pop window opens .

e.g   ..=EPMSelectMember("","[Dimension].[PARENTH1].[DIM_Member]","ID LIKE PLAN*","SCENARIO",FALSE)

If i keep this code in a button i will see the pop up PLAN0, PLAN1, PLAN2 etc( Indivdual nodes)

I wanted to show the particular Hierarchy  and nodes below ..

[Former Member]

Hi Sreedharrao,

You can use security to restric hierarchy nodes. not the best solution but there is a way to only show certain node.

Andy

[Shrikant_Jadhav]

Hi

Can you explain your business requirement in detail?

May be some work around...

Shrikant 

[former_member186338]

"If i use filter i am not able to see the Hierarchy when pop window opens" - correct, only list will be visible.

"I wanted to show the particular Hierarchy  and nodes below" - No way!

Vadim

[sree_ravinutala]

Thanks .