Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

 

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

 

A.Create Cognos Query Using Report View

 

Step 1: Select and Execute Report

 

Step 2:  Select Query Parameters

 

Step 3: Run Report

 

Step 4: Save Report as View (in any folder, including My Folders)

 

B. Set up Saved Query

 

Step 1: Use properties settings of the view to change query parameters

Step 2: Set Default Action and Parameters for the Saved Query

 

Click Run to save criteria

 

Step 3:  Review and Save Query

Click Ok to save

 

 

C. Run Save Queries

Step 1: Run query

Step 2: Change the Fiscal Month parameter to Jan - 2016

Step 3: Review and run Save queries with new Fiscal Month

 

D. Same process/steps applied to Pro version of the Query

The parameters in each tab  will be saved with the query

 

 

Appendix A  - Legacy DS Adhoc Report

 

  1. Main App

  1. GL Adhoc

 

 

 

Appendix B:  CAFE

 

Step 1: Connect to Cognos

Step 2: Select a package

Step 3: Create a Crosstab/List

Step 4: Populate Crosstab

Step 5: Add Filter

Step 6: Filter values

Step 7: Apply Filter

 

 

 

Step 8: Save XLS

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

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

 

 

 

 

 

 

 

 

 

  • No labels