Saturday, November 2, 2013

Cognos report authoring techniques

1.1 Achieving a comprehensive BI solution using Cognos with SQL server
1.1.1 Context
1.1.2 Solution overview
1.1.3 Implementation
1.1.4 Lesson learned…
1.2 Dynamically setting default values
1.2.1 Using Java Script
1.2.2 Using hidden prompt page
1.2.3 Using hidden singleton master
1.2.4 Using hard coded value
1.2.5 Using hidden query
1.2.6 Using calculation from framework manger
1.2.7 Using relative time category value for power cube
1.3 Bursting complicated reports with multiple parameters
1.3.1 Context
1.3.2 Implementation
1.4 Implementing row level security in framework manager
1.4.1 Specifying data security in framework manager
1.4.2 Dynamically setting data security in framework manager with parameters map
1.4.3 Using simple parameter map between user and security column
1.4.4 Using advanced parameter map between user and security related information
1.4.5 Using database table to control user access permission based on user group
1.4.6 Using database connections in Cognos
1.4.7 Embedding data security with fact table at database level
1.4.8 Using multi-values LDAP attributes
1.5 Handling relative time (relational model focused)
1.5.1 Turning relative time to measure
1.5.2 Using parameter map to resolve complicated relative time issue
1.5.3 Using joined query at report level to address rolling period to date issue
1.5.4 Using moving average / Total
1.5.5 Making and sorting a crosstab report with different time periods
1.6 Handling DMR relative time
1.6.1 Handling DMR relative time at database level
1.6.2 Handlling DMR relative time at framework manager level
1.6.3 Handle DMR relative time at Report level
2 Report in general
2.1 Dynamically using the layout component reference
2.2 Making Page with multiple table of contents
2.3 Making only first entry show on table of contents
2.4 Using  prompt token macro to make report more interactive
2.5 Creating highly interactive Reports with jQuery
2.6 Developing  interactive reports (portal page) based on report view
2.7 Making a single report to be shared for bursting, scheduling and running interactively
3 Active report
3.1 Using publish – subscribe architecture to communicate in active reports
3.2 Passing variable values to list, crosstab and chart
3.2.1 Directly passing variable values
3.2.2 Passing variable values using data deck with a single variable
3.2.3 Passing variable values using data deck with two variables
3.2.4 Lessons learned
3.3 Drilling through in active report without connection to Cognos
3.3.1 Context
3.3.2 Drilling through with connection to Cognos environment
3.3.3 Drilling through from a list with one variable
3.3.4 Drilling through from a list with two variables
3.3.5 Drilling through from a crosstab with two variables
3.3.6 Drilling through from a chart with two variables
3.4 Making a block hide or show in active report
4 List report
4.1 Grouping column headers
4.2 Making summary rows at the top
4.3 Placing data items anywhere
5 Crosstab report
5.1 Making conditional style based on another measure
5.2 Making summary rows on top
5.3 Making crosstab headers look like list column headers
5.4 Making crosstab with multiple measures
5.5 Flattening hierarchy for crosstab nodes
5.6 Making cconditional drill
6 Chart report
6.1 Making Top N + others chart
6.2 Aligning series data with axis categories
6.3 Making different periods on chart axis
6.4 Making flexible bullet chart
7 Appendices
7.1 Note
7.2 About author

No comments:

Post a Comment