how to use the bpc mass user management tool sap business

68
1 How To Use the BPC Mass User Management Tool SAP Business Planning and Consolidation 10.1 NW Embedded Version

Upload: others

Post on 02-Oct-2021

7 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: How To Use the BPC Mass User Management Tool SAP Business

1

How To Use the BPC Mass User Management Tool

SAP Business Planning and Consolidation 10.1 NW

Embedded Version

Page 2: How To Use the BPC Mass User Management Tool SAP Business

2

How To Use the BPC Mass User

Management Tool in BPC 10.1 NW

Embedded Version

Applies to:SAP BusinessObjects Planning & Consolidation 10.1, version for SAP NetWeaver. Embedded Version.

For more information, visit the Enterprise Performance Management homepage.

SummaryThis guide will introduce the BPC User Management Tool for version 10.1, and all of its associated functionsand features.

Page 3: How To Use the BPC Mass User Management Tool SAP Business

3

Table of ContentsBusiness Scenario .............................................................................................................................................. 3Background Information ...................................................................................................................................... 3Prerequisites ....................................................................................................................................................... 3

Step-by-Step Procedure ..................................................................................................................................... 4Exporting Users ............................................................................................................................................... 4Importing Users ............................................................................................................................................... 5Exporting Teams ............................................................................................................................................. 7Importing Teams ............................................................................................................................................. 9Exporting Team Assignments ....................................................................................................................... 11Importing Team Assignments ....................................................................................................................... 12Exporting Task Profiles ................................................................................................................................. 14Importing Task Profiles ................................................................................................................................. 16Exporting Data Access Profiles ..................................................................................................................... 19Importing Data Access Profiles ..................................................................................................................... 21Exporting Task Profile Assignments ............................................................................................................. 24Importing Task Profile Assignments ............................................................................................................. 25Exporting Data Access Profile Assignments ................................................................................................. 29Importing Data Access Profile Assignments ................................................................................................. 30

Transport Files .................................................................................................................................................. 33Related Content ................................................................................................................................................ 34Copyright........................................................................................................................................................... 35

Page 4: How To Use the BPC Mass User Management Tool SAP Business

4

Page 5: How To Use the BPC Mass User Management Tool SAP Business

5

Business ScenarioIn this guide, we will demonstrate how to use a custom program (delivered within this How To Guide) which willallow you to do mass maintenance of BPC 10.1 security objects. These objects include users, teams, teamassignments, task profiles, task profile assignments, data access profiles (formerly known as Member AccessProfiles), and finally, data access profile assignments. This custom program calls the BPC user managementAPIs, (the same APIs used by the BPC Admin Console), to create or update the associated security objects.The program described in this guide simply provides a friendly, easy to use interface which allows the user toexport and import „csv files containing all of the relevant data in which the security objects can be createdfrom.

Background InformationMost BPC security objects are not transportable using the BPC Transport Framework. In some cases, it can bereally cumbersome to re-create these objects throughout the landscape. This custom program allows theuser to export as well as import all BPC security objects. The export/import functions use comma, tab, or pipedelimited text files as the data transfer medium. Example files have been supplied with this guide. While theuser can simply create files from scratch and upload them into the system, the real power of this program isthat it allows the user to export these security objects from an Environment, and then import them into anotherEnvironment in the same system, or in a remote system, essentially moving these objects across thelandscape without using the BPC transports framework.

PrerequisitesRequired/recommended expertise or prior knowledge

SAP BusinessObjects Planning and Consolidation 10.1, version for SAP NetWeaver.

Access to SAP NetWeaver transaction codes: SE38

Additional Documentation

Other EPM How-To Guides

https://wiki.scn.sap.com/wiki/display/BPX/Enterprise+Performance+Management+%28EPM%29+How-to+Guides

Page 6: How To Use the BPC Mass User Management Tool SAP Business

6

Page 7: How To Use the BPC Mass User Management Tool SAP Business

7

Step-by-Step ProcedureThis How-To guide contains transport request files, K900064.A4H and R900064.A4H (see section “TransportFiles”). This transport request contains all the NetWeaver objects that are required to complete this How-ToGuide:

Programs ZUJE_MASS_USER_MGMT BPC Mass User Management Tool V2

As the process of importing a transport request is not covered here, it is suggested that you seek assistancefrom your basis administrator in order to have this transport request imported into your system.

Note: These objects must be imported into your system before continuing any further.

To begin using the tool, log on to the backend NetWeaver system via SAPGui, and run theZUJE_MASS_USER_MGMT program from transaction code SE38, by entering the program name and clickingthe “Execute“ button.

Exporting Users1. From the initial screen, select the appropriate radio button for “Export Data“.

Page 8: How To Use the BPC Mass User Management Tool SAP Business

8

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. (Note: This file path must exist on your end user machine where you are running

Page 9: How To Use the BPC Mass User Management Tool SAP Business

9

SAPgui from.) Finally, select the delimiter value for the file. Comma, pipe, and tab delimiters aresupported.

3. Next, select the appropriate radio button for “Export Users”.

4. Finally, click the “Execute” button to start the export process.

5. The output file is then generated.

Page 10: How To Use the BPC Mass User Management Tool SAP Business

10

Importing Users

1. From the initial screen, select the appropriate radio button for “Import Data“.

Page 11: How To Use the BPC Mass User Management Tool SAP Business

11

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, select the delimiter value for the file.

Note: The file must contain the following structure in a comma delimited format:

USER_ID User ID

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

BROWNJ

SMITHJ

Note: These users must already exist in the NetWeaver system. The action of importing users only supports addingexisting users to a BPC environment. It does not support the actual creation of the users in the NetWeaver system.

3. Select the appropriate radio button for “Import Users”.

Page 12: How To Use the BPC Mass User Management Tool SAP Business

12

4. To start the process, click the “Execute” button from the application toolbar.

Page 13: How To Use the BPC Mass User Management Tool SAP Business

13

5. The new users are then created for the Environment and a message screen is displayed. This screenwill show all associated success and failure messages.

6. The new users can now be seen from the BPC Administration tab.

...

Exporting Teams

1. From the initial screen, select the appropriate radio button for “Export Data“.

Page 14: How To Use the BPC Mass User Management Tool SAP Business

14

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

Page 15: How To Use the BPC Mass User Management Tool SAP Business

15

3. Next, select the appropriate radio button for “Export Teams”.

4. Finally, click the “Execute” button to start the export process.

5. The output file is then generated.

Page 16: How To Use the BPC Mass User Management Tool SAP Business

16

Page 17: How To Use the BPC Mass User Management Tool SAP Business

17

Importing Teams

1. From the initial screen, select the appropriate radio button for “Import Data“.

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the file delimiter.

Note: The file must contain the following structure in a comma delimited format:

TEAM_ID Team IDDESCRIPTION Description of the Team

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

Page 18: How To Use the BPC Mass User Management Tool SAP Business

18

ADMINTEAM,Administration Team

ACCTEAM,Accounting Team

3. Select the appropriate radio button for “Import Teams”.

Page 19: How To Use the BPC Mass User Management Tool SAP Business

19

4. To start the process, click the “Execute” button from the application toolbar.

5. The new users are then created for the Environment and a message screen is displayed. This screenwill show all associated success and failure messages.

6. The new teams can now be seen from the BPC Administration tab.

Page 20: How To Use the BPC Mass User Management Tool SAP Business

20

Page 21: How To Use the BPC Mass User Management Tool SAP Business

21

Exporting Team Assignments

1. From the initial screen, select the appropriate radio button for “Export Data“.

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

3. Next, select the appropriate radio button for “Export Team Assignments”.

Page 22: How To Use the BPC Mass User Management Tool SAP Business

22

4. Finally, click the “Execute” button to start the export process.

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC -uac.sap.com

© 2011 SAP AG 11

Page 23: How To Use the BPC Mass User Management Tool SAP Business

23

5. The output file is then generated.

...

Importing Team Assignments

1. From the initial screen, select the appropriate radio button for “Import Data“.

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the delimiter.

Page 24: How To Use the BPC Mass User Management Tool SAP Business

24

Note: The file must contain the following structure in a comma delimited format:

USER_ID User IDTEAM_ID Team IDTEAM_LEADER Flag User ID as Team Leader(Optional)

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

SMITHJ,ADMINTEAM,X

BROWNJ,ACCTEAM,

Page 25: How To Use the BPC Mass User Management Tool SAP Business

25

3. Select the appropriate radio button for “Import Team Assignments”.

4. To start the process, click the “Execute” button from the application toolbar.

5. The new team user assignments are then updated for the Environment and a message screen isdisplayed. This screen will show all associated success and failure messages.

Page 26: How To Use the BPC Mass User Management Tool SAP Business

26

6. The new team assignments can now be seen from the BPC Administration tab. Notice the number ofusers assigned for each team is now 1.

Page 27: How To Use the BPC Mass User Management Tool SAP Business

27

7. You may further investigate the assigned users by selecting the team and clicking “Edit”. The followingscreen shows the assigned user. Notice that the team leader flag is also checked.

Exporting Task Profiles

1. From the initial screen, select the appropriate radio button for “Export Data“.

Page 28: How To Use the BPC Mass User Management Tool SAP Business

28

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

Page 29: How To Use the BPC Mass User Management Tool SAP Business

29

3. Next, select the appropriate radio button for “Export Task Profiles”.

4. Finally, click the “Execute” button to start the export process.

5. The output file is then generated.

Page 30: How To Use the BPC Mass User Management Tool SAP Business

30

Page 31: How To Use the BPC Mass User Management Tool SAP Business

31

Importing Task Profiles

1. From the initial screen, select the appropriate radio button for “Import Data“.

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the delimiter.

Note: The file must contain the following structure in a comma delimited format. Since there aremultiple sets of data associated with task profiles, the use of record level identifiers is leveraged here.Below are the record identifiers and their descriptions.

Record Identifiers

H Defines the header level data recordK Defines the Tasks assigned to the Task ProfileT Defines the Teams assigned to the Task Profile(Optional)U Defines the Users assigned to the Task Profile(Optional)

Page 32: How To Use the BPC Mass User Management Tool SAP Business

32

“H” Record Structure

PROFILE_ID Task Profile IDDESCRIPTION Task Profile Description

“K” Record Structure

PROFILE_ID Task Profile IDTASK_ID Task ID ( TASK_IDs found in tables UJE_TASK and UJE_TASKT )

Page 33: How To Use the BPC Mass User Management Tool SAP Business

33

“T” Record Structure

PROFILE_ID Task Profile ID

TEAM_ID Team ID

“U” Record Structure

PROFILE_ID Task Profile IDUSER_ID User ID

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

H,COMX_ADMIN,CompanyX Administrator Task

K,COMX_ADMIN,P0006

K,COMX_ADMIN,P0008

K,COMX_ADMIN,P0011

K,COMX_ADMIN,P0012

K,COMX_ADMIN,P0021

K,COMX_ADMIN,P0022

K,COMX_ADMIN,P0024

K,COMX_ADMIN,P0025

K,COMX_ADMIN,P0027

K,COMX_ADMIN,P0028

K,COMX_ADMIN,P0043

K,COMX_ADMIN,P0055

K,COMX_ADMIN,P0057

T,COMX_ADMIN,ADMINTEAM

U,COMX_ADMIN,SMITHJ

H,NA_MGR,CompanyX North America Manager Task

K,NA_MGR,P0006

K,NA_MGR,P0008

K,NA_MGR,P0057

T,NA_MGR,ACCTEAM

U,NA_MGR,BROWNJ

Page 34: How To Use the BPC Mass User Management Tool SAP Business

34

Page 35: How To Use the BPC Mass User Management Tool SAP Business

35

3. Select the appropriate radio button for “Import Task Profiles”.

4. To start the process, click the “Execute” button from the application toolbar.

5. The new task profiles are then created for the Environment and a message screen is displayed. Thisscreen will show all associated success and failure messages.

Page 36: How To Use the BPC Mass User Management Tool SAP Business

36

6. The new task profiles can now be seen from the BPC Administration tab. Notice that there are teamsand users assigned to the task profiles.

Page 37: How To Use the BPC Mass User Management Tool SAP Business

37

7. Select one of the task profiles and click the “Edit” button. Notice the tasks which are assigned to theprofile.

Exporting Data Access Profiles

1. From the initial screen, select the appropriate radio button for “Export Data“.

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

Page 38: How To Use the BPC Mass User Management Tool SAP Business

38

Page 39: How To Use the BPC Mass User Management Tool SAP Business

39

3. Next, select the appropriate radio button for “Export Data Access Profiles”.

4. Finally, click the “Execute” button to start the export process.

5. The output file is then generated.

Page 40: How To Use the BPC Mass User Management Tool SAP Business

40

Page 41: How To Use the BPC Mass User Management Tool SAP Business

41

Importing Data Access Profiles

1. From the initial screen, select the appropriate radio button for “Import Data“.

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the delimiter.

Note: The file must contain the following structure in a comma delimited format. Since there aremultiple sets of data associated with data access profiles, the use of record level identifiers isleveraged here. Below are the record identifiers and their descriptions.

Record Identifiers

H Defines the header level data recordM Defines the Members assigned to the Data Access ProfileT Defines the Teams assigned to the Data Access (Optional)U Defines the Users assigned to the Data Access (Optional)

Page 42: How To Use the BPC Mass User Management Tool SAP Business

42

“H” Record Structure

PROFILE_ID Data Access Profile IDDESCRIPTION Data Access Profile Description

“M” Record Structure

PROFILE_ID Data Access Profile IDDIMENSION DimensionAPPLICATION_ID Application ID

Page 43: How To Use the BPC Mass User Management Tool SAP Business

43

MEMBER Assigned Member( Can contain [ALL])READ/WRITE Read and/or Write Access(R=Read, W=Write, D=Deny)

“T” Record Structure

PROFILE_ID Data Access Profile IDTEAM_ID Team ID

“U” Record Structure

PROFILE_ID Data Access Profile IDUSER_ID User ID

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

H,COMX_ADMIN_MAP,CompanyX Administrator MAP

M,COMX_ADMIN_MAP,CATEGORY,Planning,[ALL],R

M,COMX_ADMIN_MAP,ENTITY,Planning,[ALL],R

M,COMX_ADMIN_MAP,CATEGORY,Rates,[ALL],D

M,COMX_ADMIN_MAP,R_ENTITY,Rates,[ALL],D

T,COMX_ADMIN_MAP,ADMINTEAM

U,COMX_ADMIN_MAP,SMITHJ

H,NA_MGR_MAP,North America Manager MAP

M,NA_MGR_MAP,CATEGORY,Planning,Actual,W

M,NA_MGR_MAP,ENTITY,Planning,CA,W

M,NA_MGR_MAP,ENTITY,Planning,US,W

M,NA_MGR_MAP,CATEGORY,Rates,[ALL],D

M,NA_MGR_MAP,R_ENTITY,Rates,[ALL],D

T,NA_MGR_MAP,ACCTEAM

U,NA_MGR_MAP,BROWNJ

Page 44: How To Use the BPC Mass User Management Tool SAP Business

44

Page 45: How To Use the BPC Mass User Management Tool SAP Business

45

3. Select the appropriate radio button for “Import Data Access Profiles”.

4. To start the process, click the “Execute” button from the application toolbar.

5. The new data access profiles are then created for the Environment and a message screen is displayed.This screen will show all associated success and failure messages.

Page 46: How To Use the BPC Mass User Management Tool SAP Business

46

6. The new data access profiles can now be seen from the BPC Admin Client. Also notice that teams andusers have been assigned to these new profiles.

Page 47: How To Use the BPC Mass User Management Tool SAP Business

47

7. Select one of the new data access profiles and click the “Edit” button. Then click on “Planning”. Noticethe rights have been assigned accordingly.

Exporting Task Profile Assignments

1. From the initial screen, select the appropriate radio button for “Export Data“.

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,

Page 48: How To Use the BPC Mass User Management Tool SAP Business

48

the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

Page 49: How To Use the BPC Mass User Management Tool SAP Business

49

3. Next, select the appropriate radio button for “Export Task Profile Assignments”.

4. Finally, click the “Execute” button to start the export process.

5. The output file is then generated.

Page 50: How To Use the BPC Mass User Management Tool SAP Business

50

Importing Task Profile Assignments

1. From the initial screen, select the appropriate radio button for “Import Data“.

Page 51: How To Use the BPC Mass User Management Tool SAP Business

51

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the delimiter.

Note: The file must contain the following structure in a comma delimited format. Since there are multiple sets of dataassociated with task profile assignments, the use of record level identifiers is leveraged here. You can assign botha user and a team to task profiles. Below are the record identifiers and their descriptions.

Record Identifiers

T Defines the Teams assigned to the Task Profile(Optional)

U Defines the Users assigned to the Task Profile(Optional)

“T” Record Structure

PROFILE_ID Task Profile IDTEAM_ID Team ID

“U” Record Structure

PROFILE_ID Task Profile IDUSER_ID User ID

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

U,COMX_ADMIN,SMITHJ

T,COMX_ADMIN,ADMINTEAM

Page 52: How To Use the BPC Mass User Management Tool SAP Business

52

U,NA_MGR,BROWNJ

T,NA_MGR,ACCTEAM

Page 53: How To Use the BPC Mass User Management Tool SAP Business

53

3. Select the appropriate radio button for “Import Task Profile Assignments”.

4. To start the process, click the “Execute” button from the application toolbar.

5. The new task profile assignments are then updated for the Environment and a message screen isdisplayed. This screen will show all associated success and failure messages.

Page 54: How To Use the BPC Mass User Management Tool SAP Business

54

6. The new task profile assignments can now be seen from the BPC Administration tab.

Page 55: How To Use the BPC Mass User Management Tool SAP Business

55

7. Click the “User” link from the left side, then select one of the users and click “Edit”.

8. Click the “Task Profiles” tab. Notice the task profile has been assigned to the user.

Page 56: How To Use the BPC Mass User Management Tool SAP Business

56

Page 57: How To Use the BPC Mass User Management Tool SAP Business

57

Exporting Data Access Profile Assignments

1. From the initial screen, select the appropriate radio button for “Export Data“.

2. Next, enter the name of the Environment which contains the data which is to be exported. In this guide,the ENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theexport file. Finally, specify the delimiter.

3. Next, select the appropriate radio button for “Export Data Access Profile Assignments”.

Page 58: How To Use the BPC Mass User Management Tool SAP Business

58

4. Finally, click the “Execute” button to start the export process.

Page 59: How To Use the BPC Mass User Management Tool SAP Business

59

5. The output file is then generated.

Importing Data Access Profile Assignments

1. From the initial screen, select the appropriate radio button for “Import Data“.

2. Next, enter the name of the Environment where you want to create the users. In this guide, theENV_TEST Environment will be used for all examples. Also, enter the file path and file name for theimport file. Finally, specify the delimiter.

Page 60: How To Use the BPC Mass User Management Tool SAP Business

60

Note: The file must contain the following structure in a comma delimited format. Since there are multiple sets of dataassociated with data access profile assignments, the use of record level identifiers is leveraged here. You canassign both a user and a team to data access profiles. Below are the record identifiers and their descriptions.

Record Identifiers

T Defines the Teams assigned to the Data Access Profile(Optional)U Defines the Users assigned to the Data Access Profile(Optional)

Page 61: How To Use the BPC Mass User Management Tool SAP Business

61

“T” Record Structure

PROFILE_ID Data Access Profile IDTEAM_ID Team ID

“U” Record Structure

PROFILE_ID Data Access Profile IDUSER_ID User ID

The file structure is exactly the same as what is generated by the export function. An example filemight look like the following:

U,NA_MGR_MAP,BROWNJ

T,NA_MGR_MAP,ACCTEAM

U,COMX_ADMIN_MAP,SMITHJ

T,COMX_ADMIN_MAP,ADMINTEAM

3. Select the appropriate radio button for “Import Data Access Profile Assignments”.

4. To start the process, click the “Execute” button from the application toolbar.

Page 62: How To Use the BPC Mass User Management Tool SAP Business

62

5. The new member access profile assignments are then updated for the Environment and a messagescreen is displayed. This screen will show all associated success and failure messages.

Page 63: How To Use the BPC Mass User Management Tool SAP Business

63

6. The new data access profile assignments can now be seen from the BPC Administration tab.

7. Click the “User” link from the left side, then select one of the users and click “Edit”.

8. Click the “Data Access Profiles” tab. Notice the task profile has been assigned to the user.

Page 64: How To Use the BPC Mass User Management Tool SAP Business

64

Page 65: How To Use the BPC Mass User Management Tool SAP Business

65

Transport FilesTransport files can be downloaded from the following link:

Transport Files :

https://wiki.scn.sap.com/wiki/download/attachments/444442161/TRANSPORTS_FILES.zip?api=v2

Page 66: How To Use the BPC Mass User Management Tool SAP Business

66

Page 67: How To Use the BPC Mass User Management Tool SAP Business

67

Page 68: How To Use the BPC Mass User Management Tool SAP Business

68