3 Replies Latest reply: Dec 17, 2012 10:57 AM by Leo27 RSS

    Locking cells in webform

      I have a webform which has periods Jan to Dec in the column section. I have a request to make the periods read only (lock) if they are older than the current month. For example, if the current month is Dec all the columns from Jan to Nov should be made read only (so users cannot enter data). Is there a way that we can do this.
        • 1. Re: Locking cells in webform
          Hi Leo!

          At which version you are working on...As we have done this in 9.3.1 by simply forcefully updating the filters at essbase side soon after each security refresh...

          I am not sure if there is any way to handle such situations in EPM 11. But i think we will need to check dimension level security or any design member to handle it.


          • 2. Re: Locking cells in webform
            Is there any particular reason why you are not using the functionality included in the Scenario Dimension to modify the startPeriod to do this? The scenario startPeriod property (and startYear property as well) is specifically designed to enable you to close the periods and periods for update by any user once they are no longer valid for planning purposes.

            • 3. Re: Locking cells in webform
              Yes you are right and its helped too. Thank you.