Journals

Journals to record and make adjustments to data in the database.
A journal template has been created for the application set.
The appropriate security to perform Journals.


The procedure or steps Journals:
Go to BPC Admin
Manage applications
Finance folder (or any application)
Click Journals
On Action pane click Journal Wizard
Select Header and Detail Dimensions
Create additional header items and sub-items
click finish to create journal template

Setup Task profile for Journals in SECURITY folder

Go to BPC for Excel
From eTools menu, select Journal
From eJournal menu, select New
Create Multi-Header Journal
Save the Journal
Click eJournal menu, select Manager
Post journal entries
Click eJournal menu, select Manager
Execute query (for Journal reports)

SAP BPC Audit

SAP BPC Audit
SAP BPC is a powerful tool, when organizations have performance, scalability, or data accessibility issues need audit to reduce the process inheritance and improve the process.
BPC has Data auditing and Activity auditing.
Activity Auditing
This function tracks administrative and user tasks at the application set level.
The activity audit records information on system changes, for example, who is creating, changing, deleting applications, dimensions, security, and so on.
Show activity type has following options are available:
• All - All activity types
• Add - Only add activity
• Change - Only activity that involves changes within the system
• Delete - Only delete activity

Reporting on Data Audit Information
Planning and Consolidation records data audit information on who changed transactional data in the application. Since a data audit can only be captured for an application, this report is only applicable at the application-level.
A report shows who changed the data, what time they made the change, how they made the change (for example, through logic or Interface for Excel), and the details of the record that was changed.
The Value field shows you what SIGNEDDATA was changed to, as a result of the change. That is, it shows you the new value (neither the original nor the delta value posted to the database).
Data Auditing
this function tracks changes to transactional data at the application level, such as when and by whom records were changed within an application.
Administrators control whether data auditing is active or not. To enable data auditing, ensure an application set is within your current view, then choose Manage Data Audit.
For each application within the application set, you select a category and one or more of the following tasks to audit:
• Planning and Consolidation for Office
• Data Manager Import
• Data Manager Clear
• Logic Execution
• Live Report
• Journals
We can managing data audit settings, Reporting on data audit information, Purging and archiving data audit logs.


Activity auditing allows you to track the administrative tasks performed in the system. Once activity is recorded, you can run a report that shows system activity, based on specified criteria. The report shows when the task was performed, and by whom.
If enabled, BPC tracks activity for the following functional tasks:

• Application set and application setup
• User and team setup
• Member access and task profile setup
• Business Process Flow management
• Adding, deleting, and modifying business process flows
• Saving business process flows to new names
• Data audit maintenance and activation of data audits
• Document type and document sub-type setup
• Activation of activity audit

It doesnt capture details regarding the work status.

SAP BPC Work status

SAP BPC WORKSTATUS
Work status provides more control to business team in terms of data submission, review and tracking.
• Define – the data region allowed for updates and the responsibility of the region with the control of the Work Status change.
• Control – how updates are achieved (methods) and by whom.
• Manage – Setup work status at both the global and individual application level.

Configuration Steps
• The work status is setup at both the appset and application level.
• The setup at the appset level is fixed for all the applications. The appset level is where you set the „work states‟ and their order but in the application is
• Where you setup the driver dimensions.


Options for each Method / Interface
• All = any user with member access write privilege
• Owner = only users assigned as owner with member access write privilege
• Mgr = only users assigned as owner of the parent to the current member ID with member access write privilege
• Locked = no user regardless of authorization.


Controlled By: Determines who can select the work status code
• Both = owner of the specific member ID and the owner of the parent to the specific member ID
• Owner = owner of the specific member ID
• Mgr = owner of the parent to the specific member ID.

The maximum number of dimensions allowed of work status is 5, minum 3 Dimensions.

The areas of BPC for which you can control the level of security

• Data Manager :Controls data input from running a Copy, Import, or Move package.
• Journals: Controls data input from posting journal entries.
• Manual BPC for Office data entry :Controls data submissions from reports and input schedules in BPC for Office.
• BPC Comments :Controls data input from posting comments (unstructured data).
• Documents :Controls posting documents with application context to the Content Library (unstructured data).



Work Status Process

1. Configuring Work Status – Like Unlocked, Submitted and Approved
2. Ensure owner property is available in the controlling dimension – Example In a planning scenario the entity dimension could be the controlling dimension, so the owner property needs to be present with valid user id(s)
3. Configure the work status setting at the application level – The work status setting could contain different set dimension to determine and control the work status
4. Specify base hierarchy for the work state dimensions
5. Provide member validation for the non work state dimensions

SAP BPC Interview Question?

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?
36)What is the Manufacturer Consolidation,How to maintain the Profit in the Organisation ?

BPC MS EXCEL GOAL SEEK Function Examples

BPC MS EXCEL GOAL SEEK Function Examples

Fiancé Modeling by using GOAL SEEK Functions
Our considerable experience ranges from operational models developed for internal use to financial models for transaction structuring and bank negotiations.
• Operational modelling
• Budgeting, planning and forecasting
• Margin analysis
• Inventory management
• Cash management and reporting
• Performance analysis
• Cost and pricing analysis
• Capital structure optimisation
• Working capital
• Capital investments
• Feasibility modelling
• Acquisition analysis
• Project finance models
• PPP tender models
• process modelling (chemical & mining)
• Information management systems
• Debt optimisation models
• JV partnership models
• Contract modelling


Goal seek functions Works
• From the Excel menu bar, click on Tools
• From the drop down menu, click on Goal Seek
• A dialogue box pops up like the one below:

The dialogue box needs a little explaining. "Set cell" is the answer you're looking for, this is the Goal. Set cell needs a formula or function to work with. Our formula is in cell B3, so if your "Set cell" text box does not say B3, click inside it and type B3.
"To Value" is the actual answer you're looking for. With "Set cell", you're just telling Excel where the formula is. With "To Value" you have to tell Excel what answer you're looking for. We wanted an answer of 56 for our formula. So click inside the "To Value" text box and type 56.
"By Changing Cell" is the missing bit. This is the part of the formula that needs to change in order to get the answer you want. In our formula we have an 8 and a 6. Clearly, the 6 is the number that has to go. So the cell that needs to change is B2. So go ahead and enter B2 in the "By Changing Cell" text box. Your dialogue box should now look like this:

Click OK when your dialogue box looks like the one above. Excel will then Set the cell B3 to the Value of 56, and change the figure in cell B2. You'll also get a dialogue box like the one below:

Click OK on the dialogue box. Your new spreadsheet will look like this one:

So Goal Seek has given us the answer we wanted: it is 7 that when times by 8 equals 56.

Increase your profits with Goal Seek
To give you a more practical example of what Goal Seek does, consider this problem. You have a business that generates 25 thousand pounds worth of profit. You currently sell 1000 items at 25 pounds each. You want to increase your profit to 35 thousand pounds. Assume that you're still going to sell 1000 items. By how much does the price of each item have to increase by in order to generate the new profit total?
We'll work it out together using Goal Seek. And then you can have a try yourself with an exercise. First, here's a new spreadsheet for you to download:
When you open the spreadsheet, you'll notice that the Current Sales Figures and the Future Sales Figures are exactly the same. The formula in Cells B4 and E4 are = B2 * B3 and = E2 * E3
We can use Goal Seek to solve our problem. What we want to know is, What should be the new Price Per Item in order to generate Profits of 35 thousand?
• So, from the Excel menu bar, click on Tools
• From the drop-down menu, click Goal Seek
• The Goal Seek dialogue box appears

This time, our formula is in cell E4. So we want to Set the cell to the cell that has our formula. So type E4 into the "Set cell" text box.
The "To Value" text box will hold our new Profits. The Goal we are aiming for is 35 thousand. So type in 35000 in the "To value" text box.
The cell we want to change is the Price Per item figure. So in the "By changing cell" text box, type in E3.
Click OK when you're done. Excel will give you this dialogue box:

The dialogue box is telling you that Goal Seek has found a solution. Click OK. Your spreadsheet will already have changed. The new Future Sales Figures will be displayed. Your spreadsheet should look something like the one below:

Goal Seek has given us the answer of 35 pounds. So the cost of each item has to increase by 10 pounds if we want a profit of 35 thousand.




Example 2



Excel's Goal Seek feature allows you to alter the data used in a formula in order to find out what the results will be.
The different results can then be compared to find out which one best suits your requirements.


Example Using Excel's Goal Seek feature:
For help with this example, see the image above.
• This example first uses the PMT Function to calculate the monthly payments for a loan.
• It then uses Goal Seek to lower the monthly payment by altering the loan period.
1. Enter the following data into the cells indicated:
Cell - Data

D1 - Loan Repayment
D2 - Rate:
D3 - # of Payments:
D4 - Principal:
D5 - Payment:
1. E2 - 6%
E3 - 60
E4 - $225,000
1. Click on cell E5 and type the following formula:

= pmt ( e2 / 12 , e3 , -e4 )

and press the ENTER key on the keyboard
2. The value $4,349.88 should appear in cell E5. This is the current monthly payment for the loan.
Altering the monthly payment using Goal Seek
1. Click on the Data tab.
2. Choose What-If Analysis from the ribbon to open the drop down list.
3. Click on Goal Seek... in the list to bring up the Goal Seek dialog box.
4. In the dialog box, click on the Set cell: line.
5. Click on cell E5 in the spreadsheet since we are interested in altering the monthly payments for this loan.
6. In the dialog box, click on the T0 value: line.
7. Type 3000 since we would like to lower the monthly payment to $3000.00.
8. In the dialog box, click on the By changing cell: line.
9. Click on cell E3 in the spreadsheet since we want to change the monthly payment by altering the total number of payments to be made.
10. Click OK.
11. At this point, Goal Seek should begin searching for a solution. If it finds one, the Goal Seek dialog box will inform you that a solution has been found.
12. In this case, the solution is to change the number of payments in cell E3 to 95.25.
13. To accept this solution, click OK in the Goal Seek dialog box and Goal Seek will alter the data in cell E3.
14. To find a different solution, click Cancel in the Goal Seek dialog box. Goal Seek returns the value in cell E3 to 60. You are now ready to run Goal Seek again.