How to get new and updated data into LO Excel in Xcelsius

35 Views

Dear Experts,

I have created dashboard on top of webi report by using Live-Office connection. Latest data of webi report is imported into excel and mapped data with components and generated SWF file and exported into server.

To day my webi report has latest instance with new and updated data. But until unless by clicking "Refresh All Objects" i am not getting updated data into excel.

When i am trying to open dashboard in BI Launch Pad/CMC it is showing data whatever exist in excel(i.e yesterday data). But here we need to show data of latest instance of webi report.(i.e New and updated data as of now).

I have selected option "Latest instance: From latest instance scheduled by" in "refresh options".

My Question & Doubts:

1) Is it mandatory to open dashboard every day and need to click on "Refresh All Objects" to get updated data into excel or dashboard.

2) Is there any option to automate this process.

Regards,

PRK.