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

 

The Second Run of a report with Same Prompts Should also start from scratch

Started by Mfg, 15 Sep 2015 01:43:37 AM

Previous topic - Next topic

Mfg

Hi,
I want to run two versions of a report (Queries with different filters) with same prompts. I want both of these reports to be started from scratch, means i don't want second run to be happen faster. What should i do for it...? Should i clear any kind of cache...? or any other thing....! If anybody out there with suggestions, please help me out.

I have Cog 10.2.2 here with me. I wanna do that purely with cognos, not through SQL Server using following commands(dbcc freeproccache & dbcc dropcleanbuffers).

Thanks in advance.
@MFG   
MFG

Mfg

Changing "Use local cache" property to "No" for every individual queries we need to, in both the reports, I am getting good results so far,but if there is any solution that we can do it globally, please let me know.

... 8)Cheers.....
MFG

MFGF

Quote from: Mfg on 18 Sep 2015 02:35:54 AM
Changing "Use local cache" property to "No" for every individual queries we need to, in both the reports, I am getting good results so far,but if there is any solution that we can do it globally, please let me know.

... 8)Cheers.....

Seems like an odd requirement to have reports return data as slowly as they can? Can you describe what you're trying to achieve here? Is it an issue with rapidly changing data that is getting ignored by the cache? Something else?

If you need to, you can disable caching at the package level from within Framework Manager, but of course that would affect all reports based on the package...

MF.
Meep!

Mfg

Thanks for the reply MF...

Actually one data item in a query restricting me to put detailed filter on the query. So I just gave the filter at detailed level of that query and then separated the restricting data item in another query and then joined both of them.

With all of the above stuff I did save it as a new report so that I can make difference between running times of both the reports.(with filtered_ joined & non filtered Report).
After running one report when I was trying to run another version of the report, I was not sure that, whether I am getting correct running times or not, Because both of the reports hitting same database with same parameters(Prompts).That's why I ask for both of the reports to be started from scratch.I just wanted to make sure, that's it.
MFG