Clarity

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,

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

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