lock some columns input form

[michele_medaglia5]

Hi Bpc Friends

I need to have an input form with some column not imputable because are actual and the other imputable because are forecast data.

I have locked the actual columns and when I run the input form it works but if I change some dimension members and I refresh the actual columns become imputable. I don't know why???

Thanks

Michele

[former_member186338 · Accepted solution]

Use formatting sheet!

Use data validation rule instead of locking cells.

[former_member186338 · Accepted solution]

P.S. And it's not a good idea to combine Actual and Forecast categories in the same report, better to copy Actual months to specific forecast category.

[michele_medaglia5 · Accepted solution]

thanks

How can I use formatting sheet to lock some columns?

Thanks

[former_member186338 · Accepted solution]

You have 2 options:

1. Apply "Formatting on specific member" - Actual - EPM Lock selected cell (if you use 2 categories - not recommended)

2. Format all data are with validation rule depending on column number (if you use single category - forecast)

[Former Member · Accepted solution]

Hi Michelle,

Go through this link...EPM Add-in Academy - Enterprise Performance Management - SCN Wiki

Under Formatting section see Conditional formatting.

In that case they have used Monthnum to decide the formatting....but in your case simply you can use Category ID Actual and Forecast to derive the Y & N in IF function. OR use the same case....

Hope this helps..

Regards,

JP

[former_member186338 · Accepted solution]

For 2 categories you don't need any validation rules!!! No conditional formatting!!!

"Category ID Actual and Forecast to derive the Y & N in IF function" - what for???

You can simply format specific members.

[former_member186338 · Accepted solution]

P.S. And it's a good idea to read help about dynamic formatting: "28.1 Dynamic Formatting Template Definition"

[Former Member · Accepted solution]

For 2 categories you don't need any validation rules!!! No conditional formatting!!! - Why not??? She also has Time dimension with categories...

Yes I know....format specific members is also an option but since you had already specified it.....I dint thought that repeating it was a good idea!   Conditional Formatting is also an option!

JP

[former_member186338 · Accepted solution]

You have to differentiate 2 cases:

1. Single forecast category with first months copy from actual. In this case Conditional formatting and validation rule is the only "dynamic" option.

2. 2 categories - in this case formatting specific member is simple and correct solution (including cell protection). No reason to use more complex things.

[michele_medaglia5 · Accepted solution]

Hi

I have took off the excel protection from the actual column.

I tried the epm formatting but it doesn't work the protection, only work the formatting in a different colour

Please have a look at the different screen shots

This is the report structure

I have used a time property to identify the actual months

[former_member186338 · Accepted solution]

Sorry, but you are doing something strange! Don't use "Specific SelectionLocked Cells"!

Test simple report, with different formatting for: IN_SAPGL and not IN_SAPGL

Like here:

Hope it's clear!

P.S. Not for ACTUAL:

[former_member186338 · Accepted solution]

But what about single category?

[michele_medaglia5]

thanks a lot, it works