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

1. GL Adhoc

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