Prompt Depending Query Items in Framework Manager

[jonathan.chan]

I have a report from report studio that takes about a minute and a half to load. It takes forever, because I have a set of columns that takes the amount from one account, compares and distributes that amount by taking the total account amount minus the current month's revenue, last month's revenue and the previous month's revenue creating aging buckets. I've to move these calculations to query items in framework manager hoping that it'll improve the report's performance, but I haven't been able to figure out how to create prompt dependent columns in framework manager. I've been googling and looking through this forum with little to no luck. Please help!

[Andrei I]

Please create a simplified version of your report against Cognos Samples package (Great Outdoor).
And publish an XML source.

[bdbits]

jonathan.chan - I realize you are new here, so you should read http://www.cognoise.com/index.php/topic,24030.0.html. You have not actually provided much information for someone to help you, particularly what is your data source and type (dimensional? if relational, what database?). 

Also, not sure but you sound new to Cognos. One of the major steps to take particularly if using relational data (as in from a database) is to have a look at the generated SQL. You can see this in Report Studio under the Tools menu. Take this SQL and paste it into your database's native query tools and run it. If that is slow, then the problem is either in the way the database was modeled in Framework Manager, or if the SQL looks appropriate it may be in the database and you should talk to the DBA. If the SQL is not slow, we'd need to know more about your report - like what type of presentation and the rendering format (HTML, PDF, Excel, etc.).