INFORMATION NOW

On this coming Wednesday (5th November), I will hopefully be giving my first keynote presentation at the 2nd International Malaysian Educational Technology Convention (IMETC). If things go as planned, I will be the first speaker at the event, which should generate some big butterflies in my stomach. But strangely enough, I am actually looking forward to it (at least for now!). And currently my biggest worry is to be able to discuss (in human understandable way!) my 100+ slides within the one hour given. Now, that is a challenge! Hopefully, I will be able to say the things I want to say.

"Rehearse and use a script, please!" Good idea, but I want it to have a natural flow (A learning conversation with the audience and myself), so no script, except for the slides (Though, if I was a President I would use one!). I hope my ideas and reflections will be free flowing guided by the spicy slides. It will be an interesting experiment, which will be revealed in Part 2. Also, Part 2 (next post) will discuss and reflect all the things I would have learned during this 3-day learning adventure. No, I am not yet ready for any live UStream show!


PRESENTATION SLIDES
In the keynote presentation, I will first discuss a bit about how my first ebook entitled 69 Learning Adventures in 6 Galaxies came to life. Then, I will explore some learning or thinking skills we need to nurture in students and ourselves to be successful in todays fast evolving innovation world. I will also look at some of the educational challenges we might face, and explore a case study on how I revamped a critical thinking course. Finally, I will look at some possibilities and conclude the learning overload session. In short, we are all probably going to get dizzy (learning overload!) one way or the other. Anyway, here are the slides to enjoy before the actual event:

Interestingly, the slides have already been featured on SlideShare homepage (within 3 hours upon upload). So, at least the slides seems to be a bit interesting. Lets hope the actual keynote presentation also turns out to be interesting, engaging and useful to those attending the event.

I suppose after all my past workshops and 20-minute presentations (taken a 2-year break from that!), I kind of look forward to this great opportunity to talk for one hour (or less) to a bunch of people about the things I have learned over the last few years. And for that, I am truly grateful to God (Allah) and would like to also thank the organizers for giving me this opportunity. Thank you so much!

Until part 2, have fun trying to make sense of my slides. If they dont make sense, perhaps you could invite me to give a talk. Though, I would prefer if I was given 2 hours. Meaning, we will have approximately one hour to discuss, reflect and learn together. Now, that is where the real learning will take place :)

Hi Guys,

This post will talk about below scenario........

Scenario Explained:
When you navigate from one dashboard to another dashboard , in some cases you might need to pass the selected parameter values on Dashboard 1  to  Dashboard 2 selects.

i.e., In simple terms, it is not the category names passing from any chart on performing click action but it is passing the input controls values from one dashboard selects to another dashboard selects. (Take input controls from DB-1 and make them to sit on input controls of DB-2 and then allow user to select other inputs if he/she wants on it)

This sample is developed on : C-Tools of 14.06.18.1 stable version of CDE,CDF,CDA with bootstrap supported.

You can perform below :
1) Default values for selects (dates and other drop downs)
2) Select user wished inputs in selects on Dashboard-1.
3) Provide a button/link to drill down to Dashboard-2 with the selected inputs on Dashboard-1.
4) On Dashboard-2 selects , the values will coming from Dashboard-1 will be placing.
5) Components(Charts and tables and etc) on Dashboard-2 will listen to these input selects.
6) Change the inputs to other values by selecting here on Dashboard-2 and corresponding components will listen to them again.
7) Link/Button to drill back to Home dashboard -It can be default stage of Dashboard-1 OR reversely can apply the same logic to place the changed values of DB-2 up on DB-1 selects.

In this example I have taken 3 inputs on Dashboard-1.
They are :
1) From Date
2) To Date and
3) ID

Dashboard -1 Development : 
Step-1 : Lay Out

Below code is for : A panel with body and to for the place holder for lables and selects(Dates and others) and majorly for a Button(On which we are going to do some magic). 

Row ->Column -> HTML
and the Bootstrap HTML code is :

<div class="col-md-12 ">
    
            <div class="panel panel-primary">
            
            <div class="panel-heading">
                
                <h3 class="panel-title" id="DashboardName">Dashboard-1 Send the Selected Parameters to Dashbaord-2 Selects
                
               
                 <button onclick="sendParameters()" type="button" class="btn btn-default btn-xs pull-right">
                   Dashboard-2
                </button>
                </h3>
                <div class="clearfix"></div>  
                    
                
            </div>
            
            <div class="panel-body">
              <span class="labelcss"><b>From Date</b></span>
              <span id="FromDateSelect"></span>
              &nbsp;&nbsp;
              <span class="labelcss2"><b>To Date</b></span>
              <span id="ToDateSelect"></span>
              
              &nbsp;&nbsp;
              <span class="labelcss3"><b>ID</b></b></span>
              <span id="IDSelect"></span>
              
            </div>
            
            </div>
</div> 

Step 2: Creating parameters and Selects 
As shown in below figure create 3 parameters and selects for them.
i.e., param1_FromDate, param2_ToDate,param3_ID for parameters
and select1_FromDate, select2_ToDate and select3_ID for selects 

Make the selects to listen to the associated parameters.
Note that in this example I have not taken any SQL for drop down selects instead created an array for drop down.


Step : 3
Have a preview of the dashboard once done with step 2 and you can observe there you will not be drill down action when clicking on button component.

Here, lets come back to Lay out section and add a Java Script resource.
Write below code in Java Script Code Snippet

function sendParameters(){
    
   //Test whether your parameters holding the values in an alert message 
    alert("From Date="+param1_FromDate+"
"+"To Date="+param2_ToDate+"
"+"ID="+param3_ID);
   
//Perform drill down to 2nd dashboard when clicking on Button Component 
var url=
http://localhost:8080/pentaho/api/repos/%3Apublic%3AExplore%3ACDEExploring%3ADevelopement%3AParametersPassingFromDB1SelectsToDB2Selects%3ADashboard2.wcdf/generatedContent;
       
 //Open up 2nd dashboard with parameters passing along with URL   
window.location=
url+?send1_FromDate=+param1_FromDate+&send2_ToDate=+param2_ToDate+&send3_ID=+param3_ID;
       

}

Dashboard -2 Development :

Development of this dashboard has to done separately to take its URL on Dashboard -1 java script

Develop your dashboard with the same input controls (Why to develop again ? Let us SAVE AS with other name and with few modifications - Remove script code, make button component URL in HTML script for HOME dashboard)

Add below script in Java Script Code snippet resource..
i.e., Capturing the values into parameters and internally the selects will take these input values..and later on Dashboard-2 user can select/change on input values on different selection.

param1_FromDate= Dashboards.getQueryParameter(send1_FromDate);
param2_ToDate= Dashboards.getQueryParameter(send2_ToDate);
param3_ID= Dashboards.getQueryParameter(send3_ID);

Dashboards.getQueryParameter(<parameterSenderStringFromDashboad1>) will capture the value from the URL and assign these values to respective parameters.
Download the above qualified Example :  Click Me

Download a quick simple example here :  Click Me

Readers and community developers are encouraged to add your feedback ,suggestions and/or improvement of this post in comments section.

Sadakar Pochampalli
BI developer
(Jasper/Pentaho/Talend ETL)
Hyderabad, Telangana.