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

Prevent Users from Sending in Data - BPC 10 MS


We are looking for a way to prevent all users from sending in data after a specific time of the night (ex. 8pm EST), even if they are already logged into the system. We do not want to take the system offline, as we have lots of scripts running between 8pm and Midnight. Ideally, we'd like a message to pop up, for anyone who tries to login after 8pm or tries to send either via the EPM ribbon Send button or any custom VBA form buttons that we have which execute the EPMSubmitData function.

We're open to various options but ideally looking for a simple way without having to modify every template, or changing any server settings or custom SSIS packages.

Thanks in advance!


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2015 at 11:26 AM

    I'm not sure, but can't you write a stored procedure to

    copy the current workstatus table to a tmp workstatus table

    update the work status table to a locked status

    Create a script logic to call this stored procedure

    Create a package to call this script logic

    Schedule that package to run daily at 8pm

    duplicate this procedure to reverse the work status tables (copy the tmp workstatus back in the work status table) and schedule that package at 7 am

    (OR you could kindly ask them and say that the BPC audit will reveal that they did work after 8pm :-) )

    Does this seem a possible solution path towards your business case?

    Kind regards,


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Brian,

      update the owner property in the driving dimension for the work status as well in a similar way. replace all values by sys_admin and at day break set the original values back.

      Also, try and run the scripts closer to 7 am.. and free the night to take it offline..

      Maybe you could write VBA to prevent the sending operations if time > 8pm. Then, you also have to protect that worksheet and strip them from rights to create templates themselves.. So, not ideal as well.

      Last option, not the best one I admit. Run a full optimize at 8pm. clear FAC2 and FACWB before execution of the nighlty scripts, run the scripts and end with full optimize. At 7 am. start the day with a clear of the FAC2 and FACWB..

      -- or copy the values to a tmp table to verify what has been done...

      no other suggestions I can give right now.

  • Posted on Mar 27, 2015 at 02:40 PM

    Hi Brian,

    why you don't want to use appset status feature?

    I think this is the bpc solution, for users system is not available and admin can continue to work also with packages and you if you need you can test if the system is available or not adding a simple select on the tbldefault, so you can stop or send data also from excel.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Brian,

      this change from previous versions seems a bug why you not open an incident to SAP?

      A possibility is to follow the idea of Stefan or to create a query that update backup a copy of the involved table(s) and after delete all user from the teams so they will loose all rights.

      After finished the admin activities another query that restore the old table(s).

      You can also launch these queries from custom packages that you can schedule.



  • author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2015 at 05:01 PM

    Hello Brian,

    You may prevent users from writing to the selected members or views by using the member access profile in administration console and creating a profile with read only privileges.

    Please let me know if I might assist.

    Best Regards,


    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.