Versions Compared

Version Old Version 172 New Version 173
Changes made by

Mark Cohen

Mark Cohen

Saved on

Key

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

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

This guide is for the Data Warehouse Report Server (CCC Data 2.5.0) released to production on August 16, 2023.

...

  • Getting started with the DW Report Server; requesting authorized access and implementation support

  • User account set up and authentication processes

  • Running preconfigured reports that pull data from the CCC Data Warehouse (currently limited to the LGBTQ report template)

  • Querying available data sources, running ad hoc reports, scheduling and exporting results

  • Creating custom Ad Hoc Views from which multiple reports can be run based on the following data sources:

    • CCCApply Standard & Noncredit ApplicationsCalifornia Colleges Promise Grant Application

    • CCCApply International Application

    • CCCApply LGBTQ Data (AB 620)

    • CCCApply International Application

    • California Colleges Promise Grant Application

    • Multiple Measures Placement Service (MMPS)Standard & Noncredit Applications

    • C-ID - Course Identification System

    • COCI - Chancellor’s Office Curriculum Inventory C-

    • ID - Course Identification SystemMIS - Chancellor’s Office Management Information Systems

    • Multiple Measures Placement Service (MMPS)

Panel
panelIconIdatlassian-light_bulb_on
panelIcon:light_bulb_on:
panelIconText:light_bulb_on:
bgColor#F4F5F7

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.

Note

Access to Canvas Data is currently available only by direct access connection. For information regarding the Canvas DW Direct Connect service, please contact your Enabling Services College Relationship Manager (CRM) to initiate the request for this access.

...

  1. On the Home page, click Create in the Reports block. The Create Report wizard opens.

  2. Select the Ad Hoc view you want to use as the basis for your report.

  3. Select a report template. To use a template other than the default, select Custom Report Template, click Browse and select the desired template. See Report Templates for more information.

  4. Click OK. If asked, enter the input controls needed. See Using Input Controls.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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.

...