Frequently Asked Question
Use Input Control filter in whole report except on Need4Viz navigation elements
Last Updated 5 years ago
Symptom
- Create a Webi report with blocs and an Input Control on the whole report
- Configure a Need4Viz navigation element based on that Input Control
- When you choose an item in the navigation element, the bloc is correctly filtered but the navigation element is itself filtered
Environment
- SAP BusinessObjects Business Intelligence Platform : all 4.2 Webi versions
- Need4Viz : all versions
Cause
- The Need4Viz component is considered by Webi engine like any other bloc. So when the Input Control is activated on the whole report, the Need4Viz component is filtered too.
- From Need4Viz engine side, the data sent by Webi are already filtered so the engine cannot apply a like NoFilter option.
- The NoFilter() cannot be used in the object definition used in the navigation element because this Webi function can only be applied on a measure (not a dimension)
Resolution
There are 2 ways to configure a Need4Viz navigation element to not be filtered by a Webi Input Control :
1/ Throught the Input Control perimeter
- do not activate the Input Control on the whole report
- but only on each individual blocs/charts you want to be filtered excepeted the Need4Viz navigation element
2/ Use a specific query for the list of values
- As the Need4Viz navigation elements just send selected value(s) to an Input Control (and not read information from the Input Control to build it's own list of values), an individual query that just give all the list of values can be used to feed the Need4Viz navigation elements. Example :
- Define a main query with dimensions and measures. "Year" is one of the dimensions
- Build a bloc with the data and an Input control based on the "Year" dimension
- Affect the Input Control to the whole report
- Build a new query to retrieve only "Year" dimension
- Do not merge the "Year" dimension between the 2 queries
- Build a Need4Viz Navigation Simple List based on the "Year" dimension of the second query and affect it to the Input Control -> when selecting a year in the navigation element, the bloc is filtered correctly and all the year values still remains in the Need4Viz element