Note: KFS BLISS is retiring. Please try the new DWQuery. For more information see this guide. Please note that your saved KFS GL BLISS Queries will not be migrated over. Please rebuild your queries in DWQuery.
UCI has temporarily brought back the old Data Warehouse interface—more formally known as BLISS (Business Logic Information Selection System)—for generating customizable ad-hoc reports from the general ledger. Use of this interface is optional and Decision Support Cognos ad-hoc reports are still available.
Many long-time UCI employees will already be familiar with this interface. Using the KFS BLISS Ad Hoc Query interface is similar to using Data Warehouse for Payroll data and Legacy Financial System (FS) data.
For more information on how to use BLISS, see the User Manual.
BLISS is accessible on ZotPortal in the Finances/KFS Tab. Locate the KFS Decision Support portlet, expand the General Ledger Ad Hoc Templates section, and click the KFS BLISS Ad-Hoc Query link.
The KFS BLISS page is divided into 5 different tabs at the top of the page. Each tab allows you to select different sets of criteria to filter your data on. Selecting a checkbox next to a field allows you to select what columns you want returned on your query.
This tab will allow you to select multiple periods throughout a year. To multi-select periods, hold the 'CTRL' key on your keyboard and select the Fiscal Periods you want. Keep in mind Carryforwards and Beginning Balances are in Fiscal Period BB or CB.
Campus Hierarchy Tab
When identifying a KFS Organization Code, KFS BLISS will not factor in the inherit org hierarchy. This means, whichever org is identified will only return Accounts directly under that organization, not accounts under organizations that report to the organization listed.
In order to retrieve multiple organizations by hierarchy, we recommend using the KFS Org Rollup Level Codes. To better understand the Organizational Hierarchy, use the Chart of Accounts Inquiry Report.
For example, indicating Org Rollup Level 03 Code = 9002 will bring back all orgs under 9002. Screenshot
Full Accounting Unit Tab
This tab will allow you to filter by fields relating to the KFS Account, KFS Object Code, or optional FAU attributes such as KFS Sub-Account, Object Consolidation Code, or KFS Project Code.
Ledger Detail Tab
This tab will allow you to filter by fields relating to the General Ledger such as Document Type, Document Number, or Org Ref ID. Ledger Entry ID is the unique identification number for an individual ledger row.
This tab will allow you to select what entry amount columns you would like to return or to filter by a specific amount. Each column selected will add an additional column that represents the balance type. For example, if an entry is an Actuals entry, then if you select the Encumbrances column, that column will simply return 0 since it is not an encumbrance.