How to lock particular Cell in BPC Report

[Former Member]

Hi Expert,

I want to lock my input schedule in particular cell for example with the combination 2015.Jan in column and account A in row axis.But there is some other account  like B and C which is remain imputable in 2015.Jan.

Mayur

[Shrikant_Jadhav · Accepted solution]

Hi Mayur,

Go to formatting sheet - > Add member / Property - > select "account A"  click on " Add to multiple selection "  + Time -> select month - >  " Add to multiple selection "  - > Multiple selection overview - > ok.

Shrikant

[Former Member]

Hi Mayur

Also set the sheet by password protection  from Sheet option -Protection tab.Remaining step followed as Shrikant suggested.

Khokan

[former_member186338]

Hi Mayur,

If you are using static input schedule with fixed row and column axis you can simply format the required cell as locked and protect the sheet. In case of dynamic input schedule - use formatting sheet as Shrikant recommended.

Vadim

[Shrikant_Jadhav]

P.S. Refer below link to get basics

page 233

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Shrikant