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.
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?
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.
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.
Thanks. I will try that as well.