Enable/Restrict planning on specific account members in embedded BPC Analysis office

[Former Member]

Hi All,

I have a planning enabled BEx query in Analysis office workbook. I have 100 accounts in ( same level ), but the workbook should not allow planning for 10 accounts. remaining 90 accounts should be enabled for planning. All 100 accounts I need to show in the workbook.

kindly suggest me how ca I achieve.

Thanks

Kumar

[gregor_dieckmann]

Hi,

if you are using a key figure model simply make the some of the key figures not input-ready in the query. If you are using an account model (account is a characteristic) then use a data slice: in the data slice put the accounts that should not be input-ready.

Regards,

Gregor

[Former Member]

Thanks for the kind reply Vadim. Actually I want in Embedded BPC..

Regards

Kumar

[former_member186338]

In BPC standard EPM I will use Excel data validation to restrict changes for some accounts based on some property of account. No idea about embedded...