After completing this exercise, you will be able to:
• Use the navigation options in the BEx Analyzer via the context menu, via drag & drop, and via double-click.
• Use the navigation options in the BEx Web Analyzer via the context menu and via drag & drop.
Business Example
You want to analyze business key figures (for example, sales volumes or incoming orders) within existing BW queries by using the different navigation options.
Task 1:
In the BEx Analyzer, execute the query Sales Analysis 001
(P_SALES_ANALYSIS_001) and use the different navigation options to analyze the business key figures within the report.
1. Start the BEx Analyzer and execute the query Sales Analysis 001
(P_SALES_ANALYSIS_001). Use the Find function to search by either the description or technical name.
2. Insert the characteristic Distribution Channel in the drill-down.
Try out both inserting it in the rows and in the columns. Use different navigation techniques.
3. Remove the characteristic Distribution Channel from the drill-down, again using different navigation techniques.
4. Exchange Country with Material using Drag&Drop.
5. Display the Material using the hierarchy Product Hierarchy for material MARA. Expand and collapse hierarchy nodes, and finally, go back to the initial state of the report.
6. Drop the key figure Sales Volume EUR directly onto the key figure Incoming Orders EUR. What happens?
7. Remove the key figure Invoiced quantity via Drag & Drop.
How can you insert the removed key figure in the report again?
8. Exclude the Country value United States (US) from the results using drag and drop.
How can you insert the removed value in the report again?
Continued on next page
9. Now, show results only for Country United States (US) and then add an additional drill-down by Material in the rows to find out which materials make up the total in the United States (US).
10. Compare the result of the previous navigation option with the result of the following one: go 2 steps back and from Country United States (US) choose the context menu function Filter and Drill Down → Material.
11. Go back to the initial view of the query.
12. In order to change the drill-down you also can use the Query Properties function from the context menu. Place the Distribution Channel characteristic in the rows under the Country characteristic by using this possibility. Additionally, repeated key values should not be suppressed any more.
Note: Be aware that via Context Menu → Query Properties there are many functions to configure the Local Query Properties in sense of configuring the properties of the executed report.
13. Finally, save a view for your own user-defined navigational state of the report. Save the view under Favorites using the description U## View 001and the technical name U##_VIEW_001.
14. Now execute your new view U## View 001 (U##_VIEW_001) in the BEx Analyzer again.
Task 2:
Now use the BEx Web Analyzer within the SAP NetWeaver Enterprise Portal to execute the query Sales Analysis 001 (P_SALES_ANALYSIS_001) and again, use different navigation options to analyze the business key figures within the report.
1. To access the BEx Web Analyzer, logon to the attached Portal by executing transaction code ZPORTAL from your assigned BW system or opening your web browser and entering the URL
http://portal-(SID).wdf.sap.corp:50100/irjwhere (SID) is to be replaced by your assigned BW system ID. Enter the user ID and password provided by your instructor.
Go to Reporting, Analysis and Planning → Business Explorer → BEx Web Analyzer.
4. Remove the characteristic Distribution Channel from the drill-down, again using different navigation techniques.
5. Exchange Country with Material using Drag&Drop.
6. Display the Material using the hierarchy Product Hierarchy for material MARA. Expand and collapse hierarchy nodes, and finally, go back to the initial state of the report.
7. You have to execute the report again via New Analysis. In the executed report drag and drop the key figure Sales Volume EUR directly onto the key figure Incoming Orders EUR. What happens?
8. Remove the key figure Invoiced quantity via Drag & Drop.
How can you insert the removed key figure in the report again.
9. Exclude the Country value United States (US) from the results using drag and drop.
How can you insert the removed value in the report again.
10. Now, show results only for Country United States (US) and then add an additional drill-down by Material in the rows to find out which materials make up the total in the United States (US).
11. Compare the result of the previous navigation option with the result of the following one: go 2 steps back and from Country United States (US) choose the context menu function Filter → Filter and Drill Down by → Material.
Where can you display the filter situation of the report?
12. Remove the filter value for Country and insert Country as the first characteristic in the drilldown, the second characteristic in the drilldown should still be Material. Additionally, repeated key values should not be suppressed any more.
13. Finally, save a view for your own user-defined navigational state of the report. For the view, use the description U## View 002 and the technical name U##_VIEW_002.
14. Now execute your new view U## View 002 (U##_VIEW_002) in the BEx Web Analyzer again.
Solution 1: Navigate in Reports
Task 1:
In the BEx Analyzer, execute the query Sales Analysis 001
(P_SALES_ANALYSIS_001) and use the different navigation options to analyze the business key figures within the report.
1. Start the BEx Analyzer and execute the query Sales Analysis 001
(P_SALES_ANALYSIS_001). Use the Find function to search by either the description or technical name.
a) Choose Start → Programs → Business Explorer → Analyzer b) Choose Add-Ins.
c) In the BEx Analysis Toolbox, click the Open button.
d) Select Open Query.
e) Logon with your user ID and password when prompted.
f) Click the Find button on the left and then enter either the technical name or description. Select the Find button. When the query is found, select the Open button at the bottom to execute the query.
2. Insert the characteristic Distribution Channel in the drill-down.
Try out both inserting it in the rows and in the columns. Use different navigation techniques.
a) Click the Filter button to open the navigation pane.
b) You can use Drag&Drop to insert Distribution Channel in the rows or in the columns.
c) Or: from the context menu of Distribution Channel: Add Drilldown According to Distribution Channel in Rows and Add Drilldown According to Distribution Channel in Columns
d) Or: use double-click on Distribution Channel to insert it into the rows.
3. Remove the characteristic Distribution Channel from the drill-down, again using different navigation techniques.
a) You can use Drag&Drop.
4. Exchange Country with Material using Drag&Drop.
a) Highlight the Material characteristic from the filter area, then drag and drop it directly over the Country characteristic in the filter area or over the Country heading in the results area. When the mouse pointer changes to show two arrows in a circular motion you are ready to release the mouse button.
5. Display the Material using the hierarchy Product Hierarchy for material MARA. Expand and collapse hierarchy nodes, and finally, go back to the initial state of the report.
a) Highlight the heading Material and select from the context menu Properties. From the Hierarchy tab choose the hierarchy Product Hierarchy for material MARA from the drop-down box. Click OK to see the result displayed using the hierarchy.
b) Expand and collapse hierarchy nodes using the symbols at the beginning of the rows.
c) Or: use the functions in the context menu: Expand Hierarchy Node, Collapse Hierarchy Node, and Expand to Level.
d) In order to go back to the initial state of the report: from any cell of the report: Right click → Context menu → Back to Start.
6. Drop the key figure Sales Volume EUR directly onto the key figure Incoming Orders EUR. What happens?
a) Highlight the heading Sales Volume EUR and drag and drop this directly over the heading Incoming Orders EUR . The sequence of the key figures will be swapped.
7. Remove the key figure Invoiced quantity via Drag & Drop.
How can you insert the removed key figure in the report again?
a) Highlight the heading Invoiced quantity and drag and drop this outside the results area. When the mouse pointer changes to show a black filter icon you can then release the mouse button. The Invoiced quantity key figure is now gone.
b) To insert the removed key figure into the report again, you can choose Context menu → Back One Navigation Step.
c) Or: in the navigation pane: use the context menu for Key Figures, then choose Select Filter Value ...., and in the Select Values for Displayed Key Figures window, drag the key figure Invoiced quantity to the right-hand side, and choose OK.
d) Or: in the navigation pane: use the context menu for Key Figures, then choose Remove Filter
Continued on next page
8. Exclude the Country value United States (US) from the results using drag and drop.
How can you insert the removed value in the report again?
a) Highlight the cell, which contains the Country value United States (US), then drag and drop this anywhere outside the results area. Wait until you see the mouse pointer change to show a black filter before releasing the mouse button.
b) To insert the removed value into the report again, you can choose Context menu → Back One Navigation Step.
c) Or: use the context menu for Country, then choose Remove Filter 9. Now, show results only for Country United States (US) and then add an
additional drill-down by Material in the rows to find out which materials make up the total in the United States (US).
a) Highlight the cell containing the Country value United States (US) then right click to show the context menu. Select Keep Filter Value menu option.
b) Then, in the navigation pane, double click on Material.
c) Or: context menu for Material, then choose Add Drilldown According to Material in Rows.
10. Compare the result of the previous navigation option with the result of the following one: go 2 steps back and from Country United States (US) choose the context menu function Filter and Drill Down → Material.
a) From any cell of the report: Right click → Context menu → Back One Navigation Step (2 times).
b) Highlight the cell containing the Country value United States (US), then right click to show the context menu. Select Filter and Drill Down → Material.
11. Go back to the initial view of the query.
a) From any cell of the report: Right click → Context menu → Back to Start.
12. In order to change the drill-down you also can use the Query Properties function from the context menu. Place the Distribution Channel characteristic in the rows under the Country characteristic by using this possibility. Additionally, repeated key values should not be suppressed any more.
Note: Be aware that via Context Menu → Query Properties there are many functions to configure the Local Query Properties in sense of configuring the properties of the executed report.
a) From any cell of the report: Right click → Context menu → Query Properties.
b) On the Navigational State tab page: Transfer the characteristic Distribution Channel from the Free Characteristics area into the Rows area under Country by using drag & drop or the Arrow buttons.
c) On the Display Options tab page: uncheck the box Suppress Repeated Key Values.
d) Finally, press OK.
13. Finally, save a view for your own user-defined navigational state of the report. Save the view under Favorites using the description U## View 001and the technical name U##_VIEW_001.
a) Make any navigational steps you want and save the navigational state in a view using BEx Analysis Toolbox: Save → Save View under the Favorites folder.
Description U## View 001 Technical name U##_VIEW_001
14. Now execute your new view U## View 001 (U##_VIEW_001) in the BEx Analyzer again.
a) In the BEx Analysis Toolbox, click the Open button.
b) Select Open Query.
c) Change the Type at the bottom of the window into Query View. You will find very easily your view under the Favorites folder or under the History folder.
d) Open the desired view.
Continued on next page
Task 2:
Now use the BEx Web Analyzer within the SAP NetWeaver Enterprise Portal to execute the query Sales Analysis 001 (P_SALES_ANALYSIS_001) and again, use different navigation options to analyze the business key figures within the report.
1. To access the BEx Web Analyzer, logon to the attached Portal by executing transaction code ZPORTAL from your assigned BW system or opening your web browser and entering the URL
http://portal-(SID).wdf.sap.corp:50100/irjwhere (SID) is to be replaced by your assigned BW system ID. Enter the user ID and password provided by your instructor.
Go to Reporting, Analysis and Planning → Business Explorer → BEx Web Analyzer.
a) From your Citrix desktop, choose Start → Programs → Internet Explorer
b) From the browser window, enter the URL of http://portal-(SID).wdf.sap.corp:50100/irjwhere (SID) is the system ID of your assigned BI system (or simply execute transaction code ZPORTALfrom your assigned BW system).
c) On the Portal logon screen, enter your assigned user ID and password, and then click the Log on button.
d) In the Portal, go to Reporting, Analysis and Planning → Business Explorer → BEx Web Analyzer.
2. Execute the query Sales Analysis 001 (P_SALES_ANALYSIS_001). Use the Search function to search by either the description or technical name.
a) Choose the New Analysis button.
b) In the Open window, check if the Type is Query. If not, change it to Query.
c) Open the Search tab.
d) Enter either the technical name or description. Press the Search button.
Select the desired query and OK.
3. Insert the characteristic Distribution Channel in the drill-down.
Try out both inserting it in the rows and in the columns. Use different navigation techniques.
a) You can use Drag&Drop to insert Distribution Channel in the rows or in the columns.
When using Drag&Drop you can move the characteristics either within the navigation area, or within the result area, or between the navigation area and the result area.
b) Or: from the context menu of Distribution Channel: Change Drilldown
→ Drilldown by → Horizontal / Vertical.
4. Remove the characteristic Distribution Channel from the drill-down, again using different navigation techniques.
a) Use Drag&Drop to move Distribution Channel out of the result area.
b) Or: from the context menu of Distribution Channel: Change Drilldown
→ Remove Drilldown .
5. Exchange Country with Material using Drag&Drop.
a) Drag Material characteristic and drop it directly over the Country characteristic in the navigation area or over the Country heading in the results area.
6. Display the Material using the hierarchy Product Hierarchy for material MARA. Expand and collapse hierarchy nodes, and finally, go back to the initial state of the report.
a) From the context menu of Material characteristic select Properties → Characteristic. From the Hierarchy tab choose the hierarchy Product Hierarchy for material MARA from the drop-down box. Click OK to see the result displayed using the hierarchy.
b) Expand and collapse hierarchy nodes using the symbols at the beginning of the rows.
c) Or: use the functions in the context menu: Hierarchy Node Expanded and Expand Hierarchy.
d) In order to go back to the initial state of the report: from any cell of the report: Right click → Context menu → Back to Start.
7. You have to execute the report again via New Analysis. In the executed report drag and drop the key figure Sales Volume EUR directly onto the key figure Incoming Orders EUR. What happens?
a) Drag and drop Sales Volume EUR directly over the heading Incoming Orders EUR . The sequence of the key figures will be swapped.
8. Remove the key figure Invoiced quantity via Drag & Drop.
Continued on next page
How can you insert the removed key figure in the report again.
a) Drag and drop Invoiced quantity outside the results area. When the mouse pointer changes to show a black cross icon you can then release the mouse button. The Invoiced quantity key figure is now gone.
b) To insert the removed key figure into the report again, you can choose Context menu → Back One Navigation Step.
c) Or: in the navigation pane: use the context menu for Key Figures, then choose Filter → Remove Filter Value.
9. Exclude the Country value United States (US) from the results using drag and drop.
How can you insert the removed value in the report again.
a) Highlight the cell which contains the Country value United States (US), then drag and drop this anywhere outside the results area. Wait until you see the mouse pointer change to show a black cross before releasing the mouse button.
b) To insert the removed value into the report again, you can choose Context menu → Back One Navigation Step.
c) Or: use the context menu for Country, then choose Filter → Remove Filter Value.
10. Now, show results only for Country United States (US) and then add an additional drill-down by Material in the rows to find out which materials make up the total in the United States (US).
a) In the context menu of the cell containing the Country value United States (US) select Filter → Keep Filter Value menu option.
b) Then, from the navigation pane, drag and drop Material at the beginning of the result area, or drag and drop it, within the navigation area, into the Rows as the first characteristic.
c) Or: context menu for Material, then Change Drilldown → Drilldown by → Vertical.
11. Compare the result of the previous navigation option with the result of the following one: go 2 steps back and from Country United States (US) choose the context menu function Filter → Filter and Drill Down by → Material.
Where can you display the filter situation of the report?
a) From any cell of the report: Right click → Context menu → Back One Navigation Step (2 times).
b) Choose the cell containing the Country value United States (US), then right click to show the context menu. Select Filter → Filter and Drill Down by → Material.
c) In order to display the filter situation of the report, press the Info button and look under Dynamic Filters.
d) Or: Use the Filter link on the right-hand upper side of the screen and look in the dropdown box for Country.
12. Remove the filter value for Country and insert Country as the first characteristic in the drilldown, the second characteristic in the drilldown should still be Material. Additionally, repeated key values should not be suppressed any more.
a) Either in the context menu of Country choose Filter → Remove Filter Value.
b) Or: Use the Filter link on the right-hand upper side of the screen, and in the dropdown box for Country choose Clear.
c) Then, from the navigation pane, drag and drop Country at the beginning of the result area, or drag and drop it, within the navigation area, into the Rows as the first characteristic.
d) Choose the Setting link on the right-hand upper side of the screen, then
d) Choose the Setting link on the right-hand upper side of the screen, then