Question Re: Enable/Restrict planning on specific account members in embedded BPC Analysis office in Financial Management Q&A

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

Former Member — Wed, 19 Feb 2020 12:12:16 GMT

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

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

former_member186338 — Wed, 19 Feb 2020 12:26:58 GMT

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...

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

Former Member — Wed, 19 Feb 2020 15:03:17 GMT

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

Regards

Kumar

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

gregor_dieckmann — Thu, 20 Feb 2020 09:26:08 GMT

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