CA Service Management

We are creating some of our boxi reports in tableau. Does anyone know if there is behind the scenes "SQLscript" for the boxi reports that we can copy or view?

Thanks

Stephanie.......

Do you mean you need to see the SQL query behind the BOXI reports?

Are the reports WEBI reports or Crystal reports?

Paul,

Yes the SQL query behind the BOXI reports. These are WEBI reports.

Thanks

Stephanie

Stephanie......

When you open a WEBI report in CABI 4.x via BI Launchpad, you can select the DATA ACCESS tab and then click on the EDIT button.

Then click on the VIEW SQL button (last button on the menu  bar) and the Query window will open showing the SQL query behind the WEBI report.

Thanks Paul. That is exactly what I needed.

Stephanie

Glad we could help out!