Skip to Content
author's profile photo Former Member
Former Member

Locking data using Work Status or GetonlyRange

Hello All,

I have few questions on the usage of the workstatus locks. I am trying to use it to lock my actuals/plan data for every month after the month is closed and in the case of actuals, lock it always. How do I do this? Actuals and Plan data are displayed in most of the input templates. What is the best way to do it? Is work status the best route or get only range in EVDRE?

The problem with getonly Range in EVDRE is it has to dynamically determine the months it has to lock for the forecast/plan month. How do I do this? Also the get only range does not let submit data into the server but it still lets user edit data. How can avoid it? So I have to find a way to dynamically lock the cells too..

Also, I see that work status can be used. Though I feel work status is helpful more on BPFs. can anyone shed some light on how to achieve this functionality? In BPC 7.0, on the work status settings, i see an additional column for base level hierarchy. It does not let me save the work setting without providing value to it. What is the impact of this property?

Thanks in advance....

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 01:53 PM

    A couple of notes and questions.

    - If you are locking ACTUALS as a category, I would use SECURITY Member profiles, and always set it to read.

    - If you have a process to copy ACTUAL data to PLAN periods and want to lock the periods as they move, then I would either use the work status process at the admin level, OR use EVDRE FORMAT functions to dynamically lock the periods that have actual data in EACH sheet.

    The tradeoff is related to the process your group plans to utilize for a PLANNING process. The impact of re-building each template to have format driven locks may be expensive and time consuming. Locking using the WORK STATUS may be quick, but may interfere with other operations and process control factors. In addition, logic and DM packages would need to be reviewed and revised to incorporate skipping locked data if needed during a calculation.

    So, there is no correct way, just ones that fits the customer and profile of the process you are performing. As for your question in the work status box in Admin; 1st you need to setup WORK STATUS in the Admin web page, then you can make changes; The BAS and PARENT process is for using VALIDATION accounts and intersections to the workstatus process and may not apply to your needs.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I cannot give you a specific method, since there are so many options to build into the Excel template. The key to the problem is to use the EVDRE FORMATTING table (check the formatting how to guide on SDN), set the excel template to be PROTECTED(after the FORMAT Section is complete). Then using some EVDRE formatting structure and native excel functions in the KEY column ranges, build a method to check a value by column to see if the range should be LOCKED or UNLOCKED.

      For example, you could set a property by category to tell the sheet what month to START a forecast. Then use that to build an excel test by each column. Then test that value in the EVDRE FORMAT process to unlock data cells. But this is just one method of setting up the template.

      Hope this is useful.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 12:38 PM

    Work status can be used, but users could still change data and after send receive an error that work status settings are incorrect for sending data.

    If you want to make sure inputcells are locked for actual or closed months, you can use the formatting range en make the report lock cells automatically based on a property value, or if you have fairly straitforward reports, us EVTIM functions to remove the TIME dimension expansion, and lock the columns using standard excel formatting options.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.