advanced sap bw reporting concepts
TRANSCRIPT
-
8/3/2019 Advanced Sap Bw Reporting Concepts
1/32
4/19/05 Advanced BW Reporting Concepts Page 1 of 32
Advanced BW Reporting ConceptsThis QRC shows you how to perform the following BW reporting functions:
Executing A BW Report Moving Back To Start
Saving A BW Report Variant Changing Where Totals Are Displayed
Viewing/Removing Report Hierarchy Details Suppressing/Unsuppressing Repeated Key Fields
Changing How Report Data Is Displayed Refreshing A Report
Changing To Cumulative Output Amounts
Changing Other Report Attributes Changing Sort Order of Report Data Other BW Reporting Buttons
Suppressing/Unsuppressing Zero Rows Attaching A Chart To A Report
Suppressing/Unsuppressing Total Rows Protecting A Report From Formatting Changes
Normalizing Report Results Saving A Report As A Favorite
Swapping Displayed Report Fields Saving Report Data In An Excel Spreadsheet
Adding Drilldown to a Report Turning On/Off the Right-Click Functions
Moving Back One Screen Business Explorer Menu
IMPORTANT NOTE: To perform the above BW reporting functions, you will first need to log into the BW system (called BWP on yourSAP logon pad) and begin at the Easy Access Screen. You will also want to close Microsoft Excel prior to using these reports.
EXECUTING A BW REPORT:
Step 1. Type transaction code RRMX in the and press Enter.
NOTE: The system will open Excel in another window.
Step 2. If not there already, drag the BW toolbar (highlighted above) upward to the Excel toolbar area
as shown above.
NOTE: Step 2 will only need to be done once.
Step 3. If not already done, click on the button from the BW toolbar and click on Suppresswarnings from server.
NOTE: Step 3 will also only need to be done once. Once this setting is made, the Suppress warnings from server setting will be
indicated with a next to it .
Drag the BW taskbarupward to the Excel
taskbar (if not alreadythere).
-
8/3/2019 Advanced Sap Bw Reporting Concepts
2/32
4/19/05 Advanced BW Reporting Concepts Page 2 of 32
Step 4. Click button and select Workbooks (shown below).
Step 5. Click next to BWReports for Departments to display the report directories.
.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
3/32
4/19/05 Advanced BW Reporting Concepts Page 3 of 32
Step 6. Click on the desired report name (ex: Budget Request) to highlight it.
NOTE: BW queries are indicated with the symbol.
Step 7. Press button (highlighted above) to select the report.
Step 8. Enter your data in any unpopulated fields on the selection screen (ex: Fund, Version, etc.) asshown above.
Step 9. Click on the button to clear any pre-populated field (ex: Fund Center).
Step 10. Press the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
4/32
4/19/05 Advanced BW Reporting Concepts Page 4 of 32
Step 11. Enter the desired value(s) for the selected field (ex: fund center 3110200000) using theSingle vals or Ranges tab.
Step 12. Press the button [shown above].
NOTE: At this point, if desired a variant can be created to save your report settings. See section Saving A BW ReportVariant (page 5).
Step 13. Press the button [shown above].
NOTE: The above screen shows the default settings for the Budget Request report for the entered budgeting fund center .
-
8/3/2019 Advanced Sap Bw Reporting Concepts
5/32
4/19/05 Advanced BW Reporting Concepts Page 5 of 32
SAVING A BW REPORT VARIANT:
NOTE: To save a BW report variant, you will first need to be on the report selection screen as shown below.
Step 1. Click on the button.
Step 2. Enter a variant name and meaning for the variant and choose Protect variant checkbox.
Step 3. Press the button [shown above].
Step 4. Click on the button.
NOTE: The button is used to access the report variant you saved the next time you open the report.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
6/32
4/19/05 Advanced BW Reporting Concepts Page 6 of 32
VIEWING REPORT HIERARCHY DETAILS:
NOTE: Not all reports will have hierarchies available. The indicates a hierarchy exists.
Click on one of the to view the hierarchy details for a listed item (ex: commitment item group Personnel).
NOTE: The above screen shows the selected report with the hierarch details displayed.
Press the to close the hierarchy details.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
7/32
4/19/05 Advanced BW Reporting Concepts Page 7 of 32
REMOVING REPORT HIERARCHY:
To remove the hierarchy display, RIGHT click on the cell with the hierarchy (ex: commitmentitem) and choose Hierarchy Active.
NOTES:
- The above screen shows the hierarchy removed on the above report.- To reactive the hierarchy drilldown, you would right click on the column with hierarchy again and click on the
Hierarchy Active option. On some reports, a hierarchy may exist but is turned off by default.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
8/32
4/19/05 Advanced BW Reporting Concepts Page 8 of 32
CHANGING HOW THE REPORT DATA IS DISPLAYED:
To change the data displayed for a column, RIGHT click on that column and choose the fieldname (ex: Commitment Item) > Display As > (ex: Name and Key)
NOTES:
- On the above screen, the order for the commitment item name and key are now reversed.
- The No display option (shown above) can be used to hide the column all together.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
9/32
4/19/05 Advanced BW Reporting Concepts Page 9 of 32
CHANGING TO CUMULATIVE OUTPUT AMOUNTS:
To view a cumulative output for a listed field, RIGHT click on that column and choose the fieldname (ex: Commitment Item) > Cumulative Output.
NOTES:
- On the above screen, the commitment item amounts are now cumulative amounts for the all the items listedabove that line.
- Cumulative outputs will not work on reports with the hierarchy turned on.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
10/32
4/19/05 Advanced BW Reporting Concepts Page 10 of 32
CHANGING SORT ORDER OF REPORT DATA:
To change the sort order for a column, RIGHT click on that column and choose Sort > (ex:Ascending According to Name).
NOTE: On the above screen, the commitment item are now resorted in ascending order by name.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
11/32
4/19/05 Advanced BW Reporting Concepts Page 11 of 32
SUPPRESSING/UNSUPRESSING ZERO ROWS:
To suppress/unsupress zero columns/rows, RIGHT click on any cell in your report and chooseAll Characteristics > Suppress Zero Columns/Rows.
NOTES:
- By default, most reports will have zero rows suppressed.
- The above report example does not have any zero rows which can be suppressed/unsupressed.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
12/32
4/19/05 Advanced BW Reporting Concepts Page 12 of 32
SUPPRESSING TOTAL ROWS:
To suppress/unsuppress total rows for a selected item (ex: Commitment item), RIGHT click onthat column and choose the field name (ex: Commitment Item) > Suppress Results Rows >
Always/Never.
NOTES:- The above report now has the total line suppressed (not displayed).- Suppression of all total lines on a report would be done using the All Characteristics menu.- To unsuppress the total line, you would repeat the above process.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
13/32
4/19/05 Advanced BW Reporting Concepts Page 13 of 32
NORMALIZING REPORT RESULTS:
To normalize the report results, RIGHT click on a cell and choose All Characteristics >Normalize > Query Result
NOTE: The above screen shows that the report data is now displayed as normalized results with the total line being100% and rows above the totals displayed as percentages of the total.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
14/32
4/19/05 Advanced BW Reporting Concepts Page 14 of 32
SWAPPING DISPLAYED REPORT FIELDS:
To swap two report display fields, RIGHT click on one of the fields and choose: Swap (ex:Commitment Item with) > (ex: Budgeting Fund Ctr.).
NOTE: On the above screen, the commitment item field has been swapped with the budgeting fund center field.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
15/32
4/19/05 Advanced BW Reporting Concepts Page 15 of 32
ADDING DRILLDOWN TO A REPORT:
To add drilldown to a report, RIGHT click on a field (ex: Budgeting Fund Center) and choose thefollowing: Add Drilldown According To > (ex: Status).
NOTES:
- On the above screen, the report now shows drilldown by budgeting fund center and status.
- Not all reports will have drilldown available.
- To remove the drilldown, use the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
16/32
4/19/05 Advanced BW Reporting Concepts Page 16 of 32
MOVING BACK ONE SCREEN:
To move back one screen, RIGHT click on a field (ex: Budgeting Fund Center) and chooseBack.
NOTES:
- On the above screen, the report has been returned to the previous view before the latest change was made.
- The button (discussed later) can also be used to move backward to the previous view.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
17/32
4/19/05 Advanced BW Reporting Concepts Page 17 of 32
MOVING BACK TO START:
To move back to the initial view for a report, RIGHT click on a field (ex: Commitment Item) andchoose Back to Start.
NOTE: On the above screen, the report has been returned to the initial view before any changes were made.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
18/32
4/19/05 Advanced BW Reporting Concepts Page 18 of 32
CHANGING WHERE TOTALS ARE DISPLAYED:
To move ALL total lines to the top of the report, RIGHT click on any data cell and choose thefollowing: All Characteristics > Position of Result Rows > Results Row Top Left.
NOTE: On the above screen, the report totals are now displayed at the top of the report. The total lines can be moved tothe bottom of the report by choosing Results Row Bottom Right.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
19/32
4/19/05 Advanced BW Reporting Concepts Page 19 of 32
SUPPRESSING/UNSUPRESSING REPEATED KEY VALUES:
Step 1. To unsuppress repeated key values, RIGHT click on any data cell and chooseProperties.
Step 2. Deselect the Suppress repeated key values checkbox.
Step 3. Press the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
20/32
4/19/05 Advanced BW Reporting Concepts Page 20 of 32
NOTE: On the above screen, the repeated key values are now displayed (ex: Administration Building).
-
8/3/2019 Advanced Sap Bw Reporting Concepts
21/32
4/19/05 Advanced BW Reporting Concepts Page 21 of 32
REFRESHING A REPORT:
Step 1. To refresh the results of the report, click on the button.
Step 2. Enter the desired selection criteria (ex: fund, budgeting, fund center, etc.) or selectyour variant.
Step 3. Press the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
22/32
4/19/05 Advanced BW Reporting Concepts Page 22 of 32
CHANGING OTHER REPORT ATTRIBUTES:
Step 1. To change the attributes of a report, click on the button and choose Change query(local view).
Step 2. RIGHT click on a field to be changed (ex: Dec Pack) and select Properties.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
23/32
4/19/05 Advanced BW Reporting Concepts Page 23 of 32
Step 3. Change the desired display settings (ex: highlighting, number of decimal places, etc.).
Step 4. Press the button [shown above].
Step 5. Click on the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
24/32
4/19/05 Advanced BW Reporting Concepts Page 24 of 32
NOTES:
- On the above screen, the Decision Package column and numbers are now highlighted in blue.
- The above process can also be used to hide fields, change field scaling, change field decimal places, etc.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
25/32
4/19/05 Advanced BW Reporting Concepts Page 25 of 32
OTHER BW REPORTING BUTTONS:
NOTES:
- As illustrated above, the button can be used to perform the various right-click functions discussed earlier (ex:sorting, swapping, back, back to start, etc.
- To use this button, you will first need to click on a cell within the query area of your screen.
NOTE: As illustrated above, the button can be used to changed font, pattern, border, or alignment for selected cell(s)on the report.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
26/32
4/19/05 Advanced BW Reporting Concepts Page 26 of 32
ATTACHING A CHART TO A REPORT:
To attach a chart to your report, select the button and the choose Attach chart [as shownabove].
NOTES:- On the above screen, a chart of the report data has been added to the query area.
- To move the chart to another area of the screen, you would just drag and drop it.
- To change chart attributes, right click on the chart and use the Excel chart menu.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
27/32
4/19/05 Advanced BW Reporting Concepts Page 27 of 32
PROTECTING A REPORT WORKSHEET FROM FORMATTING CHANGES:
Step 1. To protect a report worksheet, select the button [shown above] and then chooseSAP Protection.
Step 2. Enter a password twice and press the button.
NOTES:
- If a report worksheet is protected, the formatting and structure of the report worksheet cannot be changed.
- To unprotect a protected report worksheet, you would choose SAP Protection from the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
28/32
4/19/05 Advanced BW Reporting Concepts Page 28 of 32
SAVING A REPORT AS A FAVORITE:
Step 1. To save your report as a BW favorite, select the button [shown above] and selectSave as new workbook.
Step 2. Enter a name for your favorite (ex: Steves Budget Request Report) in the Descriptionfield.
Step 3. Press the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
29/32
4/19/05 Advanced BW Reporting Concepts Page 29 of 32
NOTE:
- On the above screen, the new favorite Steves Budget Request Report has now been added to both theBW/BPS Easy Access screen and also to the RRMX report menu under Workbooks (see graphics above).
- To run the report, you would double-click on the favorite.
- When a report is executed from a favorite, the display settings that have been saved for that report will beretained.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
30/32
4/19/05 Advanced BW Reporting Concepts Page 30 of 32
SAVING REPORT DATA IN AN EXCEL SPREADSHEET:
Step 1. To save your report data in an Excel spreadsheet, choose File > Save As [as shownabove].
Step 2. Specify the file location, file name, and press the button.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
31/32
4/19/05 Advanced BW Reporting Concepts Page 31 of 32
TURNING ON/OFF RIGHT-CLICK FUNCTIONS:
To turn off the BW right-click functions, press the button and select OLAP functions withright-click.
NOTES:
- If the right click functions are turned off, any of the BW right-click functions discussed earlier will need to be
performed using the button.
- If the BW right-click functions are turned off, the Excel right-click functions will still be available (ex: cut, copy,paste, etc.)
- Turning off the right-click functions is a personal setting which will apply to all reports you run.
- To turn on the right-click functions again, you would repeat the above process.
-
8/3/2019 Advanced Sap Bw Reporting Concepts
32/32
BUSINESS EXPLORER MENU:
NOTE: As illustrated above, the Business Explorer menu can also be used to perform many of the functions discussedearlier.