The BI/DW team offers the following solutions for reporting, analytical, and data extraction needs:
| Solution | Description |
|---|---|
| Cognos Reports | Centrally developed reports that can be executed on-demand or scheduled. Reports are currently available for the current financial (KFS), security role (KSAMS), Office of Research, Office of Institutional Research, and student success (Compass) data. |
| Cognos TM1 | Enterprise planning software that allows for planning, budgeting, and forecasting. Solutions are currently available for Planning and Budget. |
| Cognos Report Studio | Allows technical users the ability to author reports using existing Cognos content. |
| Cognos Workspace Advanced | Provides business users a simplified interface for authoring reports using existing Cognos content. |
| BLISS Adhoc Query Tool | An OIT-developed tool providing business users with a query by example user interface for extracting data. Queries are currently available for historical and current financial data, employee, payroll, purchasing and accounts payable data. |
Use Cases
| Use Case | Solution | Difficulty |
|---|---|---|
| Infrequent and/or non-technical users that need quick and simple access to predefined reports | Cognos Reports | Simple |
| Users that need frequent or scheduled access to standardized reports or reports with complex business logic, or with complex formatting and graphics | Cognos Reports | Simple |
| Technically advanced business users that require adhoc and customized reporting using existing Cognos pacakges | Workspace Advanced | Moderate |
| Business users that require adhoc or scheduled access to data, using a flexible yet easy to use interface that would allow downloads to Excel or other application | BLISS AdHoc Query | Moderate |
| Technically advanced business users, with Cognos training, that need to build customized reports with complex business logic and/or formatting | Cognos Report Studio | Difficult |