Hi team,
I have a requirement that i need Same Data volume in IBM Aginity Tool(backend Netezza) as in DMR report,reason is i want to check why DMR report is slow when we are using IBM netezza.
I have attached DMR query generated from SQL/MDX button for reference.
This same query taking 1 minute in DMR report but when i fire the attached SQL generated from DMR and run in IBM Netezza ,output displayed faster ,but one catch is IBM netezza showing only 1000 rows whereas report shows full data dump from Netezza tables
Your attachment shows 5 separate queries. It could be that you've got results from those queries getting combined locally on the Cognos server. Won't matter how fast your database queries are if the cause of your slowness is the local processing that is happening on the Cognos side.
A full data dump sounds like a poor fit for DMR or for any BI tool.
You might start my evaluating the Cognos SQL and comparing it with your native SQL queries to determine if there are improvements on the database side and/or your Cognos model side that can improve performance. I suspect if you've got a result set coming back that is more than 1000 rows then you're likely using the wrong tool for the job.