1 2 Previous Next 20 Replies Latest reply: Oct 1, 2012 5:19 AM by user10569054 RSS

    Report Category not Appearing in Report Definition

    user10569054
      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
          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
            Thanks.
            Now i'm able to see the Categories i've created.
            • 3. Re: Report Category not Appearing in Report Definition
              user10569054
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  Does this answer your question?
                                  • 14. Re: Report Category not Appearing in Report Definition
                                    user10569054
                                    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