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

Caching the results for a Multi tab Report

Started by v2k4u, 05 Jun 2014 05:08:32 PM

Previous topic - Next topic

v2k4u

Hi Cognos Gurus,

I have a question about caching the result set for a Multi tab report. I have a report with different prompts and if the prompt values doesn't change from one tab to other tab, so when i switch back to the tab which was already run i should be able to cache the result set and get back the output without needing to run the Report again. I am using the Use Local Cache option in the Report but still for some reason it doesn't work, i mean it again runs the tab which was run previously. ex: if there are 2 tabs in the report and the first tab is run with a selected criteria and the criteria doesn't change and i run report again for the second tab and i switch back to the first tab it should not again run the report, instead it should cache the result set and give me back the data.

Sorry if i was not very effective in explaining the problem, you can ask me more questions if you need more detailed info.

navissar

Cognos RS doesn't have tabs built in. There are many possible workarounds, but one couldn't possibly answer your question without knowing which tabbing solution you're using.

v2k4u

Hi Nimrod,

Please find the attached link which explains the Mutli tab report creating using coniditonal block...
http://www.ironsidegroup.com/2011/11/14/ibm-cognos-tabbed-report-design/

This is the exact same procedure i am using for the Mutli tab report creation and wanted to know about caching the results after running each and every tab with a specific selected criteria...

navissar

Now we're getting somewhere.
Conditional blocks only render one presentation (block)  at a time, so your report will have to refresh. You can try to use another tabbing solution which renders everything at the same once and makes the switch lightening fast. I wrote one that's very simple to use and maintain here :http://cognospaul.com/2013/12/22/tab-solution-thats-easy-maintain-without-code-guest-post/
But there are many others available.