|
|
Categories
»
BW
BW
- Ask the SAP Financials Expert
Should I Report in CO-PA or BW?
by Mitresh Kundalia, SAP Practice Manager, Quality Systems & Software Inc.
You have a choice of three approaches when reporting on CO-PA data: You can report using CO-PA, Business Information Warehouse (BW), or both.
- Automate Your Data Compilation Processes with BPS — It’s
Not Just for Planning
by Matt Christensen, Director of Enterprise Performance
Management, PRAGMATEK Consulting Group
Do
you have users tracking time spent on projects in spreadsheets
and emailing them throughout your organization to be
compiled? Do you extract financial results and perform
Excel-based calculations for management reports? Are
you developing product or project quotes for customers
in a spreadsheet that is not integrated to your operational
system? Learn how to use Business Planning and Simulation
(BPS) to cut operating expenses and reduce cycle times
associated with data collection and processing.
- Configure SAP Financial Closing Cockpit to Start Close Tasks in Multiple Systems
by Janet Salmon, Solution Manager, SAP AG
See improvements made to SAP Financial Closing Cockpit in Enhancement Package 3 that allow it to integrate with SAP Central Process Scheduling by Redwood and to create close tasks in other systems.
- Express Planning Gives Managers Access to Plan Data in
Multiple Systems
by Janet Salmon, SAP AG
Express
Planning is a self-service Web functionality in mySAP
ERP 2005 that gives managers the ability to extract
the data they need during the budgeting process, even
if the data is in a different system. They also can
write data back to various modules and monitor variances
without any external help. Express Planning masks the
system complexities from the manager.
- Extract Financials Line Item Data to Your SAP NetWeaver BI System on a Regular Basis
by Anurag Barua, Senior Manager
For large enterprises, data extraction is a time-consuming process that usually prevents users from frequent extraction. See how to set up your system for extraction of financial data into your SAP BW or SAP NetWeaver Business Intelligence system more frequently than daily.
- How to Pivot SAP BW Queries
by Joerg Boeke, Director of Business Intelligence, syskoplan AG Germany
Although BW provides filter and drill-down functionality, many BW users miss the pivoting functionality of MS Excel. The author provides seven easy steps to enable drag-and-drop functionality in SAP BW queries. This gives end users the power to optimize their BW queries.
- Layer SAP xApp Analytics on Top of SAP
SEM for a Simplified Balanced Scorecard
by Dr. Karol Bliznak, SAP AG
You can streamline the user interface for Strategic Enterprise Management and Corporate Performance Monitor by adopting the Best Practice Scorecarding application, which is part of SAP xApp Analytics. You then can provide users with graphical views of their key performance indicators via a portal.
- Make the SEM Management Cockpit More Useful with Drill-Down Configuration
by Paul Halley, Director of Strategic Enterprise Management, Business Information Solutions
SEM's Management Cockpit (MC) creates easy-to-use graphics that display data of all types. While most executives want to see the summarized data that the cockpit displays so well, they also want to be able to examine the details of that data. The author explains how to use a little known piece of functionality that allows a user to drill down from an MC graph to a BW query. From there, the user then can drill down further into an R/3 line item report.
- Maximize Your CO-PA Implementation with Better/Worse and Billing, Booking, and Backlog Reports
by Pinckney Ma, Independent Consultant, and Peter Jones, Platinum Consultant, SAP (July 2010)
Learn tricks and tips for profitability analysis (CO-PA) implementations. First, see how to implement the better/worse (B/W) % module with a percentage of cost or profit. Then follow some tricks and tips for the design of the billings, booking, and backlogs (BBB) module. It is difficult when the BBB module involves multiple currencies and an exchange rate adjustment for the last period’s closing. Step through an example of the BBB module with specific examples of the queries needed.
- Part 1: An Introduction to SAP Business Planning and Consolidation
by Ryan Leask, Director, BPC Solution Management, Enterprise Performance Management, Business Objects, an SAP Company, and
Prakash Darji, Director, BPC Solution Management, Enterprise Performance Management, Business Objects, an SAP Company
Learn about the reporting features available in SAP Business Planning and Consolidation, including how to use existing report templates and how to build your own.
- Part 1: Should Your Financials Team Consider the Portal?
by Janet Salmon, Solution Manager, SAP AG
Discover how to use the role upload tool delivered with SAP NetWeaver to generate updated portal pages for your Financials users. You can use your existing roles in SAP ERP as a starting point.
- Part 1: Simplify FI Transactions in Dynamic Environments Using SAP NetWeaver BI Data Mining Suite
by Dr. Marco Sisfontes-Monge, SAP Consultant
Discover an alternative to data manipulation and calculation in complex ABAP programs for extracting data from your SAP ERP Central Component (ECC) or R/3 system for FI transactions such as paying sales representatives.
- Part 2: Should Your Financials Team Consider the Portal?
by Janet Salmon, Solution Manager, SAP AG
Extend transaction PFCG to create a Report Launchpad, which allows users to start SAP NetWeaver Business Intelligence reports and other portal content.
- Part 2: Simplify FI Transactions in Dynamic Environments Using SAP NetWeaver BI Data Mining Suite
by Dr. Marco Sisfontes-Monge, Arellius Consulting (November 2008)
Learn more about the development of a dynamic financial application for FI data extracted from R/3 or SAP ERP Central Component using the SAP NetWeaver Business Intelligence Data Mining Suite. See how to develop an application flexible enough to calculate the commission rates for sales representatives of different regions and update their equations as frequently as required without ABAP coding.
- Pick the Right Reporting Tool for the Job: CO-PA or BW
by Tony Rogan, Senior Applications Consultant, et alia
If you have the option of using either CO-PA or SAP's Business Information Warehouse to produce reports, then it pays to think about which tool you use in a given circumstance. Choosing the wrong one could mean poor performance, a loss of flexibility, or compromised integrity of the result.
- Provide Report Writer and BW Reports Without Selection Screens
by Markus Kuppe, Director Product Management, mySAP Financials Portal Solutions, SAP AG
Manager Self-Service (MSS) provides your end users with new reporting functionalities - reports without selection screens, a new set of tables that stores their selection criteria per user, and the ability to look at more than one report on a screen. This article is the third in a series on MSS, which is standard Business Package that comes with SAP Enterprise Portal.
- SAP Consolidation Strategy: SAP BW-Based SEM-BCS vs. R/3 EC-CS
by Paul Halley, Director SEM Practice, Business Information Solutions (BIS) and Alan Hildebrandt, Managing Director, BIS
Canada, Inc
An integrated financial consolidation system is crucial to facilitate the month-end closing process. Weigh the functionalities of two SAP consolidation tools, EC-CS and Business Information Warehouse (BW)-based SEM-BCS.
- SAP NetWeaver 2004s: Data Upload Feature Enhances Sarbanes-Oxley Consolidations Compliance
by Peter Jones, Platinum Consultant,
SAP
SAP NetWeaver 2004s includes automatic data uploading functionality that replaces the Microsoft Excel-based method. It features a new consolidated process using Real-Time InfoCubes and Real-Time DataStore objects.
- SAP NetWeaver Portal: Initiate and Track the Planning Process with Collaboration Rooms
by Janet Salmon, SAP AG
The Business Unit Analyst role shipped in mySAP ERP 2005 replaces the spreadsheets and distribution lists that used to organize the process of gathering and monitoring the submission of budget data with a collaboration room. Learn how it is designed specifically to select the managers who need to plan, send out workflow tasks to these managers, track the responses, and monitor and approve the planning data.
- SEM vs. R/3 for Financial Statement Planning
by Paul Halley, Director, Strategic Enterprise Management, Business Information Solutions, LLC
Very few organizations have not performed some variation of financial statement planning at one time or another. These plans are usually produced to fulfill legal statutes or regulatory filings, so much time is often put into their accuracy. Private-sector organizations often engage in this type of activity on a weekly basis. The process involves the production of forecasted profit-and-loss (P&L), balance- sheet, and cash-flow statements. Public-sector organizations tend to carry out this exercise annually, with the result influencing part of or all the next year's budget.
- View Your Profit and Loss Data and
Analyze Your Investments Using Visual
Composer
by Jean-Hubert Guillot, SAP
See how two applications of Visual Composer, the Profit Center Accounting dashboard and the Investment Approval template, work in conjunction with SAP ERP financial functions. Discover the elements of their user interfaces and see how they can help your company evaluate its financial data.
- What Are Target Costs in Cost Center Accounting and Why Should You Calculate Them?
by Janet Salmon, SAP AG
Many reports that monitor cost center performance are incomplete because they account for the planned output rather than the actual output of the cost center. The author demonstrates how to use adjusted costs called target costs. Calculating target costs will provide you with a report that more accurately reflects the performance of your cost centers.
|
|
