KFS BLISS Ad Hoc Query Help

Decorative blurry numbers from a report

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.

Accessing BLISS

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.

BLISS Tabs

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.

  • Context Tab

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.

  • Amounts Tab

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.

BLISS User Manual

For help with using BLISS, the system's old user manual is still available online.

A great deal has changed at UCI since it was last updated, so some information is likely out of date.

KFS BLISS Support

General Financial Management questions should be directed toward the Chief Financial Officer(s)/Fiscal Officers of your unit/department, as there may be specific unit/department policies relating to your financial operations. 

For technical assistance with the interface, contact the OIT Help Desk (949) 824-2222 or oit@uci.edu