yazik.info Programming Sap Bpc420 Pdf


Wednesday, April 10, 2019

SAP BusinessObjects Planning and Consolidation, Version for. SAP NetWeaver: BPC SAP BusinessObjects Planning and Consolidation, Version for SAP NetWeaver: Administration SAP CPM Date Training Center Instructors Education Website Participant Handbook Course Version: 95 Course. BPC SAP Business Planning and. Consolidation, Version for SAP. NetWeaver: Standard. Administration and Planning. Configuration.. COURSE OUTLINE. bpc - Download as PDF File .pdf) or read online. SAP BPC handbook version.

Sap Bpc420 Pdf

Language:English, Spanish, Dutch
Genre:Politics & Laws
Published (Last):24.12.2015
ePub File Size:21.41 MB
PDF File Size:9.16 MB
Distribution:Free* [*Register to download]
Uploaded by: ELVIA

Free Sap Bpc Pdf - yazik.info title: free sap bpc pdf author: orion publishing group subject: sap bpc keywords: download books sap bpc Download Sap Bpc Pdf - yazik.info to prove the sap bpc keywords: sap bpc created date: sap business planning and consolidation. Download Sap Bpc Pdf - yazik.info download sap bpc free pdf, download sap bpc pdf, read online sap bpc pdf, free sap bpc ebook.

Terminology Lesson Summary You should now be able to: Business Example You are currently using Integrated Planning and you need to know what the benefits are to migrate.

The upper slide is a high level analysis. Going Forward As you can see both planning tools will be available in the future. This is the workbench for BPC Administrators. Business Example Figure Application Set Management Figure The Admin Console — First Orientation Use the tree on the left to select which components to display or maintain.

The middle area displays the settings and metadata for the component you have selected in the tree. The action pane is on the right. Application Set Management Only a user with System Administrator rights can create a new application set.

NET client will poll this background job until it is finished. When you create a new AppSet, these steps get executed: Any error during a copy of an AppSet will result in a rollback to clear all created objects.

A custom message can be created that will inform users that the AppSet is unavailable. It is recommended to include the date and time in the message which will indicate to the users when they can log back on. Application Set Management This slide contains information about the implication of an application set being offline for other modules. Set Template Version Updating the template version number will force an update of the template files to the clients.

The version number can be changed in the Admin Console as well as in the Application Set Parameters using the Web Administration interface. The system will handle updating the clients with dimension changes automatically.

New NetWeaver Information at SAP.com

This slides describes how to delete an application set. The delete is permanent and cannot be reversed. It logs all RFCs from the.

When viewing the User Activity report, you can refresh the report with the most recent activity or delete the old activity. Application Sets: Dimension Management Lesson Overview Understand the possibilities of how to load master data.

This opens the available Action Pane tasks. Dimension Management Figure They are added at the Application Set level in the dimension library folder. These then become shared dimensions that are available for use in any application in the application set.

Dimensions within one Application Set cannot be used within another Application Set. Some dimension types are required dimensions and must exist in all the applications within an application set.

The dimension type determines the default properties to be included in the dimension. Add additional properties as needed. Dimension field names may ONLY be max of 20 characters. Each dimension built will walk through a series of steps via the Action Pane inside the Admin Console.

Remember, clicking the Left hand side pane will quit the activity or step in the process. All properties will get created as new InfoObjects. Internally they are stored as type string and linked to the star schema through the dimension member ID which is length This means that they will not be available for Advanced logic or rule based calculations.

But we can store many more properties and longer lengths for storing important information, such as a Full Customer Address without using multiple properties. To reduce the size, you will have to create a new property copy the values over from the old property, and delete the old property. Selecting a dimension will display a view that highlights the properties of the dimension, their system name and size of the property.

SAP BPC Certification Preparation Guide

Use of Dimension Properties Defining the right properties in a dimension support various functions from the users interface and make reporting much easier. In addition, properties are often critical component used to evaluate expressions in advanced script logic and business rules.

Remember, the value you place in a members property may be pulled to any applications BPC for Excel page, as is. Modify Dimension Modifying a specific dimension is limited to the specifics of the dimension, such as the description and reference dimension.

Copy Dimension Use the copy process when you have an existing dimension type and design, including properties, that you want to leverage for a new dimension. Concepts and Objects in BPC Administration BPC This is useful when building similar dimensions, such as Account or Entity, that already have several properties and members, but you need separate dimensions for different applications. Delete Dimension Only delete a dimension once you have removed it from any active application.

Once it is deleted, all associated information is removed from the database. This file has the same name as the dimension. You must add a new member and copy the data. If you plan to delete a member, you will need to verify that all data related to that member is deleted, including across applications if the dimension is shared. Once you do delete the member, you may find that you will need to re-process the whole application to get everything back to order.

The sheets currently store all properties and members alphabetically. This has been noted as a possible area for improvement. Do not be surprised that what you saved, once re-opened has a whole new look to it. The data is correct, just re-organized. Modeling Hierarchies It is natural to have hierarchies for dimensions such as entity and time where the need for rollups is common.

Hierarchies also allow the use of multiple views from one dimension. For example the entity such as Store dimension can be used to view data by company code, plant, or region. Multiple Hierarchies A dimension can have more than one hierarchy.

A parent in SAP Business Planning and Consolidation must have the same children if it is reused across multiple hierarchies. The option to process a dimension can be found in the Action Pane. Processing Dimensions Figure This means that when you process a dimension, the values to save back to the master data of the SAP NetWeaver B InfoObject are taken from the Excel sheet you currently have open on your client machine.

If you do not select this, it assumes you have already chosen to save the sheet to the server before processing, and therefore the BW master data is updated from the sheet on the server.

If you have manually built aggregates on your SAP Business Planning and Consolidation cubes, then this performance benefit of processing would be lost. The next slide indicates what may be changed and any changes outside of the ones herein will not be supported.

If you use BW technique to load master data you will have to process the relevant dimension afterwards. If you use BW to load master data you will need to run the hierarchy attribute change run in BW manually as well as make sure the caching mechanisms in SAP Business Planning and Consolidation were updated correctly.

Creating Applications Lesson: Creating Applications Lesson Overview In this lesson we will discuss how to model and create application. Business Example You need to set BPC up to do expense planning and so you need the applications to store the transaction data. If you select the Application level on the left, the Action Pane will display tasks relevant for Applications: Create; Copy; Modify and Delete Applications.

Create vs. Concepts and Objects in BPC Administration BPC The major difference then is that Copy will actually copy the data, and you can not change the dimension assignments when copying, while Create allows you to change dimension assignments, but not copy data.

When choosing Create, the documents stored in the file system from the Source application will be copied. Technically the following operations are realized as Process Chains and will technically be executed in a Background Mode: You can use job log in transaction code SM37 to view the detailed log information and progress of these jobs. During execution the Admin Client will be locked and will constantly poll for the status of this background job every 20 seconds.

Only when the job has finished, control will return to the client for these jobs. Creating a New Application By checking off the currency conversion rules, the system will create business rule tables to perform that function.

Planning applications must reference a rate application. One rate application can be referenced by multiple other applications.

Creating Applications Figure This slide contains a list of options available when an application is being created. Each application should have at least four dimensions; Category, Entity and Time, Account.

To delete a dimension from an application, it is necessary to first delete all the dependencies of that dimension from the application. Creating Applications You can report on non-reporting application data, but you cannot assign work status codes to the data.

In addition, you cannot define business rules to these application types.

Reporting applications require the four dimension-types: Entity, Account, Time, and Category but non-reporting types do not. Required Dimensions per Application Type This slide contains a list of required dimensions for each application type. It is important to note that every application can not have duplicate dimension types for these required dimensions. There is no rule of thumb for how often to run optimizations, but as data volumes grow over time, it is recommended to run optimize periodically.

There are two different types of optimization available: If the data model can be improved, Full Optimize will do so, and this could take a long time to run for cubes with large data volumes. Both optimiziation options require that the application is offline. Be careful running a Full Optimize as significant system resources are used in the process. Specifically, it will check: If the cube structure can be optimized, then it will: These changes will be lost if the underlying technical InfoProvider is changed.

Bpc en Col97 Fv Co a4

What you can't do in RSA1 Partitioning is not available because we do not use the standard SAP time dimension, and that is all that NetWeaver supports for partitioning.

We will consider additional enhancements here in the future. However, most of these parameters are available when the cube contains no data. Therefore, when you create a new cubes you could alter them, but when a shadow cube is created, these type of changes would be lost. Therefore, it is not really possible to configure these items. They are both constants in the data flow. The underlying Realtime InfoProvider is exchanged if you do a full optimize.

The new cube would then have to be added manually to the MultiProvider after the optimization. YTD vs. Its possible to use a preconfigured Data Management Package to convert from one time related view to another. Custom measures are also supported.

Or you want the format Half Year. Steps in BPC after creating an Application This slide contains the order of processes that take place when an application is created.

So all this configuration is a major reason why you cant use an existing BI cube! Creating Applications Lesson Summary You should now be able to: Where is Security performed? Security is installed via BPC exclusively. Security The normal order for configuration is: Try to avoid assigning task profiles, access profiles to users directly. If many users need access to identical base members, then you should create the relevant member access profiles, create teams, assign teams to profiles and users to teams.

Modeling of Security is team-based then. Maintenance is easy here if people leave, need a substitute and so on if everything is managed by team. But its a lot of maintenance to create so many teams. If nearly all users need access to completely different members, then a member access profile-model is needed in which you create the relevant member access profiles and assign users to these profiles. Security — Schema Its important to clarify the Security terminology first.

Basically there are Users. They belong to groups called teams. The required profiles are assigned to these teams. Local users should only be an option within a system for development or a demonstration.

Task Profile: Member Access Profile: Security Figure The upper slide shows how you can do it.

Creating Teams When you assign security to teams, the security works collectively on the team members. This allows you to easily maintain security for many users at the same time.

A team leader has special privileges a team member doesnthave. A team leader can save templates to their team folder on the server. In BPC 7. The administrator automatically has the manage template task assigned. There is no need to assign administrative rights and team leader rights.


The team leader can modify team transformation file and conversion file and can read transformation and conversion files located in company folder. Non-team leaders only have read access rights. Concerning the Data Manager and the Package Organization: The Team leader can manage a package at the Team level. Default Roles are available or you can add Profiles as needed. After creation of a Profile you can assign it to multiple users, as needed. For example a user can be both, a System Admin and a Primary Admin.

By default a System Admin can create, modify, or delete application sets and define security. By default a Primary Admin can do all admin tasks except create, modify, or delete application sets. By default being a Secondary Admin allows users to manage dimension members and to maintain locks. Only for these dimensions you will have to define if you want a write-read, read-only, read or deny access for certain members of this secured dimension. Without having defined a Member Access Profile its not possible to work with the Application.

Member Access Profile — Configuration In the member access profile, only the access to the secured dimensions can be administrated. You have write access to all members of a dimension which are not marked as secured dimension. Security Example: The upper hierarchies form the example for the security issues described in the next slides. Conflict 1: Conflict 2: Conflict 3: Conflict 4: Security Exercise 1: Business Example You need to create the dimensions and applications for a planning scenario.

Task 1: The System Administrator has created this application set for you. Take a look at your dimensions and applications in the Admin Console. The application set you are logged on to is a copy of ApShell however, it does not contain any transaction data. Add new account members to the account member sheet. Validate and process the Account dimension to apply the changes. This lab will help you learn how to update dimensions and members using the Admin Console.

Dimensions should reflect your business. It's a good idea to think about the following related business requirements as we work with dimensions: Dimensions — what dimensions do you need in your appset, how many per application Members — what are the naming conventions Properties — which to include for filtering, sorting, reporting, and calculations Hierarchies — how many per dimension and how many levels 1.

Also make all Acctype property values EXP. Open up the provided excel file with dimension members on the G drive in the BPC7. Maintain Owner and Reviewer as follows: Process the dimension without taking the system offline: Security Task 3: A: Associate 4.

What are the various languages in which the certification can be done? A: English 5. What is the cut-off or passing percentage? What are the types of questions asked? Also, as shown in the sample questions, the number of correct answers is indicated for each question.

These exam topics prove to be very helpful in the preparation. They act as the blueprint for the exam. This is because the questions asked in the exam are sourced from these topics itself. What are easy tips you can have in your mind while giving this exam? If a question has 3 correct answers, and I answer 2 answers correct, will I get partial marks? A: No. The pattern of scoring is binary - either it is correct or wrong. No partial marks available.

On this note, make sure to pay attention on the indicated number of correct answers to make sure that you have chosen correct number of answers.Perform this step for all three applications. Default Roles are available or you can add Profiles as needed. Member Access Profile: It is important to note that every application can not have duplicate dimension types for these required dimensions. Planning applications must reference a rate application.