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.
Step 1. Log on to the BW system, and then click Maintain Variables or run transaction RSZV.
Step 2. Change the display mode to the create/change mode by clicking .
Step 3. Click to create a new variable.
Step 4. Name the variable as V_SREG. After entering the other basic information requested, click to provide more information.
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 to save the variable.
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 , and then select Change query (global definition)….
Step 7. Right-click Sales rep. ID, and then select Restrict.
Step 8. Select Variable: sales reg. from the left window and move it to the right window by clicking . Next, click to continue.
Step 9. Click to save and execute the query.
Step 10. Click to save the query.
Step 11. Click to display the hierarchy nodes.
Step 12. Select East, and then click .
Step 13. Click to continue.
The query result (Screen 5.36) contains only the East region data.
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
Aggregates and Multi-Cubes
Operational Data Store (ODS)
Generic R/3 Data Extraction
Appendix A. BW Implementation Methodology
Appendix B. SAP Basis Overview
Appendix C. Glossary
Appendix D. Bibliography