Wednesday, February 22, 2012

SAP Business Objects Portfolio with SAP Application(EPM10.0)




SAP Business Objects Portfolio with SAP Application

EPM 10 is the result of multiple acquisitions BusinessObjects made in the financial management space before the merger with SAP: 
  • SAP Business Objects Strategy Management (formerly of Pilot Software)
  • SAP BusinessObjects Planning and Consolidation (formerly Business Planning and Consolidation by OutlookSoft)
  • SAP BusinessObjects Profitability and Cost Management (formerly of ALG Software)
  • SAP BusinessObjects Intercompany and SAP BusinessObjects Financial Consolidation(formerly of Cartesis).
  • EPM 10 include SAP BusinessObjects Financial Information Management (FIM), which bridges information from SAP and non-SAP sources and EPM applications.
    Other nonfinancial, operational applications in EPM 10 include SAP BusinessObjects Spend Performance Management (formerly Spend Analytics) and SAP BusinessObjects Supply Chain Performance Management.









The common BI capability that came with the Pilot Application Server (PAS) layer is now part of a broader set of EPM 10 applications (and some Governance, Risk and Compliance [GRC] 10 applications, such as SAP BusinessObjects Risk Management and SAP BusinessObjects Sustainability Performance Management). This means that objects and information stored and aggregated in, for example, SAP BusinessObjects Strategy Management, can be shared more widely with SAP BusinessObjects Planning and Consolidation, SAP BusinessObjects Risk Management and other financial and operational EPM 10 solutions.

EPM 10 comes with starter kits for various initiatives (such as IFRS, liquidity and capital expenditures planning), but also for specific industries, such as Banking/SCM/Insurance/Investments.




The Excel Interface of the EPM add in can be used to access data from multiple sources such as Planning and Consolidation and Profitability Cost Management (PCM).

EPM data Retrieval:-

1. We can create the Reports.
2. Analyze the Data( Sales,Profit,Margin..etc).
3.Dynamic formatting.
4. Calculation and charts (Graphical representations).
5.Print and Share( Information Broadcasting ).

Data Manager is used to import data and run planning functions such as copy,delete,and move.


Tuesday, January 24, 2012

SAP BPC 10.0


BPC 10.0 Architecture:- 


SAP BPC 10.0 will help us to deliver a more user friendly seamless and responsive user experience, driving higher user adoption - this  is why I see significant business benefit in implementing it.


Key Terms
Terms                                             Definition                                           
Dimension
Master data such as companies and accounts
Model
Transaction data such as expense values and exchange rate
Environments
Contains dimensions and models
BW
SAP Business information warehouse
Properties
Related fields such as currency
Dimension Members
EXAM: Company code
Base Level Members
Members with no children

SAP BPC 10.0
SAP BPC 7.5 TERMS
SAP BPC 10.0 TERMS
Applications
Models
AppSets
Environments
Owner
Performer
Data Source Dimension Type
Audit Trail Dimension Type
Group Dimension Type
Scope Dimension Type
Live Reports
Web Reports/Input Forms
Dynamic Hierarchy Editor
Ownership Manager

Current View
Context
Member Access Profile
Data Access Profile
ApShell
EnvironmentShell
Validation
Controls


Monday, January 2, 2012

SAP BPC Interview Questions?

SAP BPC


1 How Plan Functions in the SAP BPC,is it any Std Function available at NW . if THERE WHAT those?
2 How many types of Consolidations(Legal/Management)
3.Wht is the type of Dimensions is used statutory consolidation?
4.How you do Budgeting and wht the Road map?
5.sales,revenue Planning Process(PCM)?
6.How define the IFRS strategy in Financial Business?
What is the BPF ,When to be Use?
6.how is more effective the Work Status?
7.where execute the process of sales planning?
8.why do u need inter company elim ? what kind of parameter to used?
9 when inter company elimnation how investment to be raise different Vendors(Companies,Pub,Prt,Inc)
10.what is Reconciliation Account Tran formation?
11. when to be use BADI And how it is Best to run the R/3?
12.What kind of GAAP Analysis will Work ,when Barrier moving accross the Regions?
13.if error is : Config Sql ,what is the error when it is invoke?
14.What is Sarbanes-Oxley product help teh BPC?
15. what is CAPEx ?,
16.What kind of Optimization is More Effective the generating report from SAP BPC?
17.why do u need properties does have BPC,where will define ,why need?
18.how Direct versus Indirect Subsidiaries and the impact on the method of consolidation BPC?
19. Can you Explain the different types of Consolidated Reports
A) Trail Balance vs Balance Sheet $ Income Statement
B)Important Sections of a Balance Sheet
C)Important Sections of a Income Statement
20. Difference between Balance Sheet and Income Statement Eliminations?
21.When a dividend should be eliminated &How a dividend is booked?
22.What parts of a finance organization utilizes financial consolidations?
23.Relationships/Ownership/Groups/Consolidation Methodology ?
24.Why do u need Process chains and how do break when we need adhoc report in sales/revenue planning?
25.) Doing a full process, system goes through 16 steps. The first 15 run fine. Step 16 called Result shows done in 00:00:00 and fails. Only shows a red bullet with a white X and the word fail. There is no error message to tell me what is failing so I have no idea why the step is failing. Suggestions?


26) On the Print and Option sheet of dimension members, how are these populated? When I process the dimension, no changes are made to these sheets.
27). SAP BPC Issue MS version problem.
In BPC, In AppSet( AppShel) i have 3 applications.
1) Finance 2)Rate which are in built samples in BPC.
3rd is "MyApplication" created by me.


Now my problem is: From BPC-Excel in Session Information:
i clicked on C.V :"Application not Set" link. and a window appeared asking to selecta application from dropdown. But is not displaying only "Finance" and "rate" sample applications but not "MyApplication" which is created by me.


How to resolve the issue?


28) All my non-prod systems (ECC6, BI, SolMan) are running on a VMWare host without any problems. Windows 2003 Server, MS SQL2005 Enterprise have issue not connecting the DB? How to solve?


29) how can config the SAP BPC report Adobe Format ?


30)What is the configuration of th physical server on which VMs run In BPC ?
31)How many VMs with which configuration ?
32)Where is the Data stored. Is it in local disk or SAN ?
33)How many NIC cards are there and how they are configured for the VMs?
34)How are the database servers configured for this VMs IN sap bpc ms version ?
35)What is difference Between the BPC 7.0 TO 7.5?

Wednesday, October 12, 2011

Difference between SAP BPC Lite and Full Optimization



Lite Optimization


Is a maintenance process similar to the BW Info Cube performance maintenance tasks of index rebuild, statistics rebuilds, and compression.
This process deletes the info cube indexes and moves records from the F to the E fact tables.
This process compresses/collapses the records with the same key
Additional zero suppression is possible (manually adjusted in process chain)
Updates the info cube statistics



There is no set recommendation as to the frequency, however it is generally recommended that these (index/statistics) tasks be executed after the load process to provide satisfactory performance for reporting and input schedule updates.


From 1508929 “There is no rule of thumb for how often to run optimizations. The need can vary depending on the characteristics of your hardware environment and your application.”


As best practice:


When new application sets and applications are created run a Full Optimization.
Lite Optimization doesn’t take the system offline, and can be scheduled during normal business activity (e.g. after a data load)
Full Optimization need the system to be offline so they should be run at down-time periods – for example after a month-end close.


Full Optimization


This process essentially rebuilds the application in its entirety. The process creates a new application and copies the data to the new application.
This process is a RESTRUCTURING of the BPC application data model
How does the system determine if a full optimization is necessary?
The algorithm looks at the size of the dimensions and the dimension members. If the dimension tables have <20% size of the fact table and as many line item dimensions are used, then the system will give a message “Optimization not required at this time”.
The full optimization logic is as follows (ref. SAP 1551154):


If the InfoCube needs restructuring – do it, then perform lite optimization
If not, perform a lite optimization
Why does the infocube technical name change with the Full Optimization?

Monday, August 22, 2011

Reporting and analytics with BPC: Navigating your options

Reporting and analytics with BPC: Navigating your options:




"SAP BusinessObjects Planning and Consolidation provides an easy-to-use and powerful interface for creating reports and maintaining data. The reporting options for SAP BusinessObjects Planning and Consolidation can be classified under two broad categories:


SAP BusinessObjects Planning and Consolidation for Excel


SAP BusinessObjects Planning and Consolidation for Web


An Excel interface is used to report data in SAP BusinessObjects Planning and Consolidation, which can also be integrated with Word and PowerPoint documents. SAP BusinessObjects Planning and Csonlidation for Excel, however, is the primary tool used for planning, consolidation, and reporting.


The SAP BusinessObjects Planning and Consolidation Web interface can be used as a complementary tool to create and enable reports on the web.


The following are some of the key features of the reporting tool within SAP BusinessObjects Planning and Consolidation:


1. Offers Excel tools with SAP data storage


When you use the SAP BusinessObjects Planning and Consolidation for Excel tool, you can use the functions and features available in Excel and, at the same time, store the data in an SAP BusinessObjects Planning and Consolidation database. This enables users to use both Excel and a robust database for storing data, which will be necessary for high volume enterprise wide applications.


2. Provide dynamic templates


SAP BusinessObjecs Planning and Consolidation offers standard templates, also called dynamic templates, which support different types of analysis commonly requested by businesses. Standard templates can be used to develop different types of reports, including monthy comparison reports, yearly comparison reports, trend reports, and variance reports. The ability to use these templates with very little development effort reduces TCO.


3. Allows you to customize standard templates


Standard templates can easily be customized to meet a particular business requirement. This easy-to-customize feature makes standard templates more appealing.


4. Offers flexible ways to display data


The reporting interface is designed to provide maximum flexibility to display data. There is no code involved in creating a report. Using selection criteria, the report displays the data that is required for analysis. The system-supplied Measures dimension lets you view the data in different ways, either by period, quarter to data (QTD), or year to date (YTD).


5. Provides Ev functions


SAP BusinessObjects Planning and Consolidation for Excel provides Ev functions, a table of functions used for reporting. This aids in creating and delivering sophisticated reports for efficient data analysis.


6. Allows for offline analysis


The data displayed in SAP BusinessObjects Planning and Consolidation reports can also be used for offline analysis. Specific features allow users to take the data from a report offline, modify it, and retract it back into SAP BusinessObjects Planning and Consolidation.


7. Provides features unqiue to planning and consolidation


SAP BusinessObjects Planning and Consolidation provides features that are used specifically in planning and consolidation applications. The ability to use spread, trend, and wight data makes it easy to allocate data and create projections for the future.


8. Offers standardized reports


The reporting functionality includes out-of-the-box system reports that can be displayed and executed on the web. They servce as a tool to analyze metadata and to monitor changes to the objects in SAP BusinessObjects Planning and Consolidation."


These, of course, are still just a few of the reporting options available with BPC. Today, many users even leverage their planning and consolidation activities alongside SAP BusinessObjects BI solutions, such as Xcelsius and SAP Crystal Reports, for further data analysis.

Tuesday, June 7, 2011

SAP BPC Questions/

1.What is BPC?
As you must be aware that BPC stands for Business Planning and Consolidation. As the name suggest, BPC is used for both Planning and Consolidations, unlike IP, which is used for only planning.

2. When BPC 7.5 NW is avaliable?
The 7.5 version is currently in the ramp-up stage and should be availble in few months. I am not sure of the exact month.

3. BPC for NW has an aggregation level or not, Is BPC an application on top SAP-IP?
BPC and IP have completely different architecture. BPC doesnt use aggregation levels or filters. BPC and IP have no relation and thus, cannot be compared. BPC uses various script logics, business rules for doing the planning. Manual planning can be done with input schedules. The input schedules are on excel platform and are quite versatile. You can use BPC functionalities alongwith native excel functionalities for better design of the input schedules.

4. What about BPC in consolidation part?
BPC comes with pre-delivered components for consolidationm, which can be leveraged on. There are few business rules, which makes the consolidation process easier.

5. What is the concept for plan data from BPC?
The concept of planning is the same as you have in any other tool. The functional side of the planning remains the same. However, the tool differs. The way you configure a planning scenario will be much different than any other planning tool. Unfortunately, it will not be feasible to address this in the forum. You can definitely go through the study materials for a better understanding.

6. BPC for NW need to install .NET application server and Web server or not?
Yes. You can have a look at the installation guide available on market place for detailed requirements.

7. What is BPC client tool? and If I planning on BEx report, I have to create an aggregation level for planning data or not?
BPC client sits on the client machines, from where, you will be doing the design. There are mainly 3 interfaces available - BPC Admin, BPC Office, and BPC Web. BPC Office, in turn has 3 interfaces - Excel, Word, Powerpoint. These interfaces can be used for various requirements.

8.SAP BPC:-Business Consolidation:
SAP Business Planning and Consolidation meets all your legal and management consolidation and reporting requirements. Because the software's centralized data repository contains up-to-date actuals from your operational systems, you always have instant access to harmonized charts of accounts, shaving weeks off your consolidation process and simultaneously ensuring compliance with regulatory mandates, such as the Sarbanes-Oxley Act. Specifically, you gain a single, centralized view of performance data and can instantly generate clear, transparent financial statements and reports relating to profit and loss, cash flows, and balance sheets. In addition, the software helps you compare budget-to-actuals data (assets, liabilities, revenues, and expenses); automate the intercompany elimination process; gain transparency into corporate transactions at all levels; and manage any number of currencies by performing conversions, allocations, and eliminations. Automated reports support all reporting standards, including Generally Accepted Accounting Principals (GAAP), Financial Accounting Standards Board (FASB), International Accounting Standards (IAS), and International Financial Reporting Standards (IFRS). Finally, the software improves compliance with regulatory and financial standards and generates a fully documented audit trail to reduce external audit costs.

9. SAP BPC :-Reporting and Analytics:
With SAP Business Planning and Consolidation, you gain a unified, predictive performance management solution for financial and operational reporting and analysis. You can perform production and management reporting (including exception reports), financial and operational analysis, and ad hoc and multidimensional analysis. At the same time, the software provides automated predictive analytics that proactively push findings relevant to employees so they can take appropriate action. It automatically identifies key performance indicators (KPIs) that are at risk, identifies the metrics and drivers of those KPIs, and recommends actions that can change predicted outcomes for the better. In addition, you can quickly find explanations for variances - and root causes - so you know where to focus management attention. Finally, you can make risk-adjusted plans and more calculated decisions using intelligent modeling functions that give you a more precise understanding of risk probabilities.

10. SAP BPC :-Forecasting:
SAP Business Planning and Consolidation provides centralized, collaborative, prepackaged business process flows, tightly linked to the data and processes supporting planning and budgeting, to simplify the enterprise-wide forecasting process. Predictive analysis functionality goes beyond the typical trend and seasonality algorithms, enabling you to produce more accurate plans and budgets, create rolling forecasts, and incorporate real-time actuals with historical data for the most effective forecast seeding possible.

11. Extracts: Vision, Strategy, Business Processes, Organizational Structure, Roles, IT System
Transforming the story into business terms we could say the business owner had a Vision (his imagination), a Strategy (his long term plan), few Business Processes (to produce his imaginary product / service), an Organizational Structure (the model of his business), a few Roles (human resources to run his business). Additionally he implemented an IT System to leverage his initial investment.
Business Equation
Based on the above description of a Business, we can summarize a business model with following equation:

Input > Processing > Output

To get the desired Output, it’s obvious we’ve to have Correct Input and Processing. Referring the equation to successful businesses we could notice “Well defined Processes are key success factors”. And we can’t determine a process is correct unless we know what Output was actually required.

Business Processes’ Study
Understanding the equation requires a thorough study of
vision & Strategy to find out what exactly company is targeting and how
• processes it employs to achieve its goals
• organizational model to know the RACI
• IT system which refines the processes
Business Process Management

Business Process Management – a Holistic Management Approach, talks about Optimization of Business Processes which is achieved by
Analyzing existing processes of an organization and
1. Designing refined & optimized model of business processes.
SAP Business Process Management Methodology what it does?
SAP BPM Methodology addresses the need and provides details on “how-to”
Identify the key success factors of a business
• Understand the existing processes & set the priorities for analysis
• Compare the business processes with Industry’s Best-Practices processes
• Identify weak areas, link them and Assess them together
• Develop high-level and detailed design of to-be model
• Figure-out the required adaptation areas within an organizational model
• Create a transformation plan and utilize existing landscape to support the new model
• Fit & map the changes into an existing solution with analysis of organizational and master data

Phases: A methodological approach

The methodology clearly distinguishes between the Business Approach (Top-Down) and the IT Perspective (Bottom-Up) and is divided into 4 major Phases i.e.
Calibration
1. As-Is Analysis
2. To-Be Design
3. Solution Transformation

It provides the necessary tools 1) to Analyze the existing processes and 2) to Design a To-Be Model.

Monday, June 6, 2011

Preparation for Profit Center Consolidation

Preparation for Profit Center Consolidation

Preparation for Profit Center Consolidation
When cross-company deliveries and services occur within a corporate group, internal business volume and intercompany profits arise. These are eliminated in SAP Consolidation in order to allow a cross-company display of results to profit centers.
For these eliminations, you need the partner information at the profit center level. In Customizing for Profit Center Accounting, you have two ways of ensuring that the system finds the right partner profit centers during cross-company-code processes:
• Derivation of the partner profit center
• Reading the partner profit center
If the affected companies are stored in distributed SAP systems, the system can only determine the partner profit centers using derivation.
If the affected companies are stored in a central SAP system, the system can determine the partner profit centers using derivation or by reading them. When reading the profit centers, the system accesses the origin documents and therefore supplies the exact partner information. However, this method can have a negative effect on performance. For information on how this program functions,
We can use both procedures at the same time. To start with, the system will try to determine the partner profit center using the read program. If it cannot find a partner profit center in this way, it will find one using the derivation rules.
Using the partner profit center, the system also finds the partner company and the customer or supplier master record and updates this in Profit center Accounting. This makes this information available for profit center consolidation.

Prerequisites
You are using the SAP components Sales and Distribution (SD) and Materials Management (MM).
If you are not using these modules, you have to transfer the partner profit centers from your systems to Financial Accounting in the SAP system.
If you want to use SAP Consolidation, make the settings for finding partner information in Customizing for Profit Center Accounting, under Preparations for Consolidation.

The settings must have been made when the relevant postings are made. The partner information cannot be found retrospectively.
For more information about the settings that you have to make, see the Implementation Guide (IMG) for Profit Center Accounting, under:
Derive Partner Profit Centers in Purchasing
Derive Partner Profit Centers in Sales
Identify Associated Companies for Reading


Profit Center Accounting (EC-PCA)

Profit Center Accounting (EC PCA) lets you determine profits and losses by profit center using either period accounting or the cost of sales approach. It also lets you analyze fixed capital and so called “statistical key figures” (number of employees, square meters, and so on) by profit center. Consequently, you can calculate all key figures commonly used in cost accounting (return on investment, cash flow, sales per employee, and so on).
A profit center is a management oriented organizational unit used for internal controlling purposes. Dividing your company up into profit centers allows you to analyze areas of responsibility and to delegate responsibility to decentralized units, thus treating them as “companies within the company”.
The essential difference between a profit center and a business area is that profit centers are used for internal control, while business areas are more geared toward an external viewpoint.
The profit center differs from a cost center in that cost centers merely represent the units in which capacity costs arise, whereas the person in charge of the profit center is responsible for its balance of costs and revenues.
EC-PCA is a part of the Enterprise Controlling (EC) module and is integrated with new General Ledger accounting (FI-GL).

Features
The main aim of Profit Center Accounting is to determine profit for internal areas of responsibility. It lets you determine profits and losses using either period accounting or the cost-of-sales approach.
By assigning balance sheet items (asset portfolio, payables and receivables, material stocks, work in process) to profit centers, you can analyze your fixed assets by profit center, thus using them as investment centers. This makes it possible to expand profit centers to investment centers. This also makes it possible for you to analyze a number of key figures by profit center, including return on investment, working capital and cash flow.
EC PCA lets you set up your profit centers according to product (product lines, divisions), geographical factors (regions, offices or production sites) or function (production, sales). You need to make the settings in Basic functions to divide the company into internal areas of responsibility. You divide you business into profit centers by assigning the profit centers to the various master data that is relevant for profits (materials, cost centers, orders, projects, sales orders, assets, cost objects and profitability segments). This lets you set up Profit Center Accounting in a way that meets your company’s requirements regardless of what sector of industry your company is in (machinery, chemicals, services, and so on) or what form of manufacturing you employ (repetitive manufacturing, make to order production, continuous flow production).
Every profit center is assigned to the organizational unit Controlling area. The profit centers in a company code belong to a standard profit center hierarchy that is also assigned to the controlling area.
All profit relevant business transactions are updated in the profit center hierarchy according to G/L account at the same time they are processed in the original module of the SAP system. This ensures that the entire flow of goods and services within a company is transformed in goods and services relationships between profit centers. This is true both with actual postings and in planning.
You can also transfer the balances and balance changes of certain balance sheet accounts to profit centers in real time or periodically.
Goods movements between profit centers can be valuated either at external prices, group internal prices or specially defined transfer prices.
The Information System provides a user-friendly tool for evaluating your plan and actual data. Because results are stored by G/L account, you can reconcile the data with data in Financial Accounting at the cost element level. The reports contained in the standard SAP system represent a simple information system for analyzing areas of responsibility. In addition, different tools are available which let you create your own reports to further meet the needs of your company.
To call up the application menu for Profit Center Accounting, choose Accounting ® Enterprise Controlling ® Profit Center Accounting from the SAP Easy Access screen.
Profit Center Accounting also features tools such as Validation, Substitution, Archiving and ALE.

The profit center master data contains the structural concepts according to which you can post and subsequently analyze the data that is relevant for Profit Center Accounting.

Structure
Profit center master data includes the following objects:
• Profit Centers.
• Standard hierarchy of the profit centers
• Dummy profit center for non-assigned postings
• Alternative profit center hierarchies (if required)

A profit center is an organizational unit in accounting that reflects a management-oriented structure of the organization for the purpose of internal control.
We can analyze operating results for profit centers using either the cost-of-sales or the period accounting approach.
By calculating the fixed capital as well, we can use your profit centers as investment centers.
The master data of a profit center includes the name of the profit center, the controlling area it is assigned to, and the profit center’s period of validity, as well as information about the person responsible for the profit center, the profit center’s assignment to a node of the standard hierarchy, and data required for communication (address, telephone number and so on).
Every profit center is assigned to the controlling area organizational unit. This assignment is necessary because Profit Center Accounting displays values in G/L accounts.
The system transfers all the data to Profit Center Accounting together with the G/L account to which the data was originally posted. You can only aggregate data that shares the following:
● Same chart of accounts
● Same fiscal year variant
● Same currency
Time-Based Master Data
Like cost centers, profit centers are valid for a specific time period. This has the following advantages:
● No complicated activities are necessary when a new fiscal year begins.
● we can enter future changes to the master data in advance.
Profit centers are time dependent in two ways:
● First, we can enter a period during which actual or plan data can be posted to the profit center.
● Second, we can define time-based fields when you customize Profit Center Accounting.
Time-based fields let you change information in the profit center master record, such as the person responsible for the profit center, at a specific point in time without having to create a new profit center and without losing any information about the previous person responsible.
The Standard Hierarchy

To ensure that your data in Profit center Accounting is consistent with that in other areas, you must assign each profit center to the Standard hierarchy .
The standard hierarchy is used in the information system, allocations, and various planning functions. You can also assign your profit centers to alternative hierarchical structures, called Profit Center Group.
Copying Cost Centers
If the profit centers in your organization are closely linked to your cost centers, you can simply copy your cost center master data to create your profit centers. For more information on this function, see the Implementation Guide (IMG) for Profit Center Accounting, under Master Data.
A profit center group is a hierarchical structure of profit centers.

Profit center groups are used for reporting, allocations or in various planning functions, where it is not desirable to enter or display data at the lowest level (with a high level of detail).
The standard hierarchy is a special form of a profit center group. It has to contain all profit centers belonging to the controlling area and reflect the organizational structure of Profit Center Accounting.
For more information on the standard hierarchy, Standard hierarchy for classic Profit Center Accounting or Standard hierarchy for new General Ledger Accounting.