on 01-24-2011 6:09 AM
Once I save a business objects XI R2 web intelligence report to excel format and schedule to users the excel which the users receive should have pivot tables and users should be able to add any fields of their choice in the report and view it similar to the excel pivot tables.As far as I know I will be able to achive this functionality using Live Office.Is there any other way how I can achieve this and also has anyone worked on this kind of requirement and can confirm this will work without any issues with live office?
i think its something easy
you need to have Live office installed on your machine or any other client machine to be able to import and refresh the web intelligence report.
once you imported the webi report into your excel using the live office
choose the region and click insert->pivot table.
if you dont know how to use live office, find out this link
[http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_lo_user_en.pdf]
good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot for your suggestion.I would like to know that once I embed the web intelligence content into the live office and add only selective fields into the excel and once the data gets refreshed will the user have the flexibility to add and remove the fields in the report without any issues?
Can you please suggest me which is the best way of achieving this?
The requirement is to schedule the webi report as excel and format it to Pivot table report format so that user receives the report on a particular day in a month and can analyse the fields he is interested in by using the pivot table field list.Is this possible at all?
It will be really great if you explain me the approach.
It is not possible to schedule the WebI reports in Excel format and use a predefined excel template for this.
What your users CAN do is to add their own pivot tables from the scratch in the excel file that was generated and delivered to them according to the schedule.
What you can do is use LiveOffice (have to install the plug-in on all user workstations though), bind the instances and deliver your users an excel file, which uses liveoffice to bind the scheduled webI report instances (eg. the latest instance). Your users can add the desired pivot table functionality on their own or you can predefine this in the excel file yourself.
Which version of BO do you use?
Regards,
Stratos
Stratos,
It is XI R2 version.
I thought Once the Webi report is embedded into the excel using live office I can format into Pivot table report and send it to the user.
But once the report gets automatically refreshed on a particular day every month the format is gone right?
Then the users only have to convert into pivot table format right?
Then in this case why is live office required at all?
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.