Friday, June 28, 2013

How to make Cognos report reusable

How to make Cognos report reusable    


1 Introduction
1.1 Common approach
1.2 Problems
1.2.1 Difficult to author report
1.2.2 Difficult to maintain report
1.2.3 Difficult to make report consistent
1.3 Compare report authoring with software development
1.4 Why reuse report
1.4.1 Reduce report authoring cost
1.4.2 Reduce report maintenance cost
1.4.3 Increase report consistency
1.5 Goal
1.6 Note
1.7 About author
2 Functionalities to be applied
2.1 Layout component reference
2.2 Prompt token
2.3 Parameter maps
3 Make Framework manager model reusable
3.1 Sample
3.2 Centralize date logic calculation
3.2.1 Create database query
3.2.2 Create parameter maps using query
3.2.3 Create calculations
3.2.4 Generate sample report
3.3 Summary
4 Make query reusable
4.1 Make query items reusable horizontally
4.1.1 Sample
4.1.2 Use query item for page set
4.1.3 Use query item for page
4.1.4 Use query item for crosstab
4.1.5 Use query item for Chart
4.2 Make query items reusable vertically
4.2.1 Sample
4.2.2 Create a report query with prompt token
4.2.3 Create a control query
4.2.4 Pass query item definition from control query to report query
4.3 Make filters reusable
4.3.1 Make logic filter based on prompt
4.3.2 Make logic filter with built in business logic
4.3.3 Combine all mandatory filters together
4.4 Use properties to control query to execute
4.4.1 Use properties of page set
4.4.2 Use properties for page
4.4.3 Use properties for crosstab node member
5 Make report expression reusable
5.1 Share expressions within single report
5.2 Share expressions in different reports
5.3 Summary
6 Make data container reusable
6.1 Make data container with layout component reference
6.1.1 Used in same report
6.1.2 Used in different report
6.1.3 Used in complicated data container
6.2 Make generic reusable data container for layout component reference
6.2.1 Make report queries generic
6.2.2 Make layout to be shared
6.3 Special notes for layout component reference
6.3.1 Conditional style is not carried over
6.3.2 Override limitation (singleton, no master detail)
7 Conclusion and Outlook
Check the book for detail  How to make Cognos report reusable

No comments:

Post a Comment