The query is slow

[wmltsang]

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