Dynamic selection of Characteristic and Measures for Charts in Web Intelligence

Dynamic selection of Characteristic and Measures for Charts in Web Intelligence

Key Concept:

As you all Know, we have limitation with the amount of data that dashboard can process and complexity involved in dynamic visibility when more number of dimension and Measure are considered in your design. 

Hence we are replicating the dashboard functionality of changing the characteristics and Measure  for a particular chart given as a selection for user to control and thereby by we can also have drill down into details charts also.

Steps To Do :

    This demo is built on SAP BEx Query as a source using BICS Connection in Web Intelligence tool.

1. Create a dummy dimension variable “Dim_MD“ with anyone of the dimension value which you would like to change as shown below.

2. Now create a Input Control on dummy Varible “Dim_MD“ which was created in step1 and input the List of Values in Custom as shown below

Here we have harcoded the LOV's  as Application, Application Source, Activity Type,Activity,Job, Organizational Unit..which will shown as combo box in Input control.

        3.  As mentioned above in step 1 and 2, we will create a dummy dimension variable for Key figure selection as “Dim_KF“  and create an input control and insert the List of value in Custom  as shown below.

                        

            

              

    

       

         

          Here the List of Values for Key Figure variable is hardcoded as Rating,Ranking and Weekly working   hours.

      4.  Now create a Dimension varible as “Dim_MD_Val“ and use the  Reportfilter Function to capture the selected value and call the respective infoobjects with the formula below.

=      =If ReportFilter([Dim_MD])="Application" Then [Application] ElseIf ReportFilter([Dim_MD])="Application Source" Then [Application Source] ElseIf ReportFilter([Dim_MD])="Job" Then [Job] ElseIf ReportFilter([Dim_MD])="Organizational Unit" Then [Organizational Unit]

    

      5.  In the same way, We will create a Measure Varible  that captures the selection of Key figure selected in the“Dim_KF“ Input control as shown below

=If ReportFilter([Dim_KF])="Rating" Then [Rating] ElseIf ReportFilter([Dim_KF])="Ranking" Then [Ranking] ElseIf ReportFilter([Dim_KF])="Weekly Working Hours" Then [Weekly Working Hours]

6. Now use the above two variables in your charts and dynamically change characteristics and measures with 
input controls as shown.

In the above figure, Selected Dimension = Application Source   and

                                    Selected Measure    = Rating 

Here Selected Dimension = Organizational Unit    and

         Selected Measure     = Ranking

      Conclusion :

 In this way, we can develop our dashboard in Web Intelligence with less complexity.