Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
PBCS - Administration Mode
Hi everyone,
Looking for advice/knowledge here.
We have a unique requirement. During a period close the customer needs to actuals data to be uploaded every hour during the working day. Currently they are Essbase 'On Prem' which is not a problem with a 'staging' cube as they can build the cube and then just swap it out.
However we migrated all the cubes to PBCS and need to replicate. Currently, we created some dummy scenarios to load the data to, calc the data etc. Then we put the cube in Administration Mode to copy data from dummy scenarios over to 'Actuals'. Then we take out of Administration Mode.
So my question is, what exactly does Administration Mode do? Does it only not allow new logins? If someone is already logged in and running a long calc, will it affect the calc at all? Issue is during this data load process, we run dim builds via Data Management and we have to refresh the application. I fear if the refresh attempts to run and a user has a calc going the cube will blow up and corrupt or something.
Is there anything that can logout all users and kill are processes in PBCS?
Thanks in advance!!!
Answers
-
If you look at the sessions in Calc Manager when a user runs a rule you will see that it is actually being run by the admin account - "epm_default_cloud_admin"
So in theory if you put the application in administration mode when a rule is being run it should carry on running. Though I think you will find in the job console that is says the rule is processing and does not update the status to completed even though it has.
Cheers
John
-
-
So this says it's for 'On Prem' HFM. So not sure if it applies to PBCS, but if it does, then it's perfect...
-
OK. So this could be issue. I guess, we will have to create a calc that takes a very long time and then fire off the process and see what happens. I hate to do it that way, but don't see how it can hurt.
Thanks for info!!
-
That is only intended for on-premise HFM.
-
When I tested the rule carried on running but there is no harm in confirming.
-
OK. I'm running a Calc All which takes a long time to run. I kicked off the monthly load process which includes data load and dim build via DM with one refresh. I'll post results what happens. Will be interesting.
-
If you run a refresh from planning then you have the option to log out users and stop requests, if these are selected and a rule is being run, the rule should be cancelled.
-
I'm running a refresh via a 'rundatarule' in EPM Automate. This is the result of the rule that does a metadata refresh. So this will bomb on the automation tool.
-
What's really interesting is not all EPM Automate commands show up in the 'sessions' on Calc Mgr. I thought it would log all processes being executed on the appliction... hmmmm