|
|
Categories
»
Financials
Financials
- BI Content 3.2 Add-On Deliver Balance Sheet, P&L Analyses More Easily
by Lori Vanourek, BI Specialist, BI Product Management, SAP Labs
New functionality in the BI Content 3.2 Add-On release allows you to use contra accounts - accounts that can appear as assets or liabilities depending on their status at financial statement runtime - without custom workarounds. See how this functionality can help you produce better balance sheet and P&L analysis reports with less effort.
- Calculating Dates with Replacement Variables
by Raj Mani Thiyagarajan, SAP Certified BW Consultant, Kays Systems, Inc
This article provides useful information about how to perform calculations with date characteristics that are not defined as key figures. The author's technique can produce a report that shows the elapsed time between events - i.e., when a sales document is created and when it is billed. He walks you through six easy steps that calculate dates using replacement variables to represent dates as numbers.
- Enhancing DataSources in Standard Business Content to Suit Your Needs
by Nathan Genez, Platinum Consultant, SAP America
Sometimes the SAP-delivered Business Content does not map exactly to your requirements and you must modify it. This article explains how to add a field to an existing DataSource.
- Formula Variables Offer a Low-Cost Alternative to Cell Definition in Financial Reports
by Soumya Mishra, Sr. Consultant, Deloitte Consulting LLP (April 2009)
Find out how you can use formula variables with hierarchies to define individual cells in a report. This six-step process offers a low-maintenance alternative to developing custom query structures in BEx Query Designer, a pre-requisite for the cell definition feature.
- Meet the Three Challenges of Extracting Financial Data: High Volume, Content Modifications, and Satisfying User Needs
by Gilles Jaegy, Project Manager, HP Finance and Administration IT, Hewlett-Packard
We show you how to optimize three key processes to help meet the demands of extracting line-item financial data from R/3: loading financial data, enhancing the extraction process to modify content, and defining delta management to deal with high volume.
- Navigate the Complexities of Currency Conversion for More Accurate Management Reporting
by Jens Koerner, SAP NetWeaver BI Solution Architect, Inforte, a Business & Decision Company (February 2009)
Since dealing with multiple currencies has become commonplace in a global economy, it’s no surprise that currency conversion is needed everywhere in global organizations that implement and run SAP software solutions. While currency conversion was mainly the purview of the ERP system in the past, ERP systems no longer carry that burden alone. Today’s managers want reports on aggregated data in various currencies. Uncover the hidden complexities of currency conversion in management reporting, and discover easy-to-understand examples that help you communicate these complexities to project stakeholders to ensure that your solution will meet all multi-currency reporting requirements.
- Nine Ways to Get More from Your SEM-BCS Implementation
by Matt Christensen, Senior Consultant, PRAGMATEK Consulting Group
SAP's Strategic Enterprise Management Business Consolidation (SEM-BCS) functionality consolidates financial results for reporting purposes. The author reveals key features and benefits of BCS. He also provides tips, advice, and references that will enable you to optimize your implementation.
- Optimize FI-GL Processing with Intelligent Lookup Tables and Pseudo Delta Loads
by Sergei Peleshuk, Business Intelligence Consultant, ABSS Europe
SAP BW 3.x does not allow you to run two delta loads back to back. Learn a workaround involving DataStore objects and a pseudo delta load that allows you to do this. You can use this functionality to improve system performance in processing high data volumes when implementing complex business logic.
- Quick Tip: Avoid Misinterpreting Your BI-IP Data After Currency Conversion
by Natan Gerner, Senior Developer, Chartis Inc. (March 2010)
Here’s a simple solution to avoid excess records in BI-Integrated Planning when you have multiple currencies in your plan. Unlike other processes, these four steps enable you to handle currency translation without coding.
- Quick Tip: Define Constants in SAP NetWeaver BI for Easier Implementations
by Amit Barkai, Independent SAP NetWeaver BI Consultant and Project Manager
Using the Constant value for InfoObjects, DataStore objects, and InfoCubes allows you to control how compound characteristics appear in your system. This value also helps ensure that SAP NetWeaver BI implementers load characteristics properly from other systems, such as Financial Accounting. Find out how to use this value and how it affects your system.
- Sarbanes-Oxley: Speed Your Closing Processes with BW and SEM
by Peter Jones, Platinum BW and SEM Educational Consultant, SAP America
One result of the Sarbanes-Oxley Act of 2002 is that companies will need to close their books faster. BW and SEM offer functionalities and applications that help you achieve the fast close, including process chains, Business Consolidations System, and the Corporate Performance Monitor. We show you how you can use each of these to speed your closing.
- Transferring Global Settings from R/3 to BW
by Nathan Genez, Platinum Consultant, SAP America Inc.
Here's how you can perform the critical transfer of global data from R/3 to BW during its initial setup using an easy two-step process.
|
|
