Saving Scenarios with Xcelsius

There are several reasons why end users desire the ability to save information from their dashboard for future use. Hopefully with this article, I can sort out what you have available to you in order to solve some of these scenarios below.

  1. Save a personal scenario- A dashboard that contains some level of runtime scenario analysis (what-if) users want to save personalized scenarios based on their inputs to share or recall them at a later time.
  2. Save a shared scenario- A dashboard that contains some level of runtime scenario analysis (what-if) users want to save scenarios for all other dashboard end users to see.
  3. Offline usage- A dashboard that resides on the desktop that connects to live data, where the end user wants to take the SWF offline and still have access to the data.
  4. Write-back- A dashboard contains multiple inputs and functions as a form to write back to a database. This write back data is then used as a data source for the dashboard.

The path of least resistance to saving scenarios is achieved through the local scenario button. This Xcelsius component works similar to a cookie in your browser. The local scenario button takes a snapshot of the dashboard’s current state. This snapshot includes both the data and selections and is associated to the SWF if it is on your desktop or hosted on a server. If you access the same SWF in another browser session or after you re-start your computer, the scenarios will remain. This functionality also works using other deployment methods including Power Point and PDF.

Download Source Files

I use a browser cookie to explain this functionality because the local scenario button does have similar limitations:

  • Local Scenarios will only work for the local PC end user. Other people who access the SWF on your server will not have access to your scenarios.
  • If you re-publish your SWF and overwrite the existing file, your scenarios are cleared. There is no way to transfer the scenarios to your new SWF.
  • You cannot re-use the saved scenarios for other applications to access.

In our initial 4 scenarios we have solved #1 and #3. The only thing to remember with saving scenarios for connected dashboards, is the scenario will only grab the data present within the dashboard at that moment. If you are using parameterized queries to retrieve data, you may need to save multiple snapshots to tell your story in an “offline mode.”

For #2 and #4 you have two potential options.
Business Objects customers can potentially use Take action as a Web Service, which is an application that generates web services for writing back to a data base. I have not used this in any projects yet but it looks pretty nice.

Non-BOBJ customers or those who don’t have time or resources to create a database can use Xport Wizard to generate XML files on a server from Xcelsius, then load them back into the dashboard using the XML data connector. I have been using this utility for a while and love it because of its simplicity. Some of the XML data button binding gets a little tricky depending how complicated your dashboard saving is, but I have had tremendous luck so far.

Hopefully this clarifies what options you have available to you.

Did you like this? Share it:

Comments

Comments

  1. Daniel Davis says:

    Ryan,

    can you tell me – what location the SAVED files live in? Are they XML, Temp internet files? I’ve always tried to find the saved files with no sucess.

    Regards

    Daniel

  2. Ryan Goodman says:

    There certainly is a method for writing to an XML file or CSV, which could then be loaded into a data base, or loaded into another Xcelsius dashboard. I would check out Xport Wizard at centigonsolutions.com

  3. David says:

    Thanks for your contributions to the XCelsius community.

    One question where does the SWF application “write” the local scenario information to on the user’s machine.

  4. Tony Turner says:

    I am new to Xcelsius, but found some useful information in your article.

    I would like to have you elaborate on a couple of points.

    I need to be able to capture comments when viewing my dashboard.

    It would be awesome to be able to write back to a database. I am not using Business Objects Enterprise, but I am using Crystal Reports 2008 as well as Xcelsius.

    I know Business Objects Enterprise very well if I need to use it.

    1) How do I create a dashboard and have the ability to add text comments?

    2) How would I write that back to a database? I could even write it back to a spreadsheet or XML file.

    3) I would like to automate this so I could give it to someone, let them review dashboard, make their comments
    and hit some button that will save their comments to a database.
    (Ultimate goal, but not sure if do-able).

  5. Cory says:

    Thanks for the article.

    You can certainly ‘rig’ Xcelsius to communicate back with the server. Just pass in any relevant data though a web service entry point. You can even use a nice button to kick it off.

  6. Hiroyasu Minami says:

    Thank you for very informative topic.

    Is it possible to solve scenario 2 with crystal report and publicaion function in BOE?

    My Cus ask me the feasibility of that solution.

    My understanding is that this approach can’t solve scenario 4 but sort out scenario 2.

  7. Very good informative post ! Thank You ! Online Film

  8. Nice site, great content , I will be back for more, Interesting to see the raw ‘possibility’ that the Internet opens up to self employment in the ‘service’ and ‘pay-per-view’ industry ;-) Pity that the ‘industrious’ in this country would have to purchase a commercial/business service in the Australian ISP context to compete with the upload bandwidth of their North American ‘bretheren’ so as to equally ‘exhibit’ their “Downunder Goodness”!!

  9. Intimately, the post is actually the best topic on this related issue. I harmonize with your conclusions and will eagerly look forward to your coming updates.

  10. glaluahliassy says:

    Visit us now to
    grasp more information and facts
    anyway Come to see us at times to grasp more information and facts regarding Kurs pedicure

  11. nice story!

  12. Even though I think that I have read this news previously, it is good to read here the second time.

  13. Nice site, great content , I will be back for more, Interesting to see the raw ‘possibility’ that the Internet opens up to self employment in the ‘service’ and ‘pay-per-view’ industry ;-) Pity that the ‘industrious’ in this country would have to purchase a commercial/business service in the Australian ISP context to compete with the upload bandwidth of their North American ‘bretheren’ so as to equally ‘exhibit’ their “Downunder Goodness”!!

  14. wedding says:

    I must admit this post is very wonderful . Thanks once again for the push!

  15. I think you know how to write a really nice post. Thanks!

  16. jocuri 3d says:

    Thank you for another magnificent article. The place else could anyone get that kind of information in such a perfect approach of writing? I’ve a presentation next week, and I am on the search for such information.

  17. This is a really well thought out post. I certainly enjoyed reading it. Thanks!

  18. Thank you for a wonderful post. I enjoyed it.

  19. I think you know how to write a really nice post. Thanks!

  20. haber says:

    I’ve started a climate change project called proxEarth.org. Many people have blogs, websites, and use social software sites (social networking, social bookmarking, photo and video sharing, etc.). Some standards for tags and text on blogs, websites, and social software sites could turn the whole global Internet into a kind of Web 2.0 participation platform for climate change. I’m suggesting a few simple standards for tags and text that leverage processes of the sustainable ProxThink growth model. To get this going, we need people to adopt and use these standards. The project could also use contributors, collaborators, partners, funders and sponsors. To find out more, see:

  21. I know not sure the place you are getting your information, however good topic. I must spend some time studying more or working out more.Best regards from Holland.

  22. Zune and iPod: Most people compare the Zune to the Touch, but after seeing how slim and surprisingly small and light it is, I consider it to be a rather unique hybrid that combines qualities of both the Touch and the Nano. It’s very colorful and lovely OLED screen is slightly smaller than the touch screen, but the player itself feels quite a bit smaller and lighter. It weighs about 2/3 as much, and is noticeably smaller in width and height, while being just a hair thicker.

  23. I ACTUALLY appeared to be extremely pleased to find this web-site.I want to thanks for your effort for this wonderful read!! I ACTUALLY certainly enjoying any little bit of it and I had you saved as a favorite to see new stuff you blog post.

  24. Very good informative post ! Thank You ! Online Film

  25. Beauty says:

    Informative post, thank you ! Beauty Well

  26. Some great article, it helped me very much!

  27. This really is like my third time coming by your web page. Regularly I do not make comments on, but I’ve to mention that this post truly pushed me to do so. Definitely awesome post!

  28. We Acquire Any Houses For Loan Balance!

  29. This is a great site, might you be interested in doing an interview regarding just how you designed it? If so e-mail me!

  30. good blog. helpful info .Now i ask you to visit our web about vacation rentaland clik here apartamente regim hotelier . Thank you .

  31. vpn download says:

    I like Your Article about Saving Scenarios with Xcelsius Perfect just what I was searching for! .

  32. pletcheryil says:

    As a French fashion house founded in 1854, LV has improved greatly and acquired countless lovers across the world. Recent years, there established many online Louis Vuitton Sale, aiming at making people¡¯s shopping more convenient. You don¡¯t need to go out of your house and wander about to find the LV Bags you like. Additionally, special discounts of the goods such as Louis Vuitton Purses are offered everyday. Hurry up!
    ……………………………………………………………………..
    coach factory outlet

  33. I just added your website to my blog roll, I hope you’ll consider doing the same.

  34. I appreciate the commentary on this site, it really gives it that community experience!

  35. 654779 says:

    654779 beers on the wall.

  36. I like Your Article about Saving Scenarios with Xcelsius Perfect just what I was looking for! .

  37. android apps says:

    I agree with your Saving Scenarios with Xcelsius, wonderful post.

  38. I completely agree along with your details. The actions of listing inside your submit are very helpful for obtaining this problems resolved.

  39. Hi, this is a very informative blog. Although i don’t get everything of what your saying, i still loved reading it. Perhaps you will write something more on this subject in the future? Weekendophold is nice also

  40. I agree with your Saving Scenarios with Xcelsius, excellent post.

  41. vnc download says:

    Saving Scenarios with Xcelsius Magnificent goods from you, man. I’ve understand your stuff previous to and you’re just too excellent. I really like what you’ve acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it sensible. I can not wait to read far more Saving Scenarios with Xcelsius again from you. Thanks For Share .

  42. Is it possible to install multiple joomla site on one wamp server?

  43. Pacman Games says:

    Thank you, I’ve been seeking for information about this subject for ages and yours is the best I’ve located so far.

  44. chris brown says:

    You’ll look professional & stylish in our made to measure shirt for business, formal & casual wear. A perfect fit, guaranteed. Order online with confidence

Trackbacks

  1. Xcelsius 2008 Map Drill Down w/ Scenario Button
    The Xcelsius chart components seem to be problematic to many users, so we decided to start with demoing how to use the Xcelsius 2008 US Map Drill Down functionality with the Xcelsius tab component, column chart and scenario button. Below is a short d…

  2. Crystal Xcelsius User…

    [...] sy to produce, and have focused much of my attention on Xcelsius and now Roambi. [...]…

  3. Fashion Style Blog…

    [...]below you’ll find the link to some sites that we think you should visit[...]…

  4. Read was interesting, stay in touch……

    [...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……

  5. Photos says:

    Recent Movie Releases…

    [...]below you’ll find the link to some sites that we think you should visit[...]…

  6. homemadesolarpanels…

    Thank you very appreciably for the challenging operate to give this type of very excellent facts. I will forward your web page to my pals to discover from this beneficial article….

  7. You should check this out…

    [...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……

  8. Superb website…

    [...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……

  9. Check this out…

    [...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……

  10. Related……

    [...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……

  11. click here says:

    Improve your vision naturally!…

    Thanks. Left you a trackback to help your readers improve eye vision naturally….

  12. Mercosur USA says:

    You should check this out…

    [...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……

  13. A small question…

    Hi there, I need to ask you some thing. Is this a wordpress webpage? We’re thinking about changing our blog page from Blogger to wordpress, you think this is practical? Also did you construct this specific template yourself some how? Many thanks for t…

  14. A small question…

    Heya, Needed to ask you something. Is this a wordpress web log? I’m thinking about transferring our blog site from Blogger to wordpress, do you think that is doable? In addition did you build this theme by yourself some how? Cheers for the help!…

  15. You should check this out…

    [...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……

  16. Wonderful…..

    I emailed this to three of my friends. You are truly an authority on this topic……

  17. Superb…

    Just found this really good post. Hoped if i had found this a long time ago. BTW, i love this website design….

  18. {Great|Awesome|Good|Amazing|Insightful|Nice|Very Good|Informative}{ & to the point | and to the point | & direct | and direct | & Relevant | and Relevant }{Blog|Blog Post|Post|Article}…

    I stumpled upon this really good article a few minutes ago….

Speak Your Mind

*

* Copy this password:

* Type or paste password here:

83,788 Spam Comments Blocked so far by Spam Free Wordpress

Switch to our mobile site