Difference between “When value Becomes & When value Changes”

March 18, 2014 | 396 Views |

Suman Thangadurai

Hi all,

Intention of this post is to explain the difference between “When value becomes” & “When value changes” in Refresh option in the Dashboard Designer. I have used the Query refresh button here to explain the differences.

Rather than explaining with the dummy information, I decided to go with the real-time information. This dashboard is used to view the Collection done by Finance department by Segment, Plant, Month & Date.

I have created a dashboard, which is displaying four charts

Pie Chart – Segment info in percentage
Combination Chart 1 – plant wise info
Combination Chart 2 – month wise info
Line Chart – day wise info

Prompts applied to chart:

Pie Chart – Month(Ranges From – to)
Combination Chart 1– Month(Ranges) & Segment(Pie chart)
Combination Chart 2 – Month(Ranges), Segment(Pie chart) & Plant(Combination Chart 1)
Line Chart – Segment(Pie chart), Plant(Combination Chart 1) & Month (Combination Chart 2)

Pie Chart – Prompt

Combination Chart 1– Prompt

Combination Chart 2– Prompt

Line Chart – Prompt

All four charts are having different BW queries created in query browser to get the data into pieces of information. Generally the triggering option for the reports will be “When the value changes” i.e., when a value changed for any query using any selector automatically the data gets refreshed. But here the month is the major prompt which is having the ranges so customers need to hold the trigger until they confirm the ranges. So I have used the push button as “Submit” to confirm the changes. Once the “Submit” button is clicked the queries get triggered. Except pie chart all other three are having other prompts which are triggered when the user clicks any series values basically driven by insertion tab in the properties.

I have used four refresh button to refresh all four charts, Except the first refresh button (Pie chart) all other refresh button trigger dynamically by using “When value changes”. Let us see how the chart are get triggered now.

Pie chart (Query Refresh Button 1)

Note: I have used the option “Refresh after Components are loaded”, so here the dashboard invokes quickly and looks for the data.

Combination chart 1(Query Refresh Button 2)

Combination chart 2(Query Refresh Button 3)

Line Chart (Query Refresh Button 4)

Make sure to remove all “Refresh before components are loaded” option from the queries.

Hope this document help to understand the difference in-depth.

To report this post you need to login first.

22 Comments

You must be Logged on to comment or reply to a post.

hari krishna March 19, 2014 at 5:06 am

Hi Suman,

The drill down functionality is good it is easy with less Excel functions and I hope the performance will be good. To drill down 3-4 levels I used to use many excel formulas but there are very few here(no lookups used) and I would use this approach in future.

Thanks&Regards

Krishna

like (0)
1. Suman Thangadurai Post authorMarch 19, 2014 at 5:19 am
  
  Hi Krishna,
  
  Thanks for your feedback.
  
  Always my approach is to eliminate as much as excel formula in the development. So that your dashboard performance will be good.
  
  Suman T
  
  like (0)
  1. hari krishna May 20, 2014 at 9:22 am
    
    Hi Suman,
    
    In the prompts applied in the charts(line and combination) you have not selected any values for the prompt. Normally if we don’t pass any values to the prompts then we get blank data. How could you get the data.
    
    Thanks&Regards,
    
    Krishna
    
    like (0)
    1. Suman Thangadurai Post authorMay 20, 2014 at 10:05 am
      
      Hi Hari,
      
      By default i have selected the first values bar in the combination chart, you can see that in the subsequent chart title, i am not leaving the prompts empty even at the time of invoking.
      
      Off-course as you said it cannot empty, i have made the prompts as mandatory by removing the optional prompts.
      
      SumanT
      
      like (0)
      1. hari krishna May 20, 2014 at 10:52 am
        
        Hi,
        
                       Thanks Suman for the reply, could you send a Sample xlf file of this that would be great.
        
        Thanks&Regards,
        
        Krishna
        
        like (0)
        
        Suman Thangadurai Post authorMay 20, 2014 at 11:00 am
        
        Send me a test mail for your mail id, i will reply back to that attaching the xlf. you can get my mail id from my profile page.
        
        like (0)
        
        hari krishna May 20, 2014 at 11:30 am
        
        Hi Suman,
        
                                    I could not get find your mail id in the profile page, could you please update there or you can get my mail id in my profile page and send the file that would be great.
        
        Thanks for your help,
        
        Krishna
        
        like (0)
        
        Suman Thangadurai Post authorMay 20, 2014 at 11:37 am
        
        Even i cannot see your id.
        
        like (0)
        
        hari krishna May 20, 2014 at 11:56 am
        
        Hi Suman,
        
                          Please check now it is visible.
        
        Thanks&Regards,
        
        Krishna
        
        like (0)
        
        Yash Patel May 28, 2014 at 12:55 pm
        
        Hi suman,
        
        can you please pass this Xlf for reference, my id is y22m7p91@yahoo.co.in
        
        Thanks in advance,
        
        Yash
        
        like (0)
Balakumar Krishnasamy July 25, 2014 at 9:36 am

Hello Suman,

This is great . Can you please mail me your xlf for the reference…. I would like to use this approach.. my mail id is “balakrish258@gmail.com”

Regards,

Bala Krish

like (0)
1. Suman Thangadurai Post authorJuly 25, 2014 at 10:20 am
  
  Thanks sent to your id.
  
  like (0)
  1. Devadas Perika October 24, 2014 at 6:33 pm
    
    Hi Suman,
    
    Many thanks for your simple explanation. I’m new to Dashboards and I have a similar requirement would you be kind enough to send me the xlf files too please to dperika@gmail.com
    
    Thanks a million
    
    Dev
    
    like (0)
  2. Ben Li May 2, 2015 at 2:08 pm
    
    Hi Suman,
    
    I have a requirement as follows
    
    1. Default region assigned for each user and a table 1has details.
    
    2. Currently dashboards designed to refresh components before load
    
    3. There are 15 queries which has region filter is mapped to single cell and the cell is hardcoded with default value.
    
    4. Drop down box for region is created and the target data is mapped to same cell above and hence when user selects some region and clicks refresh everything will be refreshed
    
    Now I need the default region to come from the table 1 when initial loading to happen.
    
    I tried by making this query as refresh before components to load and rest all queries refresh when value changes. However I am not able to meet the requirement.
    
    Appreciate if you have any thoughts
    
    Thanks
    
    like (0)
    1. Ben Li May 3, 2015 at 7:09 am
      
      Hi Suman,
      
      Any thoughts on above?
      
      like (0)
Devadas Perika October 27, 2014 at 10:54 am

Suman,

Many thaks for providing the file

ta

like (0)
Karthik Morishetty November 18, 2014 at 6:18 am

Hi Suman,

Good work, and information is helpful.

Thank you so much for the information.

like (0)
1. Suman Thangadurai Post authorNovember 18, 2014 at 6:47 am
  
  Thanks Karthik 🙂
  
  like (0)
Muhammad Faisal Akram May 5, 2015 at 11:11 am

Good work …Thanks for sharing.

like (0)
Ravi kumar September 17, 2015 at 11:32 am

Hi Suman

Good work …

Please Share Me the File

Advance Thanks

Ravi Kumar A

like (0)
R S October 12, 2015 at 5:34 am

Hi Suman,

Nice and informative post.

Can you please send me your xlf to my mail id b124847@gmail.com

Regards,

Ravish

like (0)
Arjun Ajit December 8, 2016 at 6:45 am

Hi Suman,
Very informative and different approach for Drill down.
I just started working on BO Dashboards and I am having similar drill down requirement from our client. Can you please send me the .XFL file to arjunsai09@gmail.com. Sorry I couldn’t find your email in your profile.
Thank you for the knowledge sharing.
-Arjun.

like (0)