This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Oct 1, 2012 3:19 AM by user10569054 RSS

Report Category not Appearing in Report Definition

user10569054 Newbie
Currently Being Moderated
Hello There,
I've created 2-3 new Report Category. Now when i'm adding new value for Definition and in Report Properties, i'm trying to select my newly created Report Category, there is only one Category available i.e. All PeopleSoft User
. when i go to Report category it appears there but dont know why it is not appearing in Report Definition.

any clue?
Regards!!
  • 1. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Hi,

    The prompt on the category is an dynamic prompt that is used filled on runtime with view PSXPRPTCATF_DVW.

    This view has the following SQL:

    SELECT A.REPORT_CATEGORY_ID
    , A.DESCR
    , A.OBJECTOWNERID
    FROM PSXPRPTCAT A
    WHERE EXISTS (
    SELECT 'X'
    FROM PSXPRPTCATAUTH X
    WHERE A.REPORT_CATEGORY_ID = X.REPORT_CATEGORY_ID
    AND X.PSXP_READONLY = 'N'
    AND ((X.AUTHORIDTYPE = '2'
    AND X.AUTHORID = %OperatorId)
    OR (X.AUTHORIDTYPE = '3'
    AND X.AUTHORID IN (
    SELECT RL.ROLENAME
    FROM PSROLEUSER RL
    WHERE RL.ROLEUSER = %OperatorId))))

    Meaning:
    Readonly field on the Report Category page needs to be unchecked
    user has listed in type = user or user has role listed in type=role.

    So, if you do not see the report category you do not have a role that is specified for the Report Category.

    Hakan
  • 2. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    Thanks.
    Now i'm able to see the Categories i've created.
  • 3. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    I've created one query(Data source) and then added it to the report definition.
    In the Report Category, i've added the users,roles that will have access to the report. Then with one of the users in Report category, i search for the report it doesn't appear.
    All is set properly.
    Report Category created.
    user,role added to it.
    Created new Report defn. added data source(query(public/private)) to it.
    for data source generated XML format.
    And now can't see the report. Same thing is working ok in Dev.

    Any help will be highly appreciated.

    Regards!
  • 4. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Does your user have access to a query tree which contains the records used in your query data source?
    Also there a two permissionlists that give access to Bi Publisher components, XMLP Report Developer (PTPT2600), XMLP Power User (PTPT2500).
    See PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Setting Up BI Publisher > Assigning BIP Permissions to Users

    See also this chapter of PeopleBooks which describes the differt levels of security of BI Publisher
    PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Appendix: Securing BI Publisher
  • 5. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    your user have access to a query tree which contains the records
    ???
    The user who is using this report is a normal user. In the report category & definition i've already added that user.
    Also created a role containing (PTPT2500) permission list (but not (PTPT2600)) and assigned to the user who is using it.

    Regards!
  • 6. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    when a BIP report is configured with a query data source, the PSQuery security also kicks in. See if there is a difference in the query tree access of the differt users.
  • 7. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    One thing was missing & that i got to know is for the permission list, assigned to user, has Access Group Permissions in the query tab there i added the query tree tables.
    i think that is what you were mentioning in your previous reply.
    But still not able to find the solution.

    Regards!
  • 8. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    lets take a few steps back
    >
    you said: And now can't see the report. Same thing is working ok in Dev.
    >

    Where can you not see the report, please provide menu path or component.
  • 9. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    Basically the Development is not available now.It was working there.
    I've created one role, say QUERY_MNGR, having permission to the page Query Report Viewer . Now user can see this Query Report Viewer in the self service menu. The Permission list also contains the tables(Access Group Permissions) in query tab.as stated above in reply.
    This is all for one customised report that i'm trying now.
    But when i try to search report name from Query Report Viewer in from my self service menu, i can't see the report i created,Actually nothing.

    Regards!
  • 10. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    This is in fact the main sql behind the search button of the Query Report Viewer Page

    SELECT A.REPORT_DEFN_ID,
    A.DESCR,
    A.DS_TYPE,
    A.DS_ID,
    A.OPRID,
    A.PSXPDSOWNER,
    A.PT_TEMPLATE_TYPE,
    A.REPORT_CATEGORY_ID,
    A.OBJECTOWNERID,
    A.PT_REPORT_STATUS,
    A.BURST_FIELDNAME
    FROM PSXPRPTSRCH_VW A
    WHERE A.OPRID IN (' ', %OperatorID)
    AND EXISTS
    (SELECT 'X'
    FROM PSXPRPTCATAUTH X
    WHERE A.REPORT_CATEGORY_ID = X.REPORT_CATEGORY_ID
    AND ((X.AUTHORIDTYPE = '2'
    AND X.AUTHORID =%OperatorID)
    OR (X.AUTHORIDTYPE = '3'
    AND X.AUTHORID IN
    (SELECT RL.ROLENAME FROM PSROLEUSER RL WHERE RL.ROLEUSER = %OperatorID
    )))
    );

    After this main sql it is checked if user has access to the query behind the datasource that i used for the report.

    This means:
    You need to have access to one of the roles defined in the ReportCategory or defined as user here and you need to have access to the query.
    Assuming you comply the first criteria, see if your user can access the query, again query can be private or query tree security.

    Hakan
  • 11. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    Thanks for the reply.
    First about the SQL you posted.

    The view PSXPRPTSRCH_VW only satisfies one row with OPRID PS.The query that created and kept it Private.
    for normal user i can not allow to create query.
    and the another two inner SQLs, PSXPRPTCATAUTH and PSROLEUSER does return the role i defined and the normal user now who wants to see the report.

    So failing to find my userid(who wants to see the report) in first view itself fails the result.
    Apart from above, report defn. already have users,roles who wants to see the report.

    Regards!
  • 12. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    PSXPRPTSRCH_VW
    Above view having 2 tables.. PSXPRPTDEFN.. Report definition and PSXPDATASRC .. Data source(I think).
    The view taking Operid in where clause...and that seems to be query creator. Of course, a normal user can not be allowed to do this.

    Regards!
  • 13. Re: Report Category not Appearing in Report Definition
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Does this answer your question?
  • 14. Re: Report Category not Appearing in Report Definition
    user10569054 Newbie
    Currently Being Moderated
    Thanks for all the information provided.
    But I'm still not able to see my report. Still trying where I'm missing out?
    PS setting sucks..Really... :(
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points