How to switch BPC environment state (on/off line)?

In one of my older posts, I explained few ways how to check BPC environment state. Either it is online or offline. This time I focus on how to change the state of the BPC environment.

1. in BPC web client: In main screen of web client choose Settings button on top right corner. From there click on Environment button in a drop down Settings menu.

There is a new popup shown as next with a listing all available environments in the system. In a bottom part of the window there is a “Manage All Environments” button. Click on that one. 

There is a new screen called Manage All Environments shown as a next. Form here choose the environment which status do you want to change and clink on “Change Status” bottom on the screen toolbar. 

As a last step there is a new popup window where the environment status can be changed via radio button. 

2. in SAP BPC backend: Use t-code SE16 to browse table UJ0_PARAM_APP. Put following selection into the selection screen.

APPSET_ID = <your BPC environment tech name>

FIELD = AVAILABLEFLAG

In a VALUE column of the table there is either 0 or 1. Zero means the environment is to offline and one means it is set to online.

3. in SAP BPC backend – custom program: There can be a small ABAP program created. That changes the content of VALUE column in table UJ0_PARAM_APP. That can be done via a call of method SET_APPSET_STATUS  of class CL_UJA_APPSET.

 

More information:

How to check BPC environment state (on/off line)?

How to check BPC environment state (on/off line)?

BPC Environment is an umbrella term that groups shared metadata, such as dimensions, common configurations, and security, which becomes the basis of one or more BPC models. Normally when the users are working with the BPC the environment must be - available (it is in online state). In case there are, some changes done within its configuration the environment can be taken offline.

There are a few ways how to spot if the environment is in on/off line state.

1. in BPC web client: In Administration under Manage section there is a part related to managing of environments. Here the state of the environments is visible.

2. In EPM Add-in in MS Excel: On log-on attempt into the BPC there is an pop-up announcing that the environment is in offline state.

3. In SAP BPC backend: Via SAP GUI in table UJ0_PARAM_APP and FIELD = AVAILABLEFIELD the environment is in offline state of the value of the field is zero. It is in online state if the value is 1.