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

...

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:

...

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.

...

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.

...

  • ready-to-use standard reports specific to single application data instances

  • ready-to-use CCC Data Warehouse reports specific to one of the following application data sources:

    • Canvas

    • CCCApply Standard application

    • CCCApply International application

    • California College Promise Grant application

    • MyPath

Report Overviews:

...

DW LGBTQ Report

The Data Warehouse (DW) LGBTQ Report is a ready-to-use report produced from the sensitive CCCApply data available only in the CCC Data Warehouse.

...

Use the following steps to access and run the DW LGBTQ Report once you are logged in to the Data Warehouse Report Server.

...

Tip

For detailed information on getting to the Data Warehouse Report Server and your authorized login credentials, see Getting to the Report Server in this user guide.

screen shot of reportImage Added

Note

Due to the sensitive nature of the LGBTQ report details the data has been obfuscated no personal identity information is displayed in the image above.

Using the Input Controls


4. If you want to narrow the report's results to a different time range from the default, click the Options icon to display the Input Controls dialog box and enter date/time fields to specify a new date range.screen shot

...

5. Click Apply to apply the new date range. The report will run and display results within the new date/time range you specified. The Input Controls dialog box continues to display allowing you to change the values if needed.

...

6. You can save the report by clicking the Save/Save As... icon:screenshot

...

And then export the report into a variety of file formats.screenshot

...

Click the…

To…

Save icon and select Save

save the report to your college or district default Reports folder

Save icon and select Save As

display the Save As dialog box where you can select a different folder to save your report:

screenshot

Export icon

select an export format that auto-downloads to your computer's hard drive default download location

...

7. After running and/or exporting the LGBTQ report, click View → Repository to return to the repository to view the list of reports.

...

Creating a Custom Version of the LGBTQ Report

...