1 / 15

DWQuery

Discover the benefits of upgrading from BLISS to KSAMS, including a more modern feel and increased functionality. Learn how users loved BLISS and explore an example use case. Find out more about DWQuery autofill capability and upcoming features.

kenr
Download Presentation

DWQuery

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DWQuery Tammy Matatall & Kevin Chung

  2. Legacy BLISS Migrated • Why we upgraded BLISS • Transition from SAMS to KSAMS • Give a more modern feel • Increased Functionality • Users loved BLISS

  3. Users

  4. Example Use Case • Central Office Accountant wants to find which department has spent the most in the Travel Category (Consolidation Code) for the entire campus in Fiscal Year 2019.

  5. DWQuery

  6. DWQuery • DWQuery now shows an autofill capability for some fields

  7. Cascading PromptsFiltering

  8. Query Selection Screen

  9. Shopping Cart

  10. DWQuery Results

  11. Load, Save, Sort, Summarize, Distinct

  12. Some Stats • More than ½ of financial reporting users use DWQuery • Adding fields/new attributes is quick

  13. Future Data Models • General Ledger Balances • Travel • Purchasing and Accounts Payable

  14. Upcoming Features • Grouping and Formatting • Re-filtering and drill through • For the Future: Legacy (Datawarehouse.uci.edu) • Not a replacement, just converting legacy data and is a snapshot • For future data, that should be in UCPath

  15. Any Questions? • Dwquery.oit.uci.edu • Mailing List: uci-dwh@uci.edu • Subscribe at: https://maillists.uci.edu/mailman/listinfo/uci-dwh • KFS Helpdesk: KFS@uci.edu

More Related