Passing parameters to Xcelsius

system · March 18, 2010, 2:18am

Hi All.

I am trying to use the opendoc command to pass a parameter to my Xcelsius Dashboard to Filter my Chart. I setup a Combo Selector.

Is this doable and if so how… For example If I only wanted to see USA data on my BarChart and I was calling the SWF from another Web application and wanting to filter with the “USA” selection they made from there WEB app, can that been done and if so How?

Thanks

Charlie

CharlieBobj (BOB member since 2009-07-08)

system · March 18, 2010, 9:03pm

You need to use the ‘Flash Variable’ Connection to pass this information from OpenDoc to Xcelsius.

There are a couple of discussions about this on this site as well as some good tutorials on other sites. A Google search will show you both.

psurphr (BOB member since 2008-02-28)

system · March 18, 2010, 9:49pm

I have not seen one person do what I am asking so far. I checked this site and other artilces…
It must not be possiable…

Thanks
Charlie

CharlieBobj (BOB member since 2009-07-08)

system · March 18, 2010, 11:50pm

Just because someone else hasn’t done it doesn’t mean it cannot be done, it just means no one else has done it.

We send parameters to our SWF files using OpenDoc all the time. Here is an example OpenDoc statement that we use, it’s passing 2 parameters; TIN and PRCP. We usually bring these into Xcelsius and then pass them to QaaWs to get our data, but they can just as easily be used to filter your Chart.

http://<webserver>/OpenDocument/opendoc/openDocument.jsp?&amp;iDocID=AQ.BANzJE7RLu8q3Rv.9eHc
&amp;sIDType=CUID
&amp;sType=Flash
&amp;lsSTIN=9999999998
&amp;lsSPRCP=111111111

You have to use Flash Variables to pass these from OpenDoc into your Xcelsius. In the above senario I have 2 variables; TIN and PRCP setup.

I don’t want to duplicate information that is already out there so here is a good resource to setup your Flash Variables:
http://ryangoodman.net/blog/index.php/2007/09/26/flash_variables_in_xcelsius

psurphr (BOB member since 2008-02-28)

system · March 19, 2010, 2:07am

Sorry,

I just got a bit Fustrated…

I figured it out and I am able to Filter the Data on the Dashboard with the Parameter I am passing.

Thank you for your help!!!

Charlie

CharlieBobj (BOB member since 2009-07-08)

system · March 24, 2010, 1:55pm

Hi,

CharlieBobj could you please share your solution so that others like myself can benefit from it.

Thanks

shawzozo (BOB member since 2006-08-08)

system · March 29, 2010, 8:08pm

To All:

Here is my simple example that I created to show how to pass a parm into Xcelsius and filter the data by the parm.

Here is the OpenDoc Command:

http://cmck-vmdevbobj1:8080/OpenDocument/opendoc/openDocument.jsp
?sType=swf
&amp;iDocID=103894
&amp;lsSProductVar=Product 2
&amp;nbPrompts=1
&amp;sRefresh=Y

Note the &lsS parm, this is were I specified the FlashVar. The value I am passsing is “Product 2”.

The FlashVar is specified in the Data Connections, it is named ProductVar and is mapped to Cell C14. Which is also the Destination of the ComboBox Filter. Also, another key is to set the Behavior within the ComboBox to Dynamic and bind it to cell C14. Everything else is pretty basic…

I have attached the XLF file for all to view. Hope this helps! I know when I was trying to figure this out, I was wishing I had a working example to review. Now everyone has one.

Best Regards
Charlie

CharlieBobj (BOB member since 2009-07-08)

system · May 19, 2010, 4:26pm

Charlie,

I cannot view your atached example. Could you please send it to rogershiltz@yahoo.com.

Thanks,
Roger

rogershiltz (BOB member since 2010-05-19)

system · July 23, 2010, 9:27pm

Hi CharlieBobj,

I couldn’t see the attached example. Can you please upload the same?

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)

system · July 26, 2010, 12:23am

Hi Charlie i am all the ones who are new to Xcelsius will really appreciate when the member post solution. So i just wanted to thank you for posting the solution.

sanappi (BOB member since 2010-05-03)

system · December 27, 2010, 3:57am

Hi Charliebobj,
Could you please share your sample SWF file where you had defined Flash Variable to us? I am new in Xcelsius and I need to create Flash Variable.

Philip (BOB member since 2006-03-02)

system · June 29, 2011, 1:24pm

Can any one of you share your SWF file how did you pass your parameters… That would be great…

Thanks in Advance…

listener (BOB member since 2011-04-26)

system · July 1, 2011, 4:16am

This can help

rizwan syed (BOB member since 2010-07-08)

system · October 19, 2016, 6:17am

Hi charlie,

Could you please share your sample file. I am also stuck here and couldnt make it work.

vijesh.chandra (BOB member since 2009-05-29)