Dashboard Automation - Xcelsius 2008 Enterprise 5.7.0.0

[Former Member]

Hi,

currently i'm working on a dashboard automation project where my exported dashboard should always pick up the XML from the folder it is currently located. Already set up everything but i have no clue how to dynamically set up the XML connection path. Therefor i would appreciate any ideas or direct solutions.

Thanks,

Jan

[former_member194862]

Check if this is helpful

[Former Member]

Hey Amit,

thank you for your answer. Did check the tutorial and it doesn't help me. Already set up a basic XML connection and i know how to deal with it. Maybe i wasn't precise enough:

I would like to use the same Dashboard generated as SWF over and over again. The location/path will change a lot but it always will read from the XML file which is always the same name and stored with the SWF in the same folder. The problem is that the path will be always different, so that XML file should be read dynamically from the folder the SWF file is stored inside of. Basically the XML path should be relative.

Thanks once again for any ideas and/or solutions

[former_member194862]

Hi Jan,

You can map the XML data url to the spreadsheet cell to A1.

Now create a web-service whose sole purpose would be to bring back the XML url and the url would be populated in the same cell A1.

So everytime you view the dashboard 1st the web service would bring back the XML data url then the XML connection would get triggered when value changes i.e the url changes.

Let me know if this works,

Regards,

Amit

[Former Member]

Hi Amit,

sorry on the late reply. Just marked it as helpful answer, have to get more into the topic of web-services but the idea seems to make sense. Once i've figured out i'll update the topic.

Thanks,

Jan