Note:  Steps in Part A and B are can be set up by Cognos help desk.

...

The parameters in each tab  will be saved with the query

The $5, 1-Button Solution

1. Run report, Click button to Save query

Image Added

2.Select My Folders - Customize Folders/SubFolder if Desired

Image Added

3.Customize Parameters

Image Added

4. Access Saved Query from ZotPortal

Image Added

Image Added

The $50k, HTML5 GUI Solution (a la UCR)

HTML5 Front-End

Tree Prompt

Type-a-head Search

List/CrossTab

Column Hide/Show

Cognos SDK Backend

Query Parameters saved in DB, KSAMS enabled

JavaScipts Library:   $7,575 (https://www.sencha.com/store/)

Design/Development/Test/Deploy:  2-3 months

User Experience:  Priceless

Appendix A  - Legacy DS Adhoc Report

1. Main App

Image Added

1. GL Adhoc

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Image Added

Appendix B:  CAFE

Step 1: Connect to Cognos

Image Added

Step 2: Select a package

Image Added

Step 3: Create a Crosstab/List

Image Added

Step 4: Populate Crosstab

Image Added

Step 5: Add Filter

Image Added

Step 6: Filter values

Image Added

Step 7: Apply Filter

Image Added

Step 8: Save XLS

Image Added

Step 9: Open XLS, connect to Cognos....repeat

Image Added

Bug:  Query Subject in folder does not work (Account, Org...cannot be used)

Appendix C:  UCR QBE

Query Parameters

Image Added

Output Field Selection

Image Added

Output

Image Added

Save

Image Added

Additional Actions

Image Added