COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: en1 on 22 Feb 2017 04:13:33 PM

Title: too many queries to DB
Post by: en1 on 22 Feb 2017 04:13:33 PM
hi! my report has many conditions for dimmensions.
Cognos generates similar  sql for any this filters on dimmensions ~ 240 sql
and report is very slow. How i can optimize FM model in this case?
dimmensional model (DQM)