BPC 10 Package User

[steveg789]

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.

[damovand]

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

[former_member186338]

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

[damovand]

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

[former_member186338]

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

[damovand]

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.

[former_member186338]

"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!

[steveg789]

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.

[former_member186338]

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?

[former_member186338]

P.S. Just read the fresh question and the mentioned note:

https://answers.sap.com/questions/441233/when-append-data-getting-error-organization-member.html

[steveg789]

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.

[former_member186338]

"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.

[steveg789]

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.

[former_member186338]

"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%2F4af9eadc60d64dafb73f6a...

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

[former_member186338]

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

Stop and delete schedule!

Schedule again under correct user

[steveg789]

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?