I am new to this forum and for Xcelsius …I need help with refreshing the exported report from Xcelsius .(m using SAP Business Objects Dashboard 4.1 Support Pack1) Version 14.1.1.1036
There is a scenario assigned to me :
Prepare an Xcelsius report which should take the data from a .csv file and should get updated every time any changes made to .csv file … Done
Export a report (HTML) from xcelsius and place it in a shared location…Done
The exported report should also get refreshed whenever there is any change in the source file i.e .csv file or Xcelsius file…Stuck here
Issue : Unable to refresh the exported report every time there is any change in the source file.
Is there a possibility of doing this ,if yes… please guide me with this…
Need urgent help with this…
Firstly - urgent isn’t a word we use here, as we are all volunteers…
What have you done to get your data into Xcelsius from a CSV file? Is your data dynamic? If your actual Xcelsius XLF data changes when your CSV data changes, then I’m not sure why your HTML file isn’t showing the change.
Have you set your data connector to refresh on load? And mapped your component to the correct range?
I have imported .csv file into the Xcelsius via “From Text” option in “DATA” tab …
Now the data inside the xcelsius is reflecting the udpates when ever the .csv file is getting updated …
And when I export the html file from it …it show the result perfectly …
So does this mean I have to export the html file every time the data gets updated in the xcelsius or is there any way I can export the html file only once and place it somewhere and it get updated dynamically …bcos the input file which is .csv file will be updated very frequently and I do not want to export the reports every time …
It sounds to me like your data isn’t dynamic. You are manually importing it which means that you will have to export each time.
You need to create a data connection and map its output to a range of cells. I haven’t played with CSV files for a long, long time but you could try generating an XML map and then setting up an XML data connector. Or you could get your data via liveoffice, or directly via XML. But all you “store” in the xcelsius file is a way of getting the data in - not the actual hard data itself. So every time your HTML opens, it fires the connection which goes and gets the data…
It’s a great little plugin that can pull in and do a fair bit with CSV content. I just checked however and I cant see a way to check the CSV for changes. I think the best you could do is poll it regularly for changes using the ‘refresh every X seconds’ function.
(BOB member since 2003-11-27)
(BOB member since 2005-03-01)
(BOB member since 2013-03-20)