If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data drop down list box is slow

Started by lots_of_questions, 12 Jan 2017 03:40:48 PM

Previous topic - Next topic

lots_of_questions

Hi all,

I have 6 drop down list boxes on a main deck of my report.  These drop down list boxes represent a financal break down  Ie.  A-B-C-D-E-F is my finance number.  1st drop down box shows all A's and filters the B drop down list, which filters C, etc.  I am using variables and the main page works and is quite fast.  I have a button that takes the user to the specific page.  If you only fill in A, it takes you to the A page, fill in B, it takes you to the B page, etc.  All of this works fine.

Each individual page has the finance number displayed on it.  If you select down to E, you see A-B-C-D- E displayed on the page.  This works perfect as well.

My issue is when I try to change E to a drop down box as well.  As soon as I add the box (which is already filtered the same as the previous box) it is extremely slow.  However, it is only for the first time loading the page.  It works fine afterwards.  I have double and triple checked my filters.  It is the same as the first drop down box.

Is there a way to trick this to load on the initial opening of the report?  Another way of doing it maybe?

More info... this is a dimensional structure. Cognos 10.2.1.  Active report.

Any help is appreciated.

AnalyticsWithJay

Could you post the debug info before and after you make this change? (ctrl+shift+d).

Do these drop-downs filter any data containers? Are you using visualizations, charts, or combinations of both?

lots_of_questions

I was able to reduce the amount of rows returned by removing nulls and zeros.  It is working fine now (decrease the size of the file by 60%.)   Seems like it could of been a file size issue.

AnalyticsWithJay

Quote from: lots_of_questions on 28 Feb 2017 08:05:34 AM
I was able to reduce the amount of rows returned by removing nulls and zeros.  It is working fine now (decrease the size of the file by 60%.)   Seems like it could of been a file size issue.

If possible, use visualizations instead of charts to further reduce the size.

lots_of_questions

Thanks.  I will try that as well.