Hi Guys,
We all must have built many report.We first build reports then check how its performing.Now lets start report building by looking at Explain plans
The Article below is very good . It explains how we can overcome the lack of Aggregate Navigation feature in cognos. Aggregate navigator means when we have summary table and detailed table you want to Summary table on the fly based on the query.
It also explains two layered query approach for better Explain plans in oracle. Your can also check out my other articles on Oracle explain plans by typing " Cognossimplified Oracle Explain plans"
http://ibmcognosrmug.files.wordpress.com/2012/03/cognos_user_group_presentation.pdf
We all must have built many report.We first build reports then check how its performing.Now lets start report building by looking at Explain plans
The Article below is very good . It explains how we can overcome the lack of Aggregate Navigation feature in cognos. Aggregate navigator means when we have summary table and detailed table you want to Summary table on the fly based on the query.
It also explains two layered query approach for better Explain plans in oracle. Your can also check out my other articles on Oracle explain plans by typing " Cognossimplified Oracle Explain plans"
http://ibmcognosrmug.files.wordpress.com/2012/03/cognos_user_group_presentation.pdf
No comments:
Post a Comment