We are pleased to announce the release of Version 2.0 of the Cognos FIS Data Warehouse Data Model.
2.0 New Features
New data subjects
• Fixed Assets
• Approvals
• OPE Ledger
New data structure
• Operating Ledger Crosstab
Many improvements, including…
• Architectural changes to better “future-proof” user reports (see below)
• More robust Transaction Ledger <-> Transaction Description join
• Index Codes and Descriptions included in Operating Ledger, Transaction Ledger, and Payroll Ledger
• Dollar amounts and percentages automatically formatted
2.0 Release Notes
Existing reports built using the old model will need to be reproduced using the new version. The goal of the “future-proofing” work in this release is so that reports built on Version 2.0 and above can be easily migrated to new data model releases. Version 1.0 of the data model, “OUS FIS Data Warehouse (v. 1.0)”, will be available until May 1 to allow time for migrating 1.0 reports.
The new model, in keeping with a Cognos best practice, does not have a version number embedded in the name; it’s just “OUS FIS Data Warehouse”. It can be found alongside the older version in Public Folders/Finance Data Warehouse.
With this release, the only remaining BI Query data subject not yet reflected in Cognos is “Validation Tables”. This data subject will be included in Version 2.1, coming this spring.
We are working on a document that will provide a guided tour of the FIS data model, including tips and techniques for working more effectively and efficiently in whatever Cognos reporting tool(s) you choose.
We hope that you’ll find FIS version 2.0 to be a stable, reliable platform for developing Cognos production reports. If you find something that doesn’t seem to work properly, please contact John Peters at (541) 737-3349 or john.peters@oregonstate.edu.
