Home / Highlights / Five Cool Techniques to Keep up Your Sleeve to Design Visually Appealing and Dynamic Webi Reports
InfoSol Blog Tech Tip

Five Cool Techniques to Keep up Your Sleeve to Design Visually Appealing and Dynamic Webi Reports

First: To capture the value selected in Input Control/ Element Link in a cell

Goal:

Input Control and Element Linking are very frequently used WebI features to create highly interactive WebI reports or dashboards. The goal is to display the user selected option from the radio button/drop down/list box or selected in a table or chart view.

Challenge:

The Input control does not list a Cell as dependent element.

There is currently no built-in function to capture a specific Input Control selection.

Solution:

Use the following formula and display in a Cell

=If(Pos(ReportFilterSummary();”ObjectName Equal “)=0;”ObjectName: All”;”ObjectName: “+[ObjectName])

ReportFilterSummary is the only function that lists selection as part of all the report and block filters.

Example:

Visualization data elements: Number of Order by Product Name: This is the dependent block.

Input Control: Product Group: All option included

Add a Cell to the Report and add the following variable with the stated formula:

vSelectedProductGroup =If(Pos(ReportFilterSummary();”Product Group Equal “)=0;”Product Group: All”;”Product Group: “+[Product Group])

This way you don’t need to calculate the position or length of the value within ReportFilterSummary() result. You will check whether a value is selected or not.

Download the rest of the tips below.

About Runali Ghosh

Runali provides consulting and training for SAP BusinessObjects (Dashboard 4.x, Xcelsius, Web Intelligence, Universe, IDT, Explorer, BI Mobile, Data Services) and InfoBurst Enterprise at InfoSol. She has over 10 years of experience with programming, development and analysis with Business Intelligence, Database and ERP Suits (Oracle and SAP - order management, inventory, distribution and payables). Runali successfully led and managed several business-critical projects to develop custom interfaces, dashboards, universes, and reports. Her passion for data and data visualization has enabled her to be a key performer in the area of business intelligence deployment.

Check Also

InfoSol Blog Tech Tip

Using an Input Control to Sort in Web Intelligence

In Design mode of Web Intelligence, you can change the sort order of columns in ...

Leave a Reply

Your email address will not be published. Required fields are marked *