SAP Knowledge Base Article - Public

1732883 - How to use Hierarchical Prompt in Dashboard Designer 4.0

Symptom

  • Query Prompt Selector is the new object added to Dashboard Designer start from Dashboard Designer 4.0 Feature Package 03 
  • Query Prompt Selector is support the selection against Hierarchical Object
  • How to use Hierarchical Prompt in Dashboard Designer 4.0

 

 

Environment

  • SAP BusinessObjects Dashboards 4.0 Feature Package (FP) 03
  • SAP BusinessObjects Dashboards 4.0 Support Package (SP) 04 and above

 

Resolution

Scenario 1:

  1. From Information Designer Tool, create a connection with Business Warehouse BEx Query which include Hierarchical Object.
  2. Publish the BEx Query connection to Repository.
  3. Open Dashboard Designer, click File and select New to create a new Dashboard.
  4. Open Query Browser tab, click Add Query and login BusinesssObjects Enterprise.
  5. From the prompt up page, select BEx and click next.
  6. Select the connection you published and click next.
  7. Drag the Dimensions and Key figures to the Result Objects panel, drag the Hierarchical Object to the Filters panel, change the type of the filter to Prompt and configure the prompt.
  8. Click Next, select the value for the prompt and click Run.
  9. The data preview page will display, click next and configure the refresh option.
  10. Click ok to finish.
  11. Open Query Browser tab and drag the prompt to the design window. The message "To add a Query Prompt Selector component, drag it onto the canvas" will display if move the mouse onto the prompt.
  12. Open Components tab and drag the Scorecard component to the design window.  
  13. From the General configure page under Display Data section, click the arrow icon, click Query Data and select the Result Objects which need to be displayed.
  14. Preview the Dashboard, the members of prompt will organized hierarchically, the data display from Scorecard will change according to which members selected.

Scenario 2:

  1. From Information Designer Tool, create a connection with Business Warehouse BEx Query which include Hierarchy Node Variable.
  2. Publish the BEx Query connection to Repository.
  3. Open Dashboard Designer, click File and select New to create a new Dashboard.
  4. Open Query Browser tab, click Add Query and login BusinesssObjects Enterprise.
  5. From the prompt up page, select BEx and click next.
  6. Select the connection you published and click next.
  7. Drag the Dimensions and Key figures to the Result Objects panel and click next.  
  8. Select the value for the prompt and click Run.
  9. The data preview page will display, click next and configure the refresh option.
  10. Click ok to finish.
  11. Open Query Browser tab and drag the prompt to the design window. The message "To add a Query Prompt Selector component, drag it onto the canvas" will display if move the mouse onto the prompt.
  12. Open Components tab and drag the Scorecard component to the design window.  
  13. From the General configure page under Display Data section, click the arrow icon, click Query Data and select the Result Objects which need to be displayed.
  14. Preview the Dashboard, the members of prompt will organized hierarchically, the data display from Scorecard will change according to members selected.

 

Keywords

Dashboard Designer, Dashboard Designer FP03, Dashboard Designer SP04, Xcelsius, Xcelsius 4.0, FP03, SP04, Hierarchy, Hierarchical, Hier, New Feature, Hierarchy prompt, Hierarchical prompt, Hierarchy filter, Hierarchical filter

, KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 4.0