Skip to Content
0

BPC 10 Package User

Feb 23 at 12:15 PM

54

avatar image

We have a number of packages schedule in Production that were created & scheduled by a consultant and execute using their username in BW. I want to switch these to use a generic batch user so I can remove the consultanst ID - how do I do this as I cannot see anything in the 'Edit SChedule'box to allow me to do so.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Feb 23 at 01:06 PM
0

"were created & scheduled by a consultant and execute using their username in BW" - bad idea!

Stop and delete schedule!

Schedule again under correct user

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I would do that, but the batch user would be something like ALEREMOTE as I would use for BW jobs but I wouldn't be able to log on as ALEREMOTE.

Is there no way to change the user like you can do for example on a job in ECC, or a table I can edit that holds the schedule informmation where I can change the user?

0
Vadim Kalinin Feb 23 at 01:33 PM
0

"Is there no way to change the user like you can do for example on a job in ECC, or a table I can edit that holds the schedule informmation where I can change the user?" - Do you really want issues? Packages use some BPC authorizations!

To schedule job in BPC you need a valid BPC user. Login and perform required scheduling!

Show 7 Share
10 |10000 characters needed characters left characters exceeded

The batch user will have SAP_ALL so there should be no auth issues - that's the point of switching to a batch user so it has no auth problems, or getting locked/deleted after x months etc.

0

Looks like you don't understand that BPC security is not related to general SAP security (read about data access profiles in BPC).

SAP_ALL for batch jobs? Have you recently talk with auditor?

0
0

Irrespective of the user & the authorisations it might / might not have. Is it possible to change the user on an existing scheduled package?

If I create it with my user (for example), then I am no better off than I am now as my user requires the password to be changed periodically and if I leave the company the user will get removed & then the jobs will stop.

0

"Irrespective of the user & the authorisations it might / might not have. Is it possible to change the user on an existing scheduled package?" - No!

"If I create it with my user (for example), then I am no better off than I am now as my user requires the password to be changed periodically and if I leave the company the user will get removed & then the jobs will stop." - Why with your user id???

Create a new user in SAP and add this user to BPC users. In BPC add required task profile and data access profile. Login with this special user in EPM add-in and schedule package.

0

Thanks for the reply.

I want to use existing batch users from BW, be it ALEREMOTE, BWREMOTE etc. rather than create another system user. I can happily add any missing authorisations to them but wanted to know if at a table level (as BPC doesn't seem to have the functionality) I can change the user without having to re-create all the various schedules in the EPM front end.

I have found table UJD_PACKAGE_PLAN which looks like it holds the schedules with userid but I am not 100% this is the one to edit the entries in.

It would appear the answer is no, & re-creation is the only option.

0

"I can happily add any missing authorisations to them" - please read about BPC security: task profiles and data access profiles. User has to be valid BPC user! https://help.sap.com/http.svc/login?time=1519396932692&url=%2Fhttp.svc%2Frc%2F4af9eadc60d64dafb73f6a7f9f8b7c41%2F10.0.23.0%2Fen-US%2FBPC100NW_Security_011000358700000470182011E.pdf

"I have found table UJD_PACKAGE_PLAN" - there are number of other tables... please don't change manually!

0
Leila Lappin
Feb 23 at 05:32 PM
0

Hello,

I am curious, if you do SM37 and filter with BPC_* for the job name, what user do you see? Do you see the consultant's user ID or BPC service user ID?

Best Regards,

Leila Lappin

Show 4 Share
10 |10000 characters needed characters left characters exceeded

In SM37 it will run under BPC_SERVICE, but we are talking about BPC scheduler...

0

Ah, okay I thought it was scheduled from the BW side.

0

If you are scheduling BPC DM package from BW using UJD_TEST_PACKAGE you have to provide a valid BPC user ID anyway :)

0

UJD_TEST_PACKAGE is a BPC program that is for the convenience of BPC users but I don't think that is the only way to schedule a job. SM37 has the options to directly schedule a job. I had a case just two weeks ago regarding some scheduled job not behaving and when I checked the normal places like SLG1 and SM21 I could not find any messages with the dialog user's user ID. When I enquired the customer said the reason was the jobs were scheduled.

0