ZotPortal Channel - KFS Decision Support (under 'Faculty & Staff' tab, 'KFS' tab)

Cognos - KFS Decision Support

KFS Decision Support & Data Warehouse Team

Valerie Jones - Project Lead, Operational Support (20%)

Tammy Matatall- Project Liason, Operational Support, Technical Specifications, DWQuery (50%)

Pramod Kunju - Data Modeler, ETL Developer, Technical Specifications (25%)

Eufemia Palomino - Report Developer (KBM), Technical Specifications (100%)

Ramesh - Report Developer (KFS), Technical Specifications (100%)

Allison Bennett - ETL Developer (25%)

Rudy Serna (student) - Report & DWQuery Developer

Project Name	Project Description	Estimated Completion
Workflow	Add a new data mart to include workflow data from KFS. Reports will also be developed to utilize the new features included in the data warehouse.	Spring 2019

KSams Roles

KFS Decision Report Viewer - allows users to view all reports in the 'General Ledger', 'Chart of Accounts', 'Capital Asset', and 'Purchasing/Accounts Payable' folders.
1. Existing KFS Roles
2. Explicit access to the KFS Decision Support Report Viewer Role
KFS Decision Support Advanced (AdHoc) - allows users to the KFS Cognos Departmental Packages in Query Studio
1. Explicit access to KFS Decision Support Advanced Role
KFS Decision Support Central Office
1. Existing KFS Roles
2. Explicit access to the KFS Decision Support Report Viewer Role
KBM Decision Support Central Office
1. Existing KBM Roles (KFS-FP - University Budget Manager)
2. Explicit access to KBM Decision Support Central Office Role
KBM Decision Support Report Viewer - allows users to view all reports for all reports in the 'Budget' folder, restricted by organization code.
1. Existing KBM Roles
2. Explicit access to the KBM Decision Support Report Viewer Role, which will also be org based row-level security

Cognos Groups (Access will be by existing KBM/KFS roles ONLY)

Securing Reports

Reports will be secured by KSAMS role or Cognos group.

Securing Data

All TEM, PO, DV and payment information will be restricted.

Browser not supported