enabling spend performance management in sap

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 1

Enabling Spend Performance

Management in SAP

BusinessObjects Universe

Applies to:

SAP Spend Performance Management 2.1, SAP BW, SAP SRM, Analytics, SAP eSourcing, Enterprise Performance Management (EPM), Operational Performance Management (OPM), SAP BusinesObjects Universe.

Intended Audience: Customers of SAP Spend Performance Management

Implementation Partners

Summary

This paper provides detailed procedure on how to consume the Spend Performance Management (SPM) standard BW Query into various SAP BusinessObjects analytical tools via the SAP Business Objects Universe.

Author: Rajesh Prabhu

Company: SAP

Created on: 6 Oct 2010

Author Bio

Rajesh Prabhu is a Development Architect for Enterprise Performance Management applications with a focus on Spend Performance Management

Enabling Spend Performance Management in SAP BusinessObjects Universe


© 2010 SAP AG 2

Table of Contents

Sustainability Recommendation ......................................................................................................................... 3

Background ......................................................................................................................................................... 4

Data Model Architecture Diagram ................................................................................................................... 4

Prerequisites ....................................................................................................................................................... 5

Target Audience ................................................................................................................................................. 6

Procedure ........................................................................................................................................................... 7

SPM Query Preparation .................................................................................................................................. 7 Start the Query Designer ............................................................................................................................................. 7

Open the Spend Analysis Final Query (0ASA_MP01_Q1002)..................................................................................... 8

Save As your own Query ............................................................................................................................................. 9

Set flag for allowing external access .......................................................................................................................... 10

Remove the Calculated KeyFigures (many marked as Obsolete): ............................................................................. 10

Check Query .............................................................................................................................................................. 11

Dealing with Errors in Query ...................................................................................................................................... 12

Defining the Universe .................................................................................................................................... 14 Start the Universe Designer and Login ...................................................................................................................... 14

Define the Universe ................................................................................................................................................... 16

Choose Login Mechanism.......................................................................................................................................... 19

Select the appropriate Query ..................................................................................................................................... 21

Complete the Definition .............................................................................................................................................. 22

Reporting with WEBI on this Universe .......................................................................................................... 22

Related Content ................................................................................................................................................ 26

Copyright........................................................................................................................................................... 27



© 2010 SAP AG 3

Sustainability Recommendation

If printing this document is unavoidable, printing can be targeted for pages 7 through 26.

Printing on both sides is highly recommended.

Color printing doesnot provide any additional information and can be avoided



© 2010 SAP AG 4

Background

Spend Performance Management is an Analytical Application to help analyze Procurement Data. The application comes with its own rich client interface. But because the data model is based on standard BW and the content for the application gets deployed in the BW server just as the rest of standard BW content, the data model can hence be exposed to all of the data visualization interfaces that the standard BW content does. The purpose of this document is to provide instructions on how to expose Spend Performance Management content to the SAP Business Object Universe so that all of the other reporting tools that run on top of the universe can serve Spend data to the end users. The higher level data model architecture diagram of Spend Performance Management is given below:

Data Model Architecture Diagram

As is clear from the architecture diagram, all of the reporting data is exposed through a unified reporting layer. In BW terms, this unified layer has a Multi Provider (0ASA_MP01) which provides a single view of all of the underlying application cubes and Queries on top of this Multi Provider which become the basis of end user reports.

If Detail reports needs to be exposed to the Universe, similar procedure needs to be followed as outlined in this document for detail report queries which are built on top of the detail Multi Provider (0ASA_MP04).



© 2010 SAP AG 5

Prerequisites

1) Spend Performance Management application installation (2.1 and above)

2) SAP BW tools including Query Designer

3) Knowledge of SAP BW

4) Knowledge of Spend Performance Management

5) Knowledge of BOBJ Universe and WEBI (or any other reporting tool that would be used to connect to the universe)



© 2010 SAP AG 6

Target Audience

1) Spend Performance Management customers

2) Customers who already use SAP Business Objects Reporting Portfolio and are interested in incorporating Spend Analysis scenario

3) SAP Implementation partners who already specialize in Spend Performance Management implementations or are planning to offer the services



© 2010 SAP AG 7

Procedure

SPM Query Preparation

Start the Query Designer



© 2010 SAP AG 8

Open the Spend Analysis Final Query (0ASA_MP01_Q1002)



© 2010 SAP AG 9

Save As your own Query



© 2010 SAP AG 10

Set flag for allowing external access

Remove the Calculated KeyFigures (many marked as Obsolete):

% Remaining Contract Amount Obsolete: 0ASA_MP01_CKPCT_REM_CON

% of Total Spend Obsolete : 0ASA_MP01_CK505

Supplier Price Optimization Potential Amount Obsolete: 0ASA_MP01_CK501

Supplier Price Optimization Percentage Obsolete: 0ASA_MP01_CK502

PO Price Savings Potential Amount Global Obsolete: 0ASA_MP01_CK503

Contract Utilization (Global) : 0ASA_MP01_CKCUTIL

Remaining Contract Amount Obsolete: 0ASA_MP01_CK522_TCURR

Actual Spend Transaction Curr Obsolete: 0ASA_MP01_INVAC_LCURR

Remaining Contract Amount Local Obsolete: 0ASA_MP01_CK522_LCURR

PO Price Savings Potential Amount Local Obsolete: 0ASA_MP01_CK503_LCURR

PO Price Savings Potential Percentage

PO Price Savings Potential Amount (Local)

PO Price Savings Potential Amount (Global)



© 2010 SAP AG 11

Check Query



© 2010 SAP AG 12

Dealing with Errors in Query

If you get an error like the one below, then not all of the problematic CKFs have been removed.



© 2010 SAP AG 14

Save Query

Defining the Universe

Start the Universe Designer and Login



© 2010 SAP AG 19

Choose Login Mechanism

Security Recommendation: Single Sign On is a recommended best practice configuration. Choose the appropriate option based on defined security policy.

For this document a Specific user is being used.



© 2010 SAP AG 22

Complete the Definition

Click Finish to complete the creation of the Universe.

Now that the Universe is setup and ready for consumption, any BusinessObjects UI that supports Universe can now provide the analytical reports. The next chapter uses the SAP BusinessObjects WEBI as an example.

Reporting with WEBI on this Universe



© 2010 SAP AG 26

Related Content

SPM Topic area on BPx: http://www.sdn.sap.com/irj/bpx/spend

SPM Forum: http://forums.sdn.sap.com/forum.jspa?forumID=411

Bringing the value of SAP Spend Performance Management to mobile users: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20356

http://www.sdn.sap.com/irj/bpx/spend

http://forums.sdn.sap.com/forum.jspa?forumID=411

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20356



© 2010 SAP AG 27

Copyright

© Copyright 2011 SAP AG. 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.

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems, Inc.

JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, 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.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. 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.

enabling spend performance management in sap

Documents