SAP BPC NW: how to find log files

Are you working on SAP BPC NW version ( Netweaver)?
Many users have some problems to find the log file generated after a pacage execution. the solution is on Sap DWH.
In fact, you should use the transaction UJFS in order to locate the webfolder and find the right log file.

Script logic: how to create a variable on SAP BPC

Here the select condition to insert in a SAP BPC script logic in order to create a dynamic variable:
 
*SELECT(%REPORTING_CURRENCIES%, “ID”, “CURRENCY”, “[GROUP] = 'REP'”)    

• %REPORTING_CURRENCIES% is the name of our variable
• ID is the column that indicate our result
• Currency is the name of the dimension
• Group='REP' is the property to use in that selection

Script logic: use of when SAP BPC

Here an example af a script logic that run on .INP time dimension and use "when condition":

 

*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

How to configure Drill Through to BEx Query SAP BPC 10 NW

This section will focus on how to configure a drill through target to a BEx Query. In this example, we will configure a drill through target to a pre-existing BEx query called ZDT_PLANNING. This query was created using the 7.x version of the Query Designer, but the 3.x URL format will be used when defining the drill through target in BPC. The reason is that, at the time of this writing, there are limitations when using the 7.x URL format. For example, the parameter names used in the 7.x format are too long to be used when configuring the parameters in the BPC Admin client. A future BPC support package will address these limitations, but until then the 3.x format should be used. This BEx query has been created with two variable parameters called ZDTACCT and ZDTTIME. Values from a BPC report will be passed to these parameter variables when triggering the BEx Query.

1. Log on to the BPC Admin Client and click on “Drill Through“ from the appropriate Application.
2. From the action pane, click “Add Drill Through”.
3. Enter the Drill Through ID and a description, then click “Next“.
4. Next, enter the URL for the BEx Query. Again, the 3.x URL format works best here. An example URL would be:
http://<host>:<port>/sap/bw/bex?&query=<query_name>
5. Enter the parameters as shown below. BEx Query uses specific parameter names such as VAR_NAME_1, VAR_VALUE_EXT_1. This is how the parameter values are passed through the URL. You must supply the name of the parameter as well as the actual value assignment. So for each parameter variable defined in your BEx Query, you must define a pair of parameters here, one for the name of the variable in the BEx Query, and the other for the actual value to be passed.
6. Next, click the “Test” button.
7. Click “Run Test”.
8. The report is then displayed. Notice the parameters have been passed successfully to the BEx query.
9. Click “Close”, next.
10. The drill through target is now configured successfully.

The meaning of Start Page on SAP BPC 10

When you log in to the Web Client of Planning and Consolidation, the first screen that you see is the Start Page, which is the first node in the Home tab navigation pane.

Features

The following features are available in the Start Page:

• Favorites
  Your Favorites list contains quick links to, for example, the workspaces, reports, input forms, and books that you access frequently during your working day. You can define your own list of favorites.
• Create
  The Create area contains shortcuts to the processes to create a new report or workspace.
• Launch
  When you first access the Web Client, the Launch area contains links to install the SAP BusinessObjects EPM solutions, add-in for Microsoft Office and the Administration area.
  After these components are installed, the Launch contains links to the EPM add-in and a link to the Administration area.
  The EPM add-in is an add-in to Microsoft Office Excel, Microsoft Office Word and Microsoft Office PowerPoint. The add-in enables you to analyze data as well as enter data on SAP BusinessObjects Planning and Consolidation models. For more information about the EPM add-in, see the SAP BusinessObjects EPM solutions, add-in for Microsoft Office help.
  There can also be up to five custom links in the Launch area. You can use these links to access other applications, for example, Financial Information Management (FIM).

Activities

To open the Start Page, choose Start Page from the left navigation pane in the Home tab. From the Start Page, you can do the following:

• Change the environment
  Click the active environment from the lower right corner of the screen and select the desired one from a list.
• View My Security
  Click Show Access Rights from the lower right corner of the screen. The My Security report opens in a new tab.
• Visit the Installation Center
  Click Download Center from the lower right corner of the screen and select the desired download from a list of available downloads.
• Set Preferences
  Click Preferences to set individual preferences for:
  • Accessibility settings
  • Locale settings
• Create customized links in the Launch area
  1. In your ABAP system, start transaction SIMGH.
  2. Navigate to the IMG structure BPC Configuration. Choose Display to open the environment parameters.