COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Data Modules => Topic started by: wmltsang on 12 Dec 2022 11:00:23 AM

Title: The query is slow
Post by: wmltsang on 12 Dec 2022 11:00:23 AM
Hi members in IBM Cognos Community,

I am new to IBM Cognos analytics. I am using IBM Cognos Analytics 11.1.7. I am still in the stage of data exploration. When I try to pull in the table and add filters to limit the data to month of November and year to 2022 also another filter for including only certain categories on the data (the category is from another table but seems to have common field of unique key). It just keep spinning. I know the limit on rows for the web is 250000 rows but any tips on how to make the spinning time less and the time out is 3600 secs.

Also appreciate if someone can provide any training materials on getting started with IBM Cognos analytics.

Thanks,
Lydia