Frequently Asked Question

Symptom

• Create a Webi document with at least 2 reports (sheets)
• Create a Webi Input Control based on the entire document
• Insert a N4V navigation element (for instance, a dropdown list) on one of the Webi reports.
• Affect the N4V navigation element to the Input Control.
• When selecting a value in the dropdown list, the Input Control is not affected. 

Environment

• SAP BusinessObjects Business Intelligence Platform : all 4.2/4.3 Webi versions
• Need4Viz : all versions

Cause

The Webi features used by N4V elements to interact with Input Control are not yet implemented by SAP to interact with Document Input Controls.

Resolution

Using a N4V navigation element interacting with the whole document is possible by controlling a Webi variable instead of an Input Control.

1. For a single value selector (list, radio button...)

• Create a Webi variable (for instance "V_State" content ="") and affect the control of the N4V element to this Webi variable :
• Create a second Webi variable to compare the dimension value with the result of the controled variable (containing "=[dim]=[V_dim]") :
• Use this variable to filter all the Webi blocs or entire reports in the document (filter on the "1" value) : 

2. For a multi values selector (multi list, checkboxes...)

• The scheme is approximately the same as previously : 
• Create a Webi variable (for instance "VCode" content ="") and affect the control of the N4V element to this Webi variable
• Create a second Webi variable to test if the value of [Code] is in the selected list [VCodes], the formula is =Pos([VCodes];[Code]). If the return is >0, then the value is in the list.
• Use this variable to filter the reports elements in the whole document.