How to learn SAP business objects

how to configure sap business objects mobile and how to create sap business objects report and how to download sap business objects software
Prof.SteveBarros Profile Pic
Prof.SteveBarros,United Kingdom,Teacher
Published Date:28-07-2017
Your Website URL(Optional)
Comment
SAP BusinessObjects Analysis, edition for OLAP Administrator Guide ■SAPBusinessObjects4.1SupportPackage1 2013-09-16Copyright © 2013 SAP AG or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epxtrademark for additional trademark information and notices. 2013-09-16Contents Chapter 1 Document History...................................................................................................................7 Chapter 2 Introduction to SAP BusinessObjects Analysis, edition for OLAP.........................................9 2.1 Components of Analysis, edition for OLAP..............................................................................9 2.1.1 Analysis client..........................................................................................................................9 2.1.2 Analysis Multi-Dimensional Analysis Service..........................................................................10 2.2 About this guide.....................................................................................................................10 2.2.1 The documentation set...........................................................................................................10 2.2.2 Who should read this guide....................................................................................................11 Chapter 3 Architecture...........................................................................................................................13 3.1 Analysis architecture diagram.................................................................................................13 3.2 SAP BusinessObjects Business Intelligence platform deployment model...............................14 3.3 Multi-Dimensional Analysis Service........................................................................................15 3.3.1 Server failover........................................................................................................................15 Chapter 4 Installation and Configuration...............................................................................................17 4.1 Administrative tools................................................................................................................17 4.1.1 Central Management Console (CMC)....................................................................................17 4.1.2 Central Configuration Manager (CCM)...................................................................................17 4.2 Installation notes....................................................................................................................17 4.3 Data sources.........................................................................................................................18 4.4 Web application server configuration......................................................................................18 4.5 Post-installation configuration of fonts....................................................................................19 4.6 To configure the BI platform for Essbase OLAP connections..................................................21 4.7 Firewall port usage.................................................................................................................22 4.8 Cloning Analysis server deployments.....................................................................................22 4.9 Export limit.............................................................................................................................23 4.10 Session timeout settings........................................................................................................23 4.11 Accessibility...........................................................................................................................24 4.12 SAP Notes required...............................................................................................................24 4.13 Oracle OLAP Data Provider for SAP BusinessObjects Intelligence........................................25 3 2013-09-16Contents 4.13.1 Software requirements for the Oracle OLAP Data Provider....................................................25 4.13.2 Oracle OLAP Data Provider installation package....................................................................27 4.13.3 Configuring the Oracle OLAP Data Provider...........................................................................29 4.13.4 Configuring JVM memory usage............................................................................................33 4.13.5 Running the web server and XMLA service............................................................................34 4.13.6 Testing your installation..........................................................................................................37 4.13.7 Using JConsole to monitor the Oracle OLAP Data Provider...................................................37 4.13.8 To enable the Oracle OLAP Data Provider for Analysis..........................................................40 4.13.9 Uninstalling the Oracle OLAP Data Provider...........................................................................41 4.13.10 Using logging to troubleshoot MDX and SQL issues..............................................................42 Chapter 5 Security.................................................................................................................................45 5.1 Configuring the MDAS for Secure Sockets Layer (SSL)........................................................45 Chapter 6 Rights Management..............................................................................................................47 6.1 Overview of rights and access levels.....................................................................................47 6.2 Create Analysis Workspace right...........................................................................................47 6.3 Rights for Analysis objects.....................................................................................................48 6.4 Access levels for Analysis objects.........................................................................................50 6.5 Data access...........................................................................................................................51 6.6 Changing access to Analysis workspaces..............................................................................53 6.7 Setting rights for custom groups............................................................................................53 6.7.1 To set rights for editing or deleting custom groups.................................................................54 6.7.2 To set rights for sharing custom groups.................................................................................55 6.8 Export to Analysis Application right........................................................................................55 6.8.1 To grant the right to export a workspace as an analysis application........................................56 Chapter 7 MDAS Maintenance..............................................................................................................57 7.1 Starting and stopping the Server Intelligence Agent...............................................................57 7.2 Starting and stopping the Multi-Dimensional Analysis Service................................................57 7.3 Restarting the Multi-Dimensional Analysis Service.................................................................57 7.4 Enabling and disabling an MDAS instance..............................................................................58 7.5 Adding and removing MDAS instances..................................................................................58 7.6 Configuration files for the MDAS Server................................................................................59 7.6.1 MDAS configuration file—mdas.properties............................................................................59 7.6.2 MDAS client configuration file—mdaclient.properties.............................................................60 7.7 MDAS properties and metrics................................................................................................61 7.7.1 Properties page......................................................................................................................61 7.7.2 Metrics page..........................................................................................................................62 4 2013-09-16Contents Chapter 8 Data Source Connections.....................................................................................................63 8.1 Creating OLAP data source connections................................................................................63 8.1.3 Finding a cube or query..........................................................................................................65 8.1.5 Authentication........................................................................................................................67 8.3 Deleting a connection............................................................................................................70 8.4 Moving a connection to another folder...................................................................................71 8.5 Data source connection settings............................................................................................71 8.5.1 Connection settings for SAP NetWeaver Business Warehouse data sources........................72 8.5.2 Connection settings for Microsoft Analysis Services data sources........................................73 8.5.3 Connection settings for SAP BusinessObjects Profitability and Cost Management data sources..................................................................................................................................74 8.5.4 Connection settings for SAP BusinessObjects Extended Analytics data sources...................75 8.5.5 Connection settings for SAP BusinessObjects Planning and Consolidation data sources.......75 8.5.6 Connection settings for SAP HANA data sources..................................................................76 8.5.7 Connection settings for Teradata data sources......................................................................77 8.5.8 Connection settings for Oracle Essbase data sources...........................................................78 8.5.9 Connection settings for Oracle OLAP data sources ..............................................................78 8.6 Managing Analysis data source connections..........................................................................79 8.6.1 Editing the title and description of an Analysis data source connection...................................79 8.6.2 Displaying a list of workspaces that use a data source connection.........................................80 8.6.3 Changing access to Analysis data source connections...........................................................81 8.6.4 Replacing an Analysis data source connection.......................................................................81 8.7 Configuring connections for Report-Report Interface..............................................................82 8.7.1 Enabling SAP BW query targets for the Report-Report Interface............................................82 8.7.2 Enabling single sign-on for RRI...............................................................................................83 Chapter 9 Managing Workspaces.........................................................................................................85 9.1 Overview................................................................................................................................85 9.2 Editing the title, description, and keywords of an Analysis workspace....................................85 9.3 Displaying a list of connections linked to the workspace........................................................86 Chapter 10 Sharing Workspaces.............................................................................................................87 10.1 Sharing workspaces using OpenDocument URLs..................................................................87 10.1.1 Setting prompt values using parameterized OpenDocument URLs.........................................87 10.1.2 Creating parameterized OpenDocument URLs.......................................................................87 Chapter 11 Scaling and Performance......................................................................................................89 11.1 Clustering MDAS instances...................................................................................................89 11.2 Load balancing.......................................................................................................................89 5 2013-09-16Contents 11.3 Optimizing performance.........................................................................................................90 11.4 Configuring Analysis for scalability against Essbase 11 data sources.....................................90 11.4.1 Increasing available ephemeral ports......................................................................................90 11.4.2 Reducing the TIME_WAIT state..............................................................................................91 11.4.3 Increasing the connection retry count.....................................................................................92 Chapter 12 Monitoring and Logging........................................................................................................93 12.1 Auditing..................................................................................................................................93 12.2 Trace logging.........................................................................................................................93 12.3 To enable statistics for Analysis on an SAP BW server..........................................................94 Chapter 13 Microsoft Analysis Services Considerations........................................................................95 13.1 IIS configuration for MSAS connectivity.................................................................................95 13.1.1 Copy required files.................................................................................................................95 13.1.2 Create an Application Pool.....................................................................................................96 13.1.3 Create a Virtual Directory......................................................................................................96 13.1.4 Configure Security.................................................................................................................97 13.1.5 Set up a Web Service Extension............................................................................................97 13.2 Analysis, edition for OLAP and Analysis Services security.....................................................97 13.2.1 Analysis Services role security...............................................................................................98 13.2.2 Finding more information........................................................................................................98 Chapter 14 Converting Workspaces to Analysis...................................................................................101 14.1 Converting workspaces from Voyager to Analysis, edition for OLAP...................................101 Appendix A More Information.................................................................................................................103 Index 105 6 2013-09-16Document History Document History The following table provides an overview of the most important document changes. Version Date Description SAP BusinessObjects Analysis, edition May 2013 Initial release. for OLAP 4.1 SAP BusinessObjects Analysis, edition August Added support for Oracle OLAP Data Provider for OLAP 4.1 Support Package 1 2013 for SAP Business Intelligence. Oracle OLAP Data Provider for SAP BusinessOb- jects Intelligence Connection settings for Oracle OLAP data sources Added information about configuring Analysis for scalability when connecting to Oracle Essbase data sources. Configuring Analysis for scalability against Ess- base 11 data sources 7 2013-09-16Document History 8 2013-09-16Introduction to SAP BusinessObjects Analysis, edition for OLAP Introduction to SAP BusinessObjects Analysis, edition for OLAP 2.1 Components of Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for OLAP is a query and analysis tool that business analysts in your organization can use to analyze your organization's multidimensional data. Users access Analysis from within the BI launch pad in SAP BusinessObjects Business Intelligence platform (the "BI platform"), and then create, save, and share their analysis workspaces in the BI platform repository. Once the workspaces are saved to the repository, other analysts or business users can work with those analyses over any web connection. Analysis administrators configure and maintain the Multi-Dimensional Analysis Service (MDAS), manage access rights, set up connections to OLAP data sources, manage workspace and data source objects in the BI platform repository, and perform many other administrative tasks. SAP BusinessObjects Analysis, edition for OLAP comprises these components: • Analysis client • Analysis Multi-Dimensional Analysis Service Note: SAP BusinessObjects Analysis, edition for Microsoft Office, although related very closely to SAP BusinessObjects Analysis, edition for OLAP, has its own documentation set, including its own administrator guide. 2.1.1 Analysis client The Analysis client application is the end-user component of SAP BusinessObjects Analysis, edition for OLAP. It is installed with SAP BusinessObjects Business Intelligence platform, and is accessed from within the BI launch pad. Data analysts use the Analysis client application to perform their data-analysis work and save their analyses to the BI platform. Users need only an internet connection, web browser software, and sufficient rights, to access the BI platform system and create or view Analysis workspaces. 9 2013-09-16Introduction to SAP BusinessObjects Analysis, edition for OLAP 2.1.2 Analysis Multi-Dimensional Analysis Service Analysis includes a Java BI platform service called the Multi-Dimensional Analysis Service (MDAS). The MDAS is installed with SAP BusinessObjects Business Intelligence platform, and is administered from within the BI platform's Central Management Console (CMC). The MDAS processes analysis requests from the Analysis client, retrieves OLAP data from the OLAP server, adds formatting, filtering, and highlighting information to the data, and sends the processed data back to the client application for display. The MDAS is a service within an Adaptive Processing Server (APS). The APS can be configured and managed in the Central Management Console (CMC). For more information about the APS and CMC, see the SAP BusinessObjects Business Intelligence Platform Administrator Guide. 2.2 About this guide 2.2.1 The documentation set The documentation set comprises these guides and online help information: SAP BusinessObjects Analysis, edition for OLAP Administrator Guide This guide contains detailed information that is useful to a system administrator when installing, configuring, and administering Analysis. SAP BusinessObjects Analysis, edition for OLAP User Guide This guide contains the conceptual information, procedures, and reference material required to use Analysis. SAP BusinessObjects Analysis, edition for OLAP Online Help The online help is optimized to provide quick answers for everyday tasks in Analysis. This Administrator Guide is a supplement to the SAP BusinessObjects Business Intelligence Platform Administrator Guide and SAP BusinessObjects Business Intelligence Platform Installation Guide, and provides information to help you administer an Analysis installation. The information in the BI platform guides applies to all SAP BusinessObjects servers and services, including the Multi-Dimensional Analysis Service. Consult the BI platform guides if you cannot find the information you seek in this guide. 10 2013-09-16Introduction to SAP BusinessObjects Analysis, edition for OLAP For a description of the BI platform components and installation instructions, and for installation instructions for Analysis, see the SAP BusinessObjects Business Intelligence Platform Installation Guide and SAP BusinessObjects Business Intelligence Platform Administrator Guide. For information on performance optimization see the SAP BusinessObjects BI Sizing Companion Guide. Note: • Throughout this guide, the term "UNIX" is used to refer to all UNIX-related platforms collectively. • SAP BusinessObjects Analysis, edition for Microsoft Office, although related very closely to SAP BusinessObjects Analysis, edition for OLAP, has its own documentation set, including its own administrator guide. 2.2.2 Who should read this guide This guide is intended for system administrators. You need administrator rights to administer SAP BusinessObjects Analysis, edition for OLAP and SAP BusinessObjects Business Intelligence platform. 11 2013-09-16Introduction to SAP BusinessObjects Analysis, edition for OLAP 12 2013-09-16Architecture Architecture 3.1 Analysis architecture diagram 13 2013-09-16Architecture 3.2 SAP BusinessObjects Business Intelligence platform deployment model SAP BusinessObjects Analysis, edition for OLAP fits into the broader BI platform architecture as a client-server setup with connections at the server and database levels to other BI platform servers. 14 2013-09-16Architecture 3.3 Multi-Dimensional Analysis Service The Multi-Dimensional Analysis Service is fully integrated with the BI platform. Like the other BI platform servers and services, it registers itself with the Central Management Server (CMS). Once registered, it is available for consumption by the Analysis web client. The MDAS provides BI platform client applications such as Analysis, edition for OLAP with an extensible and efficient framework for accessing multi-dimensional (OLAP) data. It not only provides access to multi-dimensional data but also converts the raw data into various XML packages, which the requesting client application then renders into a specific presentation format: Excel spreadsheet, PDF, or Analysis crosstabs and charts. 3.3.1 Server failover You may run multiple MDAS instances to accommodate a large number of users, or to provide redundancy if an MDAS should fail for any reason. If an MDAS fails, users on the failed MDAS are automatically moved to another available MDAS. Where possible, the failed user sessions are recovered and restored on the other MDAS. If the server fails before an action is completed, users may need to redo their last actions when their sessions are moved to a new MDAS. If an MDAS fails, and if other MDAS services do not have sufficient remaining capacity to accommodate the user sessions from the failed MDAS, the failed workspaces are autosaved to the Inbox folder in the BI platform, and those users are sent a notification. The users can later reload their workspaces and continue with their analyses. 15 2013-09-16Architecture 16 2013-09-16Installation and Configuration Installation and Configuration 4.1 Administrative tools 4.1.1 Central Management Console (CMC) The Central Management Console (CMC) is a web-based administration tool for managing Analysis data sources and workspaces, user accounts, rights, folders, and server settings. You also use the CMC to perform all MDAS administrative tasks. You must be a BI platform administrator to access the CMC. 4.1.2 Central Configuration Manager (CCM) The Central Configuration Manager (CCM) is a server-management tool that allows you to configure servers for your SAP BusinessObjects products on Windows. For Analysis, use the CCM to start and stop the Server Intelligence Agent (SIA). For all other administrative tasks, use the Central Management Console. Related Topics • Starting and stopping the Server Intelligence Agent • Central Management Console (CMC) 4.2 Installation notes 17 2013-09-16Installation and Configuration Analysis, edition for OLAP is installed as part of the SAP BusinessObjects Business Intelligence platform suite of products. For more information about installing products in that suite, including Analysis, edition for OLAP, see the SAP BusinessObjects Business Intelligence Platform Installation Guide. For information about platforms supported by Analysis, see http://www.sdn.sap.com/irj/boc/articles. An Adaptive Processing Server instance is created automatically during installation. When deploying to production, the recommended deployment method is to create another Adaptive Processing Server instance that contains only the MDAS, auditing, and monitoring services. For more information, see the SAP BusinessObjects Business Intelligence Platform Administrator Guide. The SAP HANA client is automatically installed when you install the BI platform, allowing you to create connections to SAP HANA data sources. For information about configuring IIS for connecting to Microsoft Analysis Services data sources, see IIS configuration for MSAS connectivity. For information about configuring the BI platform to connect to Essbase data sources, see To configure the BI platform for Essbase OLAP connections. Note: • Before users can begin working with Analysis, you must create at least one data source object. For information about creating Analysis data source objects, see Creating OLAP data source connections. • After installing Analysis, you may have to configure thefonts.xml file to have properly-rendered charts. For details on how to do this, see Post-installation configuration of fonts. • You may also have to configure your web application server. For more information, see Web application server configuration. 4.3 Data sources Analysis requires a connection to a supported OLAP data source, such as SAP BW, or Microsoft Analysis Services. Therefore, you must create at least one data source object before analysts can begin using Analysis to analyze data. 4.4 Web application server configuration The supported web application servers do not require any special configuration to work properly with Analysis, with these exceptions: • Sun Java System Application Server 9.1 Add-Xmx1024m-XX:MaxPermSize=256m as additional options to the JVM. • JBoss Application Server 4.2.3 & 5.0 GA 18 2013-09-16Installation and Configuration In therun.conf file, add this line: JAVA_OPTS=“-server-Xmx1024m-XX:MaxPermSize=512m- Dsun.rmi.dgc.client.gcInterval=3600000-Dsun.rmi.dgc.server.gcInter val=3600000” 4.5 Post-installation configuration of fonts If you need to use a Unicode font such as Japanese, or if you are running a UNIX platform, you must make a manual change to view charts and exported PDF files correctly. The font being used can be changed by editingfonts.xml. On Windows, thefonts.xml file is located in this folder:C:\ProgramFiles(x86)\SAPBusi nessObjects\SAPBusinessObjectsEnterpriseXI4.0\java\pjs\services\MDAS\re sources\com\businessobjects\multidimensional\services On UNIX, thefonts.xml file is located in this directory:SAPBusinessObjectsBusinessIn telligenceplatforminstallationdirectory/sap_bobj/enterprise_xi40/ja va/pjs/services/MDAS/resources/com/businessobjects/multidimensional/services Add the new font definition tofonts.xml. In the font definition, specify the following properties: 19 2013-09-16Installation and Configuration Property Description name The name of the font. This name must match the name of a font available on the font path of the operating system that the MDAS is running on. caption The caption of the font. Type the name that you want to display in theFont list on the chart "Properties" panel. resourceURL The URL of the font. For non-TrueType Collection fonts, the URL follows this format: file:///pathnameofthefontonthefilesystem TrueType Collection font files contain multiple fonts, each identified by a zero- based index number. For TrueType Collection fonts, you must add the appropriate index number to theresourceURL. The URL follows this format: file:///pathnameofthefontonthefilesystem,index number The following are examples of theresourceURL for TrueType Collection fonts: • MingLiU on Windows:file:///C:/WINDOWS/Fonts/mingliu.ttc,0 • PMingLiU on Windows:file:///C:/WINDOWS/Fonts/mingliu.ttc,1 type The type of the font. For example,TrueType orTrueTypeCollection. locale The locale that this font is assigned to. To set the new font as the default for all locales that do not have a font specified in thefonts.xml file, set theuniversalFontName attribute to the name of the font. Here is a sample Windows file listing: ?xmlversion="1.0"encoding="UTF-8"? MDASFontConfiguration Replacepathstofontwiththecorrectpathfortheinstalledsystem exampleofsomelocalemapping ============================== English-"en" French-"fr" German-"de" Italian-"it" Japanese-"ja" Korean-"ko" Chinese-"zh" fon:ServerFonts universalFontName="Arial" xmlns:fon="http://www.businessobjects.com/xml/schema/analysis/multidimensional/services/fonts/server" fon:Font name="Arial" caption="Arial" resourceUrl="file://C:/WINDOWS/Fonts/ARIAL.TTF" type="TrueType" locale="en"/ 20 2013-09-16

Advise: Why You Wasting Money in Costly SEO Tools, Use World's Best Free SEO Tool Ubersuggest.