cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot tables in excel with Live Office

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

amrsalem1983
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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?

0 Kudos

If oyu are talking about the cells occupied by LO data then the answer is no. Your users can only remove the entire LO object but they cannot remove part of it.

Regards,

Stratos

Former Member
0 Kudos

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.

0 Kudos

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

Former Member
0 Kudos

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?

0 Kudos

I would recommend not to build the pivot table direct on the LiveOffice data cells. Link the data into another area (even another sheet) and create the pivot table there.

Regards,

Stratos

Former Member
0 Kudos

Thanks a lot Stratos for your help.

Let me implement and then I'll get back to you with more details on this.