SAP BPC: Application Sets

SAP BPC: Application Sets.
An application set is a SQL database that stores all the data from each individual application in the set.
Each application is comprised of an individual Analysis Services database (or application). Each application contains the metadata that controls the data in the application set. Applications can share one or more dimensions with other applications within the set.
Setting application set status You can check or change the status of an application set. The available statuses are "Available" and "Unavailable." Some administration tasks automatically set the application set to unavailable. You can also make it unavailable manually. See Setting the status to Unavailable.
The system will automatically be set back to Available when the process is complete, or you can manually make it available. See Making an application set available.
Setting the status to Unavailable
You can manually set the application set to Unavailable.
Note that when an administrator logs on to an application set that is "Not Available" the following message is displayed:

Application set: <ApShell> is not available now.
Do you want to continue?

You can select Yes to proceed with logon, or No to cancel. This message is just a reminder. You can still work in BPC for Excel so that you can do testing while doing application maintenance. (An end user does not have this option.) However, remember that if an application has been modified and not fully processed, you can experience errors or be looking at old application information.

To set the status to Unavailable
1. From the Admin Console, select the application set you want to make unavailable.
2. Click Set application set status.
3. Select the Not Available radio button.
4. In the Message box, enter informative text that will be displayed when users try to logon. We recommend including the current date and time so that users can see that the message is
current, and to give an estimated time when they can log back on again.

Setting the status to Available
When you have finished updating the application, and are ready to set it back to "Available," you can select the Available radio button. System administrators can set the status of an application set, making it available or not available to users. This is useful as a way of preventing access to an application when you take it offline for maintenance, for example.

To set the status to Available
1. On the BPC Administration main screen, go to the hierarchical list in the left pane and click the plus sign next to the application name at the top level. The Manage Application Sets action pane is displayed.
2. Under the action pane heading Application Set Tasks, click Set application set status. The Set Application Set Status action pane is displayed.
3. Using the radio buttons, specify if you want the application set to be Available (online) or Not Available (offline). If you specified Not Available you may enter a text message that will
appear when users try to access the offline application set.
4. Click Update Application Set Status to set the application set status.

SAP BPC: Script logic. Use of When

SAP BPC: Script logic. Use of When.
An example of Script logic using When command.

*WHEN TIME

*IS <>TOT.INP

    *WHEN ACCOUNT

        *IS PERCENT.ALLOC

            *FOR %YEAR%=2003,2004,2005

                *FOR %MONTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC

                    *REC(FACTOR=GET(ACCOUNT="TOT.OVRHEAD",TIME="TOT.INP")/100,TIME="%YEAR%.%MONTH%")

                *NEXT

        *NEXT

    *ENDWHEN

*ENDWHEN

SAP BPC: Understanding action panes

SAP BPC: Understanding action panes.

“Action panes” provide quick access to tasks that are relevant to your current context. In addition, you can control your current view, view login information, jump to other programs, such as BPC for Excel and BPC for Word, and launch context help from the action pane.
A BPC action pane consists of the following sections: Navigation, Session Information, Task Selection or Input Fields, Available Interfaces, and See Also. These sections are described below.

Sap BPC: To start BPC Administration

Sap BPC: To start BPC Administration.
1. Do any of the following:
   • Open a browser and type http://<server name>/osoft, where <server name> is the
name of your BPC server.
   • From the Windows Start menu, select SAP > BPC.
   • From your Windows Desktop, click the BPC icon.
2. From the Launch page, select BPC Administration.
3. From the Administration action pane, select the desired task.

Sap bpc NW 7.5: network or security issue

Sap bpc NW 7.5: network or security issue.
Hello experts, we have a problem with the Bpc Client. we have an error when we try to access to Excel Client.

This is the screenshot error:

Thanks