SAP BusinessObjects Analysis

SAP BusinessObjects  Analysis, Microsoft Office Edition

It is new tool of BI 4 it is:

Easy-to-use OLAP analysis in Office
Familiar and intuitive Microsoft  Office user experience
Uncover deep insights with powerful Excel-based analytical capabilities
Bring  analyses into PowerPoint presentations
Leverage all your investments - BW cubes and BEx queries, and BI platform



SAP BusinessObjects Analysis, edition for Microsoft Office, is a Microsoft Office Add-In that allows
multidimensional analysis of OLAP sources in Microsoft Excel, MS Excel workbook application design,
and intuitive creation of BI presentations with MS PowerPoint.

The Add-In is available for the following Microsoft Office versions:
• Microsoft Office 2010 (Excel and PowerPoint)
• Microsoft Office 2007 (Excel and PowerPoint)
• Microsoft Office 2003 (Excel)

In the edition for Microsoft Office, you can use SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems.
If the workbook will be used by different users, it is also helpful to add info fields with information on the data source and filter status.
Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once.



See also:
Sap BO Analysis Creating Workbooks

BO Analysis - Creating and managing BW system connections in SAP BusinessObjects BI4 - BOE

Configuring BO Analysis on SAP HANA

Sap Business Objects 4.0

Comments

  1. UnknownJune 6, 2017 at 2:27 AM

    nice blog.
    Business Intelligence Technologies
    Business Intelligence Solutions

    ReplyDelete
  2. Used PC SupplierAugust 25, 2017 at 5:55 AM

    Nice Blog Post !

    ReplyDelete
  3. Dipika September 13, 2017 at 10:47 PM

    Its really extremely good information, thanks for sharing.
    SAP Application Management Services Mumbai
    SAP Application Support

    ReplyDelete
  4. UnknownFebruary 22, 2018 at 2:54 AM

    Well written article. Get rid of the traditional ways of marketing and buy a customized email list from us. One real-time data can change your entire business for good. Parana Impact provides you the Email List that you are exactly looking for.
    We have worked with many organizations of all the sizes. Our main focus is customer satisfaction. SAP Business Objects ERP Users Email List

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innov...
Read more

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo...
Read more

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man...
Read more