SAP BusinessObjects Analysis for Office –
Advanced Scheduling, Distribution, Management

APOS well managed BI solutions complement SAP BusinessObjects Analysis, edition for Microsoft Office (Analysis for Office), with improved scheduling, distribution, content management, and administrative capabilities.

Analysis for Office provides easy access for data analysts and other BI users to SAP Netweaver Business Warehouse (BW) and HANA via the familiar and flexible Microsoft Excel and Microsoft PowerPoint interfaces. BW and HANA data access means Analysis for Office lets you:

  • Analyze large data sets to uncover deep business insights
  • Discover, compare, and forecast business drivers in Excel
  • Share discoveries by embedding data analytics into PowerPoint presentations
  • Boost analyst efficiency with content reuse and real-time query responses
  • Speed data analysis with in-memory computing technology

Analysis for Office is designed to let you run ad-hoc analysis of OLAP sources in Excel, to connect seamlessly with SAP Business Warehouse and SAP HANA and power real-time analytics, and to embed you findings into live PowerPoint presentations for sharing.

APOS solutions provide a wide range of capabilities to support Analysis for Office users from data analysts to IT use and maintenance, particularly with regard to:

  • Individual scheduling
  • Enterprise Scheduling
  • Management and administration
  • Analysis for Office as a Data Source

Analysis for Office Scheduling - Individual & Enterprise

Even when you are scheduling for yourself or your team, you may be repeating the same scheduling operation over and over. For example, suppose you meet regularly with your team to discuss a set of KPIs. You might schedule the same report before each such meeting to ensure you are discussing the most current information.

You may think of Analysis for Office as primarily a tool for ad-hoc analysis, but it's very seldom that we do such analysis without wanting or needing to share it with our team, or with a much more diverse group. In conversations with many of our customers who are using Analysis for Office, we have discovered that scheduling is high on their list of challenges.
Scheduling is a broad topic encompassing topics such as:

  • Scheduling for personal use
  • Scheduling for team use
  • Repeated, recurring scheduling
  • Scheduling for large, diverse groups
  • Scheduling for external stakeholders
  • Scheduling to different formats and destination types

As your scheduling and distribution requirements become more complex and the volume of reports grows, so too will your need for more and more comprehensive scheduling and distribution capabilities. The APOS Administrator and APOS Publisher solutions have been designed to provide these capabilities.

Learn more about Analysis for Office Scheduling & Distribution.

Analysis for Office Managment & Administration

The more usable Analysis for Office becomes, the greater its adoption rate, and the more it will be used to meet diverse reporting requirements. Once you have achieved easy-to-use, flexible, scalable and reusable scheduling, Analysis for Office becomes an instrument of mass distribution.

This substantial achievement leads to some new challenges: volume and complexity. These new challenges lead to new requirements. You will need to find ways to streamline the management and administration of the Analysis for Office environment and its content. These challenges include:

  • Bulk instance management
  • Document archive and backup
  • Document impact analysis

The APOS Administrator, APOS Storage Center, and APOS Insight solutions have been designed to meet these needs.

Learn more about Analysis for Office Management and Administration.

Analysis for Office as a Data Source

The APOS Data Gateway makes it possible to use Analysis for Office documents as a data source for your other BI projects in, for example, SAP Design Studio or SAP Lumira. The reason this a desirable capability is that it allows you to leverage the discovery and analytical work done in Analysis for Office, and to avoid repeating the same work in other analytical and visualization applications. You get to reuse the calculations on trusted data from Analysis for Office to present a single version of the truth in other SAP applications.

Analysis for Office, the SAP Convergence Strategy, and APOS Well Managed BI Solutions

The SAP convergence strategy puts AO at the centre of Office Integration, so strengthening your AO capabilities is a safe investment that will continue to provide substantial returns. The continuting rapid adoption of Analysis for Office means that many organizations are looking for ways to support their analysts and BI users to develop more efficient workflows.
APOS solutions provide useful methods and interfaces for some of the most repetitive and time-consuming tasks Analysis for Office users face, such as scheduling with multiple parameters. Data analysts who value the familiar interface and ease of use of SAP Analysis for Office will also appreciate the expanded capabilities delivered by APOS solutions, and the simplifying and streamlining effects these capabilities will have on their analysis and reporting workflows.

APOS well managed BI solutions complement SAP BusinessObjects Analysis, edition for Microsoft Office (Analysis for Office), with improved scheduling, distribution and content management capabilities.:

  • Do you need flexible, bulk scheduling capabilities?
    See how APOS Administrator can help.
  • Do you need bursting capabilities to deliver reports to diverse destinations in different formats?
    See how APOS Publisher can help.
  • Do you need to implement a comprehensive content storage and management strategy?
    See how APOS Storage Center can help.
  • Do you need to use Analysis for Office as a data source for other SAP applications?
    See how the APOS Data Gateway can help you access Analysis for Office from applications such as Design Studio and Lumira.
  • Do you need to perform impact analysis for your Analysis for Office activities?
    See how APOS Insight can help you inventory all of your Analysis for Office documents and instances and extract the structure of analysis for Office documents to a database for comprehensive impact analysis.

Well Managed BI  |  Solutions  |  About APOS  |  Resources  |  Careers  |  Customer Support  |  Contact Us  |  Site Map  |  @APOS_Systems

APOS Well Managed BI Blog APOS LinkedIn page APOS Facebook page WellManagedBI Twitter feed