Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

CCC Data Warehouse Report Server v7.8 Last Update: June 2022

...

User Types & Access Levels

User Type

Authentication

Authorized Access Level

College User

SSO User

SSO access via college/district IdP

Single college access to available data sets based on College MIS Code

District User

SSO User

SSO access via college/district IdP

Multi-college access to available data sets based on District MIS Code

Chancellor's Office User

Non-SSO User

Direct access (non-IdP) via two-factor authentication (2FA)

Access to all data sets across all colleges

CVCOEI User

Non-SSO User

Direct access (non-IdP) via two-factor authentication (2FA)

Access to CVCOEI report but no actual data (can see tables and columns in AdHoc view, but no data populates)

CCCTC Administrator

Non-SSO User

Direct access (non-IdP) via two-factor authentication (2FA)

Access to the internal system administration console to facilitate account creation & configuration.

...

To run a report, click the name of a report in the repository. For example, click DW LGBTQ Report. The report appears in the Report Viewer.

...

  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.

You can now begin working with your report.

...

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.

...