Home > PS Admin > Report Distribution – Report Manager

Report Distribution – Report Manager

When we schedule a processes/Report to run by loggin in as say, VP1, then to see the output/report you have to login with the same User Id VP1. If the requirement is that another user need to see the same output/report, without using VP1 user id, then we need to do report distribution and give the user access to report manager so the user can view other’s reports. One way of achieving this as given below.

  • Add the following roles to user
    • ReportDistAdmin or ReportSuperUser(See the Note below).
    • Any role containing permission List – CPPT1040 (gives access to Report manager) or similar one.
  • To all the processes/reports that user needs to have access, add the userid to distribution list of that processe/report.
    • Go to the process/report run control page
    • Slect run control Id
    • Click run
    • Click ‘distribution’ link for the process/report.
    • Select either a user and enter his User Id.
    • You have to submit the process/report, once for the distribution data you have entered to save.
  • Submit the process/report for testing.
  • Now if the user logs in and go to  Administration tab in Report Manager, he could see the process/reports and link to see the output/report. User can see the output/report using process monitor also.

 Note: The difference between the administrator (ReportDistAdmin) and super user (ReportSuperUser) roles is that the administrator role can access and update any report in the Report Manager. The super user role can  update only reports that they are authorized to view.

Report Manager related other blog entries are given below:

  1. HH
    June 3, 2008 at 5:43 am

    Nice post.
    Is it possible to do away with submitting ? Which table is this information stored ?

    In production,it will not always be possible to submit a process.

    We might have to do it in a dev env ad move the run control info to production.

  2. naveen kumar
    May 18, 2009 at 5:44 pm

    we have the similar issue, we have setup a process scheduler in unix machine and another for NT on windows, they are configured across two webservers [load balancer]. we have issues with report distribution. consider we have the domain has xyz-12@xyz.com, on two servers abc1 and abc2. now what should i give in report distribution setup. cos when i give abc1 or abc2 i am able to configure and post but when i give xyz-12@xyz.com i am unable to post – geting http 900 response.

  3. Srinivas
    October 1, 2009 at 6:00 pm

    Unable to view reports older than 7 days in >Report Manager

  4. balaglobal
    October 1, 2009 at 6:14 pm

    Please check your Retention Days, PeopleTools > Process Scheduler > System settings(Process System tab). I think your Retention Days is set to 7 days, hence you see only last 7 days reports. If you need more you need change the rentention Days and bounce your process scheduler server.


    • Srinivas
      October 1, 2009 at 7:25 pm

      Thanks much Bala, its working now.

  5. Srinivas
    October 16, 2009 at 1:41 pm

    Hi, I have to print Expense Cover Sheet for one my employee.
    Navigation: Employee Self Service > Travel and Expenses > Capmark Expense Cover Sheet

    I keyed in Report ID: XXXXXX, but no values were returned and also I have quried the back end tables and found the report id. Here question is why I am not able to see his report id at Expense Cover Sheet Page (Find an Existing Value). Appreciate suggestions in this regard.

  6. balaglobal
    October 16, 2009 at 2:17 pm

    I really did not understand the problem. Why do you need to key in report id? It should show up when you hit ‘Run’ botton right? If you are not seeing the report after you hit the ‘Run’ button, then check the component Id and process group for this report in process defintion pages.

  7. Srinivas
    October 16, 2009 at 4:04 pm

    All you need is grant security as follows:
    Main Menu > Travel and Expenses > Manage Expenses Security >Authorize Expense Users and input emplid at Authorize Expense Users page and add Authorized User ID.
    Entering new UserIDs on this page will give those users the ability to enter
    expense transactions on behalf of the employee.

  8. Srinivas
    October 16, 2009 at 5:02 pm

    Thanks much for your response in Expenses issues. Happy Diwali Bala

  9. Srinivas
    October 19, 2009 at 7:49 pm

    I have changed Retention Days from 7 to 30days.PeopleTools > Process Scheduler > System settings(Process System tab).we ran report on 12th and that did not show on report repository still. The report that we ran on 13th is currently showing. We changed to 30days, but we did not bounce the scheduler. Is scheduler bounce is required. Please advise.

  10. balaglobal
    October 19, 2009 at 9:32 pm

    Yes, you need to bounce the Process Scheduler server for the setting to take effect.

  11. Srinivas
    October 26, 2009 at 11:40 am

    need help bypassing combo edit for account and exaple 130000 for AP journals, currently it is requiring oper unit, dept and location and we want it set up like the account example 310000 that by passes this combo edit. Appreciate your help in this.

  12. itsme
    November 2, 2009 at 8:31 pm

    we run some reports for HR module and found that user(through which we genrally run the process) has roles set as ReportDistAdmin. If we dont add this user in report distribution, after run in some reports its deleting distribution list wjile for some reports its working fine….
    please advice…

  13. balaglobal
    November 2, 2009 at 10:43 pm

    I did not understand the problem, please elaborate.

    • itsme
      November 3, 2009 at 8:55 am

      i am running some reports with user id X1. in different reports we have defined different user and roles but not X1. after running reports with user id X1….in some reports distribution list got deleted and X1 inserted and while some reports were ok.

  14. Srinivas
    November 6, 2009 at 4:00 pm

    has anybody knows 1099 process and while testing what should we need to observe.

  15. Sekhar
    December 1, 2009 at 4:20 am

    Hi Bala – Couple of quick questions/clarifications on the Report Manager.

    1. Users’ folders are created outside of report repository and each user will have a seperate folder. Am I right?
    2. When I set purge reports after x days, reports will be be physically deleted from users’ folders. Is this correct? However if I archive them how does PS handle that in terms of folder structure.
    3. Is there anyway to set different # of days for archive/purge reports or is this a global setting?

    Thanks in advance.

  16. balaglobal
    December 1, 2009 at 2:20 pm

    1. The Report folders are not automatically created for each user. You need to create Report folders at PeopleTools > Process Schedulder > System Settings > Report Folders Administration (tab).
    2. Report folders are more of logical, so purrging basically deletes it from report repository. Folder is just a row of data in a table which reference to report in report repository. If you archive the reports, the folders will loose significance. Here is what Peoplebooks says:
    Unlike the Report Manager – Administration page, the Report Manager – Explorer and Report Manager – List pages list reports when both of the following events occur:

    a. The Distribution Agent has successfully posted the report to the report repository. When the report has posted, the Distribution Agent sends a message to have an entry added to the report folder table for the new report.
    b. The local message node has received the message that was sent by the Distribution Agent by adding an entry for the report in the report folder table.

    New reports that have been scheduled or are in the process of being posted to the report repository are viewed only through the Report Manager – Administration page.
    Note. Folders that have been deleted remain active until all reports have been purged from them. However, new reports cannot be added to a deleted folder.

    3. It is the global setting.

  1. September 20, 2008 at 1:41 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: