WebIntelligence Download to Excel

building reports webintelligence legacy 1/2
1

Business Objects Users:

Question: How can a WebIntelligence report be downloaded to excel, to view only the report created and not the entire data cube?

Initial Universe: The universe was designed so the measuring objects (sum, count) utilized only the sum function to project the aggregation, in the properties. As a result the report calculated correctly in WebIntelligence, but when a user downloaded a simple 6 x 5 report/table to excel the entire cube of data was downloaded per the lines summed in the WebI report/table.

Fix to Universe: The measuring objects were reviewed. In addition to the sum function in the properities of the object, the sum function was included in the select definition. [ ie: sum(dbo.tblconMain.Revenue) ] As a result, the report calculated correctly in WebIntelligence and when it was downloaded to excel only the 6 x 5 report appeared.

Additional questions:
Is it necessary to assign a sum in the select definition of measuring object? Is there any limitations or problems for utilizing the sum in the select definition?
Which is the optimal solution to utilize for measuring objects: properties only, both properties & select definition, or other?

Regards,
Melinda

Melinda Perez
Schlumberger Oilfield Services
OpStats/ Web Intelligence Team - BMS
mperez@slb.com (e-mail)
(281) 285-7233 (voice)
(281) 285-7200 (fax)

Listserv Archives (BOB member since 2002-06-25)

2

At 06:36 PM 1/19/2000 -0600, Melinda Perez wrote:

Question: How can a WebIntelligence report be downloaded to excel, to view only the report created and not the entire data cube?

Melinda, have the user click the report frame to make it the “active” frame in the browser.

Then, from the browser’s File command, do a “Save As”, and save it as an HTML document. (Depending on your browser and platform, there are various ways to do this. Our WebI users use Netscape on a Macintosh platform, so in the Save As dialog box, they have to pick to save as “Source” type, which means as an HTML document. In Netscape on a PC, you can choose from the dropdown box to pick HTML.)

Then, in Excel, on File Open, select from Files of Type HTML, and open the saved HTML document. (You need at least Excel '97 on a PC, or Excel '98 on a mac to do this.)

Hope this helps,
Anita Craig
Stanford University

Listserv Archives (BOB member since 2002-06-25)

3

Melinda,

be aware to have sufficient rows available per page because you will only save the data on one page (if you have more than one page of results).

Kind regards,

Maarten

Listserv Archives (BOB member since 2002-06-25)