Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

CCC Data Warehouse Report Server v7.8 Last Update: May 2021

...

  • Run preconfigured reports that pull data from the CCC Data Warehouse, currently limited to the LGBTQ report.

  • Query available data sources, run ad-hoc reports, and download results.

  • Create an Ad Hoc View from which you can create Reports based on the following data sources:

    • CCCApply Standard & Noncredit Applications

    • CCCApply LGBTQ Data (AB 620)

    • CCCApply International Application

    • California Colleges Promise Grant Application

    • Multiple Measures Placement Service (MMPS)

    • COCI - Chancellor’s Office Curriculum Inventory (New May 2021)

    • C-ID - Course Identification System (New May 2021)

Note: If you are interested in direct (ODBC/JDBC) access to the CCC Data Warehouse via a site-to-site VPN, please contact your Enabling Services College Relationship Manager (CRM) to initiate the request for this access.

...

Authenticator for Mac and Windows Chrome browsers is available free from the Chrome Web Store. This app installs very quickly to your desktop (recommended) as well as your phone, and includes a lot of great features that promote security and usability. NOTE: The entire download and install process takes less than one minute. You may need local IT authorization and assistance to install it if policy requires this.

To Install the Chrome Authenticator:

...

Info

Creating Filters with Relative Dates

You can filter information in your view based on a date range relative to the current system date. You can accomplish this using date-based filters, and entering a text expression describing the relative date or date span you want to display, using the format <Keyword>+/-<Number> where:

  • Keyword indicates the time span you want to use. Options include: DAY, WEEK, MONTH, QUARTER, SEMI, and YEAR. An option used by itself (without +/-<Number>) gives the current value for that option.

  • or - indicates whether the time span occurs before or after the chosen date.

  • Number indicates the number of the above-mentioned time spans you want to include in the filter.

For example, if you want to see all of the CC Promise Grant Applications submitted during the prior week, your expression would be: WEEK-1.

...