Excel add in for sap

Symptom When launching Excel, the loading of EPM Add-in process takes more than 3 minutes without any errorsSlow performance is observed for basic tasks in BPC EPM Add-In in Excel, such as opening/saving BPC EPM Add-in reports or opening a (non BPC) MS Office document in the Excel Client. This occurs only some specific users Read more... Environment SAP Business Planning and Consolidation for the Microsoft platform version 7.5.x onwards including Support Packages (EPM BPC-MS)SAP Business Planning and Consolidation for the Microsoft platform version 10.x onwards including Support Packages (EPM BPC-MS)EPM Excel Add-in version 10 onwards including Support Packages (EPM Add-In)Product SAP Business Planning and Consolidation, version for the Microsoft platform all versions Keywords performance Excel Client, EPM Add-in, verisign.com website, SSL certificates, revocation, slow, timeout , KBA , EPM-BPC-MS , Microsoft Version , Problem About this page This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Loginrequired). Search for additional results Visit SAP Support Portal's SAP Notes and KBA Search.

&prodname - Build &prod.vermaj.&prod.vermin.∏:verint; -->OverviewThe CData Excel Add-In for SAP ERP provides the easiest way to connect to SAP ERP data from Excel. From the CData ribbon, you can select Get Data and choose From SAP ERP to import tables and columns into the spreadsheet. The spreadsheet will then be linked with the remote data. Key FeaturesSelect tables and columns using the CData ribbon.Schedule automatic data refresh in the data selection dialog.Getting StartedSee Establishing a Connection to connect your workbook to SAP ERP. To easily share the workbook, store the connection in the workbook. Refresh the spreadsheet automatically or from the ribbon.Using the Excel Add-InSee Using the Excel Add-In to use the CData ribbon to execute operations supported by the add-in:Querying Data: You can use the Data Selection wizard (click Edit Query from the ribbon) to select tables, columns, and filters, building a query to SAP ERP. You can also write your own SQL to query SAP ERP just as you would query a traditional database; by Writing Parameterized Queries, you can create dynamic spreadsheets that take cell values as the query inputs. Click Refresh Worksheet in the ribbon to pull the latest changes.See CData Excel Functions and Using the Excel Add-In (VBA) to programmatically access any of the functionality available on the ribbon.Advanced FeaturesAdvanced Features details additional features supported by the add-in, such as defining user defined views, ssl configuration, remoting, caching, firewall/proxy settings, and advanced logging.SQL Compliance See SQL Compliance for a syntax reference and code examples outlining the supported SQL.Data ModelSee Provider Schema to find more information on how the add-in models the SAP ERP APIs as tables, views, and stored procedures, as in a relational database.Connection PropertiesThe Connection properties describe the various options that can be used to establish a connection. &;nbsp; -->

IntroductionAs we define the future of SAP Analytics Cloud, we are committed to our existing SAP BusinessObjects BI suite customers. We continue to add enterprise reporting features like formatted reports, sections,and more recently in 2022, we added the report bursting capability.This allows most BI use cases, including reporting, to be transitioned to SAP Analytics Cloud. However, with the mainstream maintenance of version 4.3 of SAP BusinessObjects BI suite ending in 2025, we do not want to leave SAP BusinessObjects customers behind, and therefore we have decided to release an updated version of the BI suite code named SAP BusinessObjects BI 2024 to provide more time to our on-premises customers to adopt SAP Analytics Cloud.To maximize the value for our customers, we will focus ongoing investments on the most-widely adopted SAP BusinessObjects BI solutions:• SAP BusinessObjects Web Intelligence,• SAP BusinessObjects Information Design Tool and single source .unx universes,• SAP Crystal Reports (on Windows only*),• SAP Analysis for Microsoft Office,• SAP BusinessObjects BI platformThis means we plan to remove the following components from SAP BusinessObjects BI 2024:• SAP Lumira,• SAP Crystal Reports for Enterprise,• SAP BusinessObjects Universe Design Tool and .unv universes,• Multi-source universes and associated connectivity,• SAP BusinessObjects Analysis, edition for OLAP,• SAP BusinessObjects Live Office. These previous chapters are an extract of the latest SAP Business Intelligence Statement of Direction, published in June 2022.As described in the statement, our BusinessObjects BI customers will benefit from an extended maintenance for their favorite and most used solutions.This also means some of the BI suite components will no longer be maintained after 2027, as SAP BusinessObjects BI 4.3 is planned to be supported until end of 2027.SAP BusinessObjects Live Office (Live Office) is part of those modules that will need to be replaced by another SAP BI tool.In this post you will learn how to prepare a smooth transition from your Live Office solution to our SAP brand new solutions.As you know Live Office is an add-on for Microsoft Office applications that gives you access to up-to-date information stored in the SAP BusinessObjects Business Intelligence platform.With Live Office, you can insert content from Web Intelligence, SAP Crystal Reports, and universe queries in your Microsoft Office documents (PowerPoint, Word, Excel, or Outlook). When you insert an object, a reference to the BI platform location is also inserted. When you open the document later using the Microsoft Office application, you can refresh the objects and see the current data in your document.In this post we will focus on alternative solutions for the specific configuration Microsoft Office Excel with Web Intelligence / Crystal Reports 2020.We will present three possible new ways to bring your BOBJ data into Excel, which will enable your Live Office users to keep working with their well-known environment: Using Excel and Web Intelligence (OData access) Using Excel and Crystal Reports 2020 (OData access) Using another SAP’s Microsoft Excel add-in SAP Analytics Cloud, add-in for Microsoft Office Or SAP Analysis for Microsoft OfficeDepending on your current and planned tools landscape, you will decide

Crystal Reports 2020 OData Service URL looks like below: /rpt/recurringSchedules//data.svc/v4" target="test_blank" rel="nofollow noopener noreferrer"> Now In Excel, go to “Data/Get Data” item and select OData Feed, paste the OData URL. Check Crystal Reports 2020 OData Service on recurring schedules | SAP Help Portal, for more information, including tips.Configuring BOETo be able to logon from Excel using BOE credentials and basic auth, you need to check following properties are correctly set on your BOE platform.To use the copied OData link in Excel without a manual modification of the port number, you need to enable the basic. auth. in the application server used by the RESTful Web ServiceThe OData service can be consumed throw the WACS or Tomcat application server. If you your RESTful Web Service uses the Tomcat server:Set property Basic_Auth_Supported=trueIn file: Program Files (x86)\SAP BusinessObjects\tomcat\webapps\biprws\WEB-INF\config\default\biprws.properties If you your RESTful Web Service uses the WebApplicationContainerServer (WACS): Connect to the CMC Go to : servers -> core services -> WebApplicationContainerServer Check the option “Enable http Basic Auhentication Scheme for HTTP Basic”Use SAP Analytics Cloud, add-in for Microsoft Office (SAC Add-in)SAP Analytics Cloud, add-in for Microsoft Office enables you to use Microsoft Excel’s strengths to get deeper insights into your SAP Analytics Cloud data.SAP Analytics Cloud can bring together a wide range of data from spreadsheets, on-premise databases, and the cloud. With SAC, add-in for Microsoft Office, you can bring this data into Microsoft Excel and take your analysis a step further.Integrated with Microsoft 365, the add-in lets you format, analyze, and enrich your data based on latest content from the SAP Analytics Cloud platform.You can analyze SAP Analytics Cloud Analytic and Planning models based on Import Data connections. For planning, you can add data for planning and save it back to the cloud. You can also work with SAP Data Warehouse Cloud (DWC) datasets as data sources.This means there are two ways to bring BOBJ data in this add-in: By creating an acquired model in SAC on top of a Universe and then accessing this model from SAC, add-in. By creating a specific view in Data Warehouse Cloud based on the SQL expression of a BOBJ query, and accessing this DWC model from SAC, add-in.Use SAP Analysis for Microsoft Office (AO)If you are already using AO, you may access BOBJ data from this client using the same models as the ones described for SAC, add-in for MS Office.Other Office ToolsIf you are using Live Office in another MS Office client tool such as Word or PowerPoint you can first insert in Excel your BOBJ data using one of the previous exposed methods.Then you can link data from a saved Excel worksheet to your Office document. That way, if data in the worksheet changes, you can easily update it in your MS Office file.We want to hear from youThe SAP BusinessObjects BI suite remains a key component of our Analytics strategy and we arecommitted to our customers. Please help us fine tune our roadmaps by providing your input through the dedicated influence channels: