Using a Variable to Access a Hierarchy Node Directly

If the hierarchy is very large, users might want to jump directly to a particular hierarchy node when running a query. One way of achieving this goal is to use variables. Next, we describe a procedure to create a variable.

Work Instructions

Step 1. Log on to the BW system, and then click Maintain Variables or run transaction RSZV.

 

 

SCREEN 5.23

graphics/05fig23.gif

Step 2. Change the display mode to the create/change mode by clicking graphics/changeswitch.gif.

 

 

SCREEN 5.24

graphics/05fig24.gif

Step 3. Click graphics/newentries.gif to create a new variable.

 

 

SCREEN 5.25

graphics/05fig25.gif

Step 4. Name the variable as V_SREG. After entering the other basic information requested, click graphics/sapguiwindow.gif to provide more information.

 

 

SCREEN 5.26

graphics/05fig26.gif

Step 5. Enter IO_SREP in the field Characteristic, as it is associated with the hierarchy. Make other selections as shown in the screen, and then click graphics/save.gif to save the variable.

 

 

SCREEN 5.27

graphics/05fig27.gif

Next, we will use the new variable to enhance the query IC_DEMOBC_Q01 created in Section 5.1.

Step 6. Return to the query created in Screen 5.14. Select graphics/salesrevenue.gif, and then select Change query (global definition)….
 

SCREEN 5.28

graphics/05fig28.gif

Step 7. Right-click Sales rep. ID, and then select Restrict.

 

 

SCREEN 5.29

graphics/05fig29.gif

Step 8. Select Variable: sales reg. from the left window and move it to the right window by clicking graphics/rightwindow.gif. Next, click graphics/ok.gif to continue.

 

 

SCREEN 5.30

graphics/05fig30.gif

Step 9. Click graphics/sapguiwindow.gif to save and execute the query.

 

 

SCREEN 5.31

graphics/05fig31.gif

Step 10. Click graphics/yes.gif to save the query.

 

 

SCREEN 5.32

graphics/05fig32.gif

Step 11. Click graphics/c.gif to display the hierarchy nodes.

 

 

SCREEN 5.33

graphics/05fig33.gif

Step 12. Select East, and then click graphics/continue1.gif.

 

 

SCREEN 5.34

graphics/05fig34.gif

Step 13. Click graphics/clock.gif to continue.

 

 

SCREEN 5.35

graphics/05fig35.gif

Result

The query result (Screen 5.36) contains only the East region data.

SCREEN 5.36

graphics/05fig36.gif

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net