SAP BPC Distribution and Collection:

SAP BPC Distribution and Collection:

1.Excel templates can be distributed to Microsoft office Outlook e-mail address.
2. Excel templates can be distributed to network folders.
3.Distribute data will also collect data from offline templates send it to the database.

* Distribute-Start the distribution wizard
* collect-Start the collection Wizard
*New/Open Template -Create new 
*Save /Save as -Save or copy template
*Validate -Validate the reference workbook
*Change Connection- use this option to select a different connection.

To Distribute the workbooks, the Distribution Wizard is used ,we can select the output type and folder location.




After distribution ,the log is available for review. 

Distribution--->Collect the EPM- ---Collection Wizard  will open...

Either the outlook or local folder is select and then the folder is selected .

E -Mail options

If you want send the workbooks by email ,you must enter the required information about the SMTP server use to send the e-mails in EPM tab options-->User options.

*SMTP Server Address
*Port number 
* Select the authentication type.
   - Anonymous
   -Basic or NTML
*Enable SSL (if needed)





Security:

1.Edit Book and Distribution Templates-This permits a user maintain the templates.
2.Use Offline Distribution- This permits a user to execute the Distribution wizard .
3. Use Offline Collection -This permits a user to execute the collection Wizard

SAP EPM / BPC 10.0 Consolidation (User Authorization)

SAP BPC 10.0 Consolidation (User  Authorization)

1.                   BPC User Creation

1.1                User Roles in BW as Template

BW Roles are mandatory for BPC User and the below roles are required to access the BPC Web and BPC for excel.

This user has name “UTEMP” in the BPC Development System copy this user to the business user before assigning any BPC access to the User.

1.2               BPC Security Setup

BPC Security is made up of the below components that are needed to be configured for User Access.

BPC Home Page -> Planning and ConsolidationAdministration -> Security:

Teams:

Consolidation User – End User of Entity

Consol Manager – End User of Sub Group / Group

Consol Reporting – Reporting User

ADMIN – Full Access

Task Profile:

Based on the grouping of Users Team, task profile has been created for the Users :

·               Consolidation User – End User of Entity

·               Consol Manager – End User of Sub Group / Group

·               Consol Reporting – Reporting User

·               Corporate User – Corporate Finanace User group

·               Security Admin – Business User SAP support

·               Full TaskProfile – system default

·               PrimaryAdmin – system default

·               SecondaryAdmin – system default

        SystemAdmin – system

Data Access Profile:

For each Sub Group / Group Data Access profile would be created at the CONSOSCOPE  level and ENTITY level.

Data Access Profile details.

This specifies the list of entity that this profile can access.

Data Access Profile details.

This specifies the list of entity that this profile can access.

1.                   Maintain Users in BPC

2.1                Assign User to Team / Task Profile

Users -> Add (After Creating BW User)

List of Users is displayed and we select the user to add:

Click Next.

Assign Team for user

Click Next to finish creating user:

2.2                Assign User to Data Access Profile

Users -> Click on User  created -> Tab Data Access Profile -> Select the Group / Sub Group that user has to be assigned to

Then Run on console by using user level  ,where creation will be success or not..!If we will follow on above step it will Success on User authorization .