Connect Microsoft Excel to SAP Using ODATA Service Created for Fiori App

792 results

  1. Use and Explore a Microsoft Excel Spreadsheet File Directly in SAP BusinessObjects Explorer 4.1

    Reading time: 17 mins

    Learn how to use a feature of SAP BusinessObjects Explorer 4.1 by following step-by-step instructions for uploading a Microsoft Excel spreadsheet file into SAP BusinessObjects Explorer and then exploring the data included in the file. Discover how to make data residing within an Excel file available so that it can be explored with the creation…...…
  2. Report Design from Start to Finish with the SAP APO Demand Planning Add-In for Microsoft Excel

    Reading time: 11 mins

    Learn how to create reports in the new SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel from scratch. Follow a use case to help you understand the prerequisites for using this functionality. Key Concept The SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel provides a…...…
  3. Report Design with the SAP APO Demand Planning Add-In for Microsoft Excel (Part II)

    Reading time: 20 mins

    Learn how to format a report created using the SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel using the SAP Enterprise Performance Management (SAP EPM) formatting functionality. Key Concept The SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel is partially based on SAP Enterprise Performance…...…
  4. SAP BusinessObjects Planning and Consolidation for SAP NetWeaver or Microsoft: How They Differ

    Reading time: 21 mins

    Compare the SAP BusinessObjects Planning and Consolidation, version for Microsoft and the SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver environments, and examine the strategies associated with this technology. Review the concept of the platform as the main issue behind a company’s reason for implementing one of these versions because of data integration issues,…...…
  5. The Office Document Toolbox for Creating RTF Documents and Spreadsheet Files Using ABAP: Part 2 — Reading and Writing Excel Documents

    Reading time: 88 mins

    As an alternative to using the COM interface (which can be cumbersome) for creating Microsoft Word and Excel files in ABAP, you can use the Office Document Toolbox, an open-source solution, to create word processing documents in Rich Text Format (RTF) and spreadsheets in Excel XLS format. Learn how to read and write Excel files…...…
  6. Connect Microsoft Excel to SAP Using ODATA Service Created for Fiori App

    Reading time: 1 mins

    Excel is an easy-to-use reporting tool often used by companies to present their key performance indicators. This blog will help you reduce number of clicks per report by at least 20 by demonstrating step-by-step how to connect Microsoft Excel to SAP using operational data service created for SAP Fiori. This content is available to Premium…
  7. 10 Ways Microsoft Excel® Can Speed Up Your SAP® Processes & Improve Data Quality

    Reading time: 1 min

    While many companies currently use Microsoft Excel in their data processes, it is often done in a time-consuming and manual manner. Companies are continuously looking for ways to get work done faster, improve data quality and make an impact within their organization. In this eBook, learn how companies have leveraged a tool they’re already using…...…
  8. Link SAP Payslips to Your Excel Payroll Reports

    Reading time: 11 mins

    When you are viewing SAP payroll reports, they often make more sense when viewed side-by-side with employees’ payslips. This adds context and makes payroll reports much easier to understand. Learn a simple way to link payroll reports to employee payslips with short macros in Excel using Visual Basic for Applications (VBA). No ABAP code is…...…
  9. Experience the Next Level of Forecasting the Future Using Xcelsius Dashboard Applications

    Reading time: 20 mins

    Xcelsius dashboard applications present facts graphically, providing insight that helps in making business decisions. However, the future is uncertain and decisions should take that into account. Learn how Xcelsius can transform business facts into statistically valid probability models that give a more accurate view of the future using Monte Carlo simulation techniques. Sample code is…...…
  10. SAP NetWeaver BW and Xcelsius: Excel 2007 PivotTables Provide Enhanced Interactive Reporting and Analytics Options

    Reading time: 10 mins

    See how you can use Microsoft Excel 2007 PivotTables with SAP NetWeaver BW and Xcelsius to create a low-cost but highly functional reporting and analytics system. Learn how Xcelsius uses Excel 2007 as its data binding source for dynamic dashboards and data visualizations. Key Concept Microsoft completely redesigned Excel 2007 to be the company’s primary…...…