How can we enable the 'View SQL Query' button in the Ad Hoc Editor in Advanced Reporting

book

Article ID: 32755

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction



Sometimes, when creating Ad Hoc views via Advance Reporting, we want to take at look at the query being created. We see that the button 'View SQL Query' is shown in the Ad Hoc Editor, but that it's disabled by default. How can we enable this feature?

<Please see attached file for image>

Pic 1.jpg

 

 

Environment

Advanced Reporting in CA PPM

Resolution

To enable the the functionality of the 'View SQL Query' button, take these steps

  1. Login directly to your Advanced Reporting server using the superuser account at http://<report_server_url>:8080/reportservice

  2. Navigate to the Manage tab and click on Server Settings

  3. In the Server Settings, click on Ad Hoc Settings

  4. Under the Ad Hoc Settings, check on the 'Enable View Query in Ad Hoc Editor' box and use the Change button to have the change take effect

 

<Please see attached file for image>

Pic3.jpg

 

After applying the change, navigate back to your Ad Hoc Editor and you'll see that the 'View SQL Query' button in the Ad Hoc View Editor is now enabled.

<Please see attached file for image>

Pic4.jpg 

 

 

Attachments

1558699804767000032755_sktwi1f5rjvs16jvr.jpeg get_app
1558699803054000032755_sktwi1f5rjvs16jvq.jpeg get_app
1558699801268000032755_sktwi1f5rjvs16jvp.jpeg get_app
1558699799504000032755_sktwi1f5rjvs16jvo.jpeg get_app
1558699797858000032755_sktwi1f5rjvs16jvn.jpeg get_app
1558699795732000032755_sktwi1f5rjvs16jvm.jpeg get_app