-
1
- #1
Thought I would post these tips here, after I told a Cognos Help Desk Analyst about them, who had not yet found them.
On a report page, if you right-click on a table, text item, or other object, you can select "Go to Query" and it takes you to the corresponding query. Saves time sorting through many queries, or navigating up the object hierarchy to find which query the data comes from.
Under Tools --> Options, de-select "Delete Unreferenced Query Objects." This way, when you delete a column from a list, the corresponding query item will not be deleted. Likewise, when you delete a data item from a query, the corresponding tabular item is not deleted. Prior to finding this, I was often accidentally deleting calculated columns from queries when I removed them from lists or crosstabs. This has saved me a lot of grief.
Hope someone finds this useful!
Stacy
On a report page, if you right-click on a table, text item, or other object, you can select "Go to Query" and it takes you to the corresponding query. Saves time sorting through many queries, or navigating up the object hierarchy to find which query the data comes from.
Under Tools --> Options, de-select "Delete Unreferenced Query Objects." This way, when you delete a column from a list, the corresponding query item will not be deleted. Likewise, when you delete a data item from a query, the corresponding tabular item is not deleted. Prior to finding this, I was often accidentally deleting calculated columns from queries when I removed them from lists or crosstabs. This has saved me a lot of grief.
Hope someone finds this useful!
Stacy