The process is very similar to the Web Intelligence Rich Client (Desktop:ĥ. Important: Changing the columns or other elements of the spreadsheet could/will break the Web Intelligence document.Īlternatively you should use the SDK which is fully supported.Ĭreating a Web Intelligence document using an Excel spreadsheet as data source This would translate to something like: E:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Input\a_140\088\000\22668 In the BI Launch pad, right-click the Excel spreadsheetģ. For this you’ll need to locate the location of the spreadsheet in the Input File Store and overwrite the file.ġ.
This will not affect the link with the Web Intelligence document as it uses the CUID stored in the repository.Įxtra Note: If you wanted a process to automatically refresh a spreadsheet in the BI Launch pad, this would require some level of unsupported “hacking”. Note: Previous copies of the spreadsheet are kept in the File Store location on the server and the file name is different. Confirm if you want to replace the file or not New in SAP BI 4.1 is the ability to (finally) manually update your spreadsheets directly in the BI Launch pad.ĥ. Maintaining your Microsoft Excel Spreadsheet Open the menu “New” and select Local Document Navigate to the folder where you want to save the Excel spreadsheetģ. Uploading a new Microsoft Excel SpreadsheetĢ. Note: This is still not possible with the HTML client. Thanks to SAP BusinessObjects Business Intelligence Suite 4.1 SP02, this is now also possible with the Web Intelligence Applet (aka Rich Internet Application aka Rich Internet Application aka Java Report Panel). I’d like to welcome WILLIAM MARCY as a collaborator to this article! Web Intelligence documents using a Microsoft Excel personal data provider is a feature no longer only possible in the Rich Client (Desktop).
0 kommentar(er)
