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.
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.
Step 6. Return to the query created. Selectand 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.
Result
The query result contains only the East region data.
|
|
SAP BW Related Interview Questions |
|
---|---|
SAP BI Interview Questions | SAP WM Interview Questions |
SAP BO Interview Questions | SAP Netweaver Interview Questions |
SAP BODS Interview Questions | SAP Webi Interview Questions |
SAP Web Dynpro Interview Questions | SAP BDC Interview Questions |
SAP BW on HANA Interview Questions |
SAP BW Related Practice Tests |
|
---|---|
SAP BI Practice Tests | SAP WM Practice Tests |
SAP BO Practice Tests | SAP BODS Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.