Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata
 

This BOpedia page is provided by the RIG team. Don't hesitate to put comments.

Product versions: BOE XI 3.1 SP2

 
 

Overview

There is a new feature "Input control" on Web Intelligence Report in BOE XI 3.1 SP2, which allows users to use the control to filter the data on a dimension in the report. However, if users want flexibility to change dimensions at view time, it seems difficult to make it work the same way as the Input control does. For example, based on the eFashion universe, if users want to show the sales revenue, and do the analysis by selecting the group-by dimension from "State" and "Line" separately, they have to create separate reports.

Fortunately, we can apply a trick to leverage the feature of Input control, below is the detailed workflow.

Steps to create a report which we can change dimension at view time

  1. Start the WebI rich client, create a query and select 3 objects:"City","State" and "Sales revenue", the dimension "City" here will not appear in the report, we only need it to occupy a column position
  2. Manually modify the query, replace the "City" with "type" which has two values "State" and "Line", and union the two queries to retrieve the data including both by "State" and by "Line":
    SELECT
    'State' as type,
    Agg_yr_qt_rn_st_ln_ca_sr.State,
    sum(Agg_yr_qt_rn_st_ln_ca_sr.Sales_revenue)
    FROM
    Agg_yr_qt_rn_st_ln_ca_sr
    GROUP BY
    Agg_yr_qt_rn_st_ln_ca_sr.State
    union all
    SELECT
    'Line' as type,
    Agg_yr_qt_rn_st_ln_ca_sr.Line,
    sum(Agg_yr_qt_rn_st_ln_ca_sr.Sales_revenue)
    FROM
    Agg_yr_qt_rn_st_ln_ca_sr
    GROUP BY
    Agg_yr_qt_rn_st_ln_ca_sr.Line
  3. refresh the report, you will see data from both group-by State query and group-by Line query. Make the type as the section, we will see two sections in the report, one is the analysis report based on State, the other is based on Line.
  4. create an Input Control, choose the object "City", label it as "Choose analysis type", input List of Values with "State" and "Line", set the Default value as "State".
  5. Now you can choose a dimension from the input control panel, when you choose "State", it will show the sales revenue report based on State,

    when you choose "Line", it will show the report based on "Line".

Summary

With the usability to change dimension at view time, users may have more flexibility when doing analysis with WebI.

  • No labels

3 Comments

  1. Guest

    Thanks a lot, Really  Interesting information.

  2. Usefull information. Thank you.

  3. Guest

    It is good to understand the functionality of input control