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.
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.
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.
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.
FY2019-20 FEMA Cal Answers Ad Hoc Query Job Aid
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
How to Use Exclude C&G Revenue Filter Job Aid
Ad Hoc Tips Job Aid
You can find sample analyses at: Catalog/Shared Folders/Analysts/Functional/Finance/User-Created Ad Hoc Analyses/VCFIN - Finance/Ad Hoc Demonstration Analyses
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.
