AnsweredAssumed Answered

On demand: CA does not supply access to DWH Schema

Question asked by EG27 on Jul 9, 2015
Latest reply on Jul 13, 2015 by Suman Pramanik

We are on-demand and using 14.2.

We did requested the SQL Connections credentials to access the DWH so we can build reports. 

We have been supplied with this answer:

"As of now we do not provide the read only access for the DWH schema, as this is not a part of the CA service. If you want to take this further you could kindly enter an improvement or idea via the CA communities which the Product Support team can then follow up with the Product Management teams.

Please let us know if you have any queries so that we can assist you further."


I would like to know:

     if someone from the community using OD did get the credentials to Query the DWH?

     if you don't have the access and are developing reports using the DWH, how can you build the query for your report?

      (I know we can punch-in the query in Jaspersoft Studio and publish the report, than log in Clarity and test... but this will take forever to tune the queries...)


Right now, since I have access to the CA PPM BEAN and not the CA PPM DWH BEAN, I am building reports and dashboard using the CA PPM BEAN which goes against the objective of having the DHW.


If someone from CA read this and can help me our case # is 00135513