How to generate a Simple Ad Hoc Report in Spectrum 10

Document created by Silvio Okamoto Employee on Jun 23, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

In CABI 4.1 SP3 release, Ad Hoc reports use ODBC for accessing reporting database. You must create a data source name (DSN) on the CABI host, which connects to a SRM Host in OneClick.

 

First follow the steps in the link below:

https://wiki.ca.com/display/CASP10/Generating+Ad+Hoc+Reports

 

Follow these steps:

 

1. Access the BI Launch Pad window.

http://<CABI-BOXI_hostname>:<port>/BOE/BI

Ex: http://cabi123:8080/BOE/BI

 

2. On the Home tab, in My Applications, click on Web Intelligence

AdHoc1.png

 

3. On the Web Intelligence tab, click on New (Ctrl N)

AdHoc2.png

 

4. Select the Universe data source

AdHoc3.png

 

5. Select the "Spectrum Ad Hoc - MySQL - EN"

AdHoc4.png

 

6. From this Query Panel you can create an Ad Hoc Report

AdHoc5.png

Attachments

    Outcomes