Clarity

Expand all | Collapse all

Jaspersoft Report Security Joins

Jump to Best Answer
  • 1.  Jaspersoft Report Security Joins

    Posted 12-28-2015 03:38 PM

    Hi all. I thought I'd start the question here where we all can see the answers instead of opening a ticket where only I can see the answer.

     

    I love the Jaspersoft Report Development Guide. I look forward to seeing this content rolled into the product wiki.

     

    Page 39 provides a sample data warehouse security join for Investments.

    Q 1: What is the 'CA Approved' data warehouse security join for Resources off of dwh_res_security?

    Q 2: If building against the CA PPM Bean, what are the recommended transactional database Investment and Resource Security joins (dwh_inv_security_v and dwh_res_security_v)?

     

    If this already exists in documentation, my apologies I've tried - please point me at it. If not, this is a great spot to get this formalized to keep us moving forward while this makes its way back into the documentation.

     

    Thanks!



  • 2.  Re: Jaspersoft Report Security Joins
    Best Answer

    Posted 12-29-2015 10:39 AM

    From the Resource Skills report, the following is the CA PPM Bean Resource Security clause. This has tested out successfully. For my CA PPM Bean Resource report I'm going to move forward with this until I see any official documentation telling me otherwise.

     

    AND  ((EXISTS (SELECT user_id
                   FROM   cmn_sec_assgnd_obj_perm_r_v
                   WHERE  object_type = 'RECORD'
                   AND    object_code = 'PRJ_RESOURCE'
                   AND    permission_code = 'ResourceViewManagement'
                   AND    component_code = 'PRJ' 
                   AND    user_uid = $P{ppmUser}))
           OR
          (EXISTS (SELECT object_instance_id
                   FROM   cmn_sec_assgnd_obj_perm_v
                   WHERE  object_instance_id = r.id
                   AND    object_type = 'RECORD'
                   AND    object_code = 'PRJ_RESOURCE'
                   AND    permission_code = 'ResourceViewManagement'
                   AND    component_code = 'PRJ'
                   AND    user_uid = $P{ppmUser})))
    


  • 3.  Re: Jaspersoft Report Security Joins

    Posted 03-10-2016 02:10 PM

    The above link does not work to get the guide



  • 4.  Re: Jaspersoft Report Security Joins

    Posted 03-10-2016 09:12 PM
      |   view attached

    Hey Mike. Here's the guide that was formerly linked above. It's possible / I hope that the content has been wrapped into the wiki. I'll defer to others on this - please let us know if this is the case along with the new link and I'll delete the PDF attachment to this post.

     

    HTH!

    Rob