Clarity

  • 1.  PPM Data from DWH Report Connection (SaaS)

    Posted 06-17-2016 12:19 PM

    I recall at CA world there is way to access PPM data(Tables and Attributes) from within the DWH through a DBLINK.

    Is there a code sample for this for Saas customers?  Or can a subreport be created and access the PPM data?  Any details or direction would be great.

     

    Thanks,



  • 2.  Re: PPM Data from DWH Report Connection (SaaS)
    Best Answer

    Broadcom Employee
    Posted 06-27-2016 03:31 PM

    Hi Austin,

     

    The PPM data can be queried with SQL queries as follows (example):

    SELECT count(1) FROM SRM_RESOURCES@PPMDBLINK

     

    PPMDBLINK will be the name of the database link used for your environment. To find out the exact dblink name you have in your environment, please get in touch with our SaaS support.

     

    Creating dependent reports based on two different datasources such as main report on DWH BEAN and subreport on PPM BEAN is not recommended.

     

    Better option for you would be to actually create your report, both main and subreport, based on the PPM BEAN. This may be a good option for the performance too, so please test this out as compared with the same with a dblink.

     

    Hope this helps -Nika



  • 3.  Re: PPM Data from DWH Report Connection (SaaS)

    Posted 06-27-2016 04:07 PM

    Much appreciated. I'll contact Support for clarification.  Pulling in a few attributes to the exiting report is much better than re-writing it in this particular instance.  Hopefully in the next release the link can be removed and attributes pulled from the DWH.

     

    Thanks,

     

    Austin