FIS Data Warehouse Model 2.0 is here!

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.

Print Friendly, PDF & Email
This entry was posted in New Releases. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *