different users different performance

[afzaki7]

Hello all
I have a wired issue
its i have a report that run normally with some users but the others users can't run it
i mean by can't run is the report take too long time in the waiting mode (sand clock) then its hang without showing any data

the user that run the report normally is an administrator the other not

can any one rise some points that may cause such behavior so i check and see whats wrong or what should i do
am ready for any questions if you want any additional clarification 

[MFGF]

Hello all
I have a wired issue
its i have a report that run normally with some users but the others users can't run it
i mean by can't run is the report take too long time in the waiting mode (sand clock) then its hang without showing any data

the user that run the report normally is an administrator the other not

can any one rise some points that may cause such behavior so i check and see whats wrong or what should i do
am ready for any questions if you want any additional clarification

Do you have any complex security filters defined in the model that might be causing the query to filter on something the Administrator doesn't?

MF.

[afzaki7]

Hi MFGF
Thanks for your reply
no there is no filters at MDL
actually i made some investigation on our servers and i found that the server that report doesn't work on has additional setting
named (RSVP.PROMPT.RECONCILIATION) and its value is (2)
this property founded in the advanced settings of the (ReportService) setting
when i remove this setting the report run with all users normally
but i can't do this action because i don't know the effect of it on the others reports
so do you have any ideas of what makes this happens


I attached an image for this property

[MFGF]

Hi MFGF
Thanks for your reply
no there is no filters at MDL
actually i made some investigation on our servers and i found that the server that report doesn't work on has additional setting
named (RSVP.PROMPT.RECONCILIATION) and its value is (2)
this property founded in the advanced settings of the (ReportService) setting
when i remove this setting the report run with all users normally
but i can't do this action because i don't know the effect of it on the others reports
so do you have any ideas of what makes this happens


I attached an image for this property

Hi,

It's worth you reading the technote below. It fully explains prompt reconciliation tuning and what effect the RSVP.PROMPT.RECONCILIATION server setting has, as well as how you can override it locally within a report.

ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/performance_and_tuning/advanced_prompting.pdf

Cheers!

MF.