cancel
Showing results for 
Search instead for 
Did you mean: 

Using Excel as a Webi source - AFO 2.2.4

Former Member
0 Kudos

Hi - SAP support is telling me that I can't use Analysis for Office 2.2.4 to save an Excel workbook to the BI Launch Pad.  I need to be able to get an Excel workbook to the BI Launch Pad so that I can run a Webi over it, and use it to send Publications via email.

Anyone have any idea how I can get and Excel workbook to the BILP ( I am on 4.1.3.3 of BI Launch Pad)?

Kind regards,

Kelly

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Kelly,

Could you save Analysis Office as an Excel file, upload the Excel file to BI Platform, and then Web Intelligence could use it as a data source?

This is what I have done to use Lumira - saved Analysis Office to an Excel file, and then use Lumira to use that Excel file as a data source.

Tammy

Former Member
0 Kudos

Hi Tammy - how is this done in AFO 2.2.4.  It has to be an Excel (icon) workbook, not an Analysis (icon) workbook for Webi to see it as a source...

Kind regards,

Kelly

TammyPowlas
Active Contributor
0 Kudos

I save the Analysis file locally - File > Save As

Then I upload to BI launchpad.

Former Member
0 Kudos

Does it save as an Excel file on BILP or Analysis Workbook?  "Upload" as in "Save to the BI Platform"

TammyPowlas
Active Contributor
0 Kudos

Kelly:

Save the Analysis Office file to a network drive, or local drive

Then launch the BI launchpad

Upload this Excel file

Then launch Web Intelligence

Use Excel as a data source

Former Member
0 Kudos

Thanks Tammy!  Had forgotten about this way.

Answers (0)