Skip to Content
avatar image
Former Member

How to lock particular Cell in BPC Report

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

Untitled.jpg (30.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 17, 2015 at 01:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2015 at 01:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2015 at 01:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 05:47 PM

    Hi Mayur

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

    Khokan

    Add comment
    10|10000 characters needed characters exceeded