Tuesday, April 26, 2011

Set up Event based Interactions between the Indicators in SAS BI Dashboard 4.3

Setting up the interaction between multiple indictors is a cool new feature in SAS BI Dashboard 4.3, It is similar to events for anyone who is familiar with the Java script will be familiar with ONCLICK, ONCHANGE etc. events.

In this Example I have two separate indicators which have been dragged on a Dashboard. The two Indicators have separate data sources. A Dynamic List box Indicator which has a SAS Table SASHELP.CLASS as data source. A Spark Table indicator a Stored Process which accepts Sex parameter as a data source No default value is required, the STP code should return all the rows if no value are passed in the parameter (In order to apply Client side filter).

I want to set up an Interaction between the two so that the selection in the Dynamic List box will change the values in the Spark table.

In order to set up an interaction select the Source indicator in our case the Dynamic list, Edit -> Set up Interactions.



There the selected Indicator becomes the source and the rest of the indicators become targets, the source and the target parameters have to be selected.






If you check the Show Interactions Check box in the Dashboard properties the interaction between the Indicators will be displayed as arrows.






The final output looks like this when viewed from the dashboard viewer, the data in the spark tables are updated as per the selection in the Dynamic List prompt.

7 comments:

  1. Hey Saketh,
    Can you let me know how to customize th SAS portal and SAS BI Dashboard web Browser titles in quick moments? Is there any branding trick for it?

    ReplyDelete

  2. Nice information. Our institute Is the Leading online institute in Hyderabad, India to provide sas online trainings with the real time experts and certified professionals. alot sas Online Training.

    ReplyDelete
  3. Thanks for sharing,Actually i have tried this in various method but i can't get a clear output, i will implement this method to get a exact result.sas training in Chennai

    ReplyDelete
  4. Thank you for sharing this knowledge in a blogpost.Really simple and even more effective and this worked great, very useful tips
    sas online training

    ReplyDelete
  5. TANGEDCO Recruitment 2016 AE Technical Field Assistant Typist

    Very interesting thanks. I believe there's even more that could be on there! Keep it up........

    ReplyDelete
  6. BHEL Bhopal Apprentice Recruitment 2016

    Very well written information. It will be beneficial to anyone who utilizes it, Keep up the good work....

    ReplyDelete



  7. The structs is a complex data type declaration used in the C programming language that helps you to define a physically grouped list of variables to be placed under one name in a block of memory.
    struts training in chennai | struts training | struts training center in chennai

    ReplyDelete