BusinessObjects Board

XML Data Connection refresh and parameters

other Xcelsius - Crystal Dashboard Design
#1

Hi all,
I’m new to Dashboard and I have a problem with xml data connection refresh.
I created a web application that return an XML extract from my oracle db and I set the URL and I seleted application/x-www-form-urlencoder for the MIME type.
All works fine, but if I change data from my db the dashbord doesn’t refresh.
I have select all the options for the refresh as this tutorial shows http://www.youtube.com/watch?v=5lr0hWxpd4M

Second question: can I pass a parameter to my dashboard and use it as parameter of XML data connection URL?

Thanks in advance

seva (BOB member since 2013-11-27)

#2

Have you set the connection to refresh? On a trigger or time-based? Can’t view youtube here. I’m afraid…

Yes - you can pass parameters in and out of an XML connection. I do it all the time. But I just call an aspx script that runs SQL and returms XML data to my dashboard.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

#3

Hi Debbie, thanks for your reply.

Yes, I set the two options

  • Refresh before components are loaded
  • Refresh Ever (I left the default value - 5 seconds)

It’s strange because if I set a local file as URL and change this, the dashboard refresh correctly.

I define a flash variable but how can I pass it to my web application? :oops:

seva (BOB member since 2013-11-27)

#4

Sounds like a connectivity issue, then. Not something I know anything about…

Flash variables I only use to jump around dashboards and pass parameters along - eg: a user selects a location on one dashbaord then moves to another and I use a flash variable to pass this location value with a flash connection. I’ve posted how I’ve done this in some detail on this forum. But I’ve no idea how it would work in a web app - all my stuff outside of xcelsius is handled in an aspx script.

Debbie

Debbie :uk: (BOB member since 2005-03-01)