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.
martedì 26 marzo 2013
martedì 19 marzo 2013
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.
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:
- FavoritesYour 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.
- CreateThe Create area contains shortcuts to the processes to create a new report or workspace.
- LaunchWhen 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 environmentClick the active environment from the lower right corner of the screen and select the desired one from a list.
- View My SecurityClick Show Access Rights from the lower right corner of the screen. The My Security report opens in a new tab.
- Visit the Installation CenterClick Download Center from the lower right corner of the screen and select the desired download from a list of available downloads.
- Set PreferencesClick Preferences to set individual preferences for:
- Accessibility settings
- Locale settings
- Create customized links in the Launch area
- In your ABAP system, start transaction SIMGH.
- Navigate to the IMG structure BPC Configuration. Choose Display to open the environment parameters.
venerdì 7 ottobre 2011
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.
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.
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
Iscriviti a:
Commenti (Atom)