Ad Hoc

Ad Hoc

When the existing dashboard reports do not have the data in the format with the summarization that you need, you can use Ad Hoc to create your own analysis and reporting. Ad Hoc works consistently across the subject areas in Cal Answers. Separate materials and courses are available for Student Data and Finance subject areas.

Student Data

Finance

Request Access to Ad Hoc

Access to Ad Hoc reporting for Student Data requires special access. See Getting Access to Cal Answers for details. Access to Ad Hoc reporting for Finance is included with dashboard access.

Ad Hoc: Student Data

Ad-Hoc Analysis Reference Guides – Student Data Perspective

  • Creating Analyses: Learn to use columns, filters, calculated fields, and bins for grouping data. 
  • Viewing Analysis Results: Learn to create and use results views such as Title, Table, Graph, Pivot Table, Filters, and Static Text.
  • Advanced: Dashboard Reports: Learn to use view selectors and column selectors, dashboard prompts, and the Dashboard Editor.

Training

Self-study and instructor-led training courses are currently in development for creating ad hoc analyses using student data. Communications will be sent out when we are ready to pilot the courses and open them for enrollment. 

Ad Hoc: Finance

Training

Getting Started with Ad Hoc Analysis Templates Training Slides

Self-study and instructor-led training courses are currently in development for creating ad hoc analyses using student data. Communications will be sent out when we are ready to pilot the courses and open them for enrollment.

Job Aid

FY2019-20 FEMA Cal Answers Ad Hoc Query Job Aid

Wiki

Ad Hoc: Finance – GL Answers

Ad Hoc: Finance - GL Answers: Getting Started with Templates Job Aid

Sharing an Ad Hoc Analysis Job Aid

Saving Ad Hoc Analyses to the Shared Folder Job Aid

How to Add a Row Count To Your Ad Hoc Analysis Job Aid

Ad Hoc Tips Job Aid

GL Answers: Data Dictionary

Examples

Sample Analyses

You can find sample analyses at: Catalog/Shared Folders/Analysts/Functional/Finance/User-Created Ad Hoc Analyses/VCFIN - Finance/Ad Hoc Demonstration Analyses

Online Documentation

The capabilities within ad hoc are numerous, so if you want to get more advanced, search the Internet for "OBIEE ad hoc" to see results in formats such as: blogs, Oracle forums, user communities, Oracle technical documentation, etc.