Versions Compared

Key

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

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

...

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.

...

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

  1. Click View → Repository to display the repository Folders Repository folders in the navigation panel on the left side of the screen.

  2. From the navigation panel, click open the Public folder → Data Warehouse folder → DW Reports folder to display the available reports for the Data Warehouse, including the DW_LGBTQ_Report.

  3. Click the DW_LGBTQ_Report link to run the report.

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.

...

.

  1. Click View → Repository to display the Repository folders in the navigation panel on the left side of the screen.

Image Added

2. From the navigation panel, open the Public folder → Data Warehouse folder → DW Reports folder to display the available reports for the Data Warehouse, including the DW_LGBTQ_Report.

3. Click the DW_LGBTQ_Report link to run the report.

Image Added

Image Added

Image Added

Note

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

...


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.

...

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. Click OK to close dialog box.

The table below outlines the available actions you can take in the Input Controls dialog box.

...