I logged in with user:viewer01 to BIP and viewed and printed a report named Cash Report.
And I made some data changes.
And then I logged in again with user:Admin to BIP.
But when I viewed Cash Report, my user changed to viewer01 automatically and some data changes doesn't effect this report.
What should I need to do to solve this probs ?
Please reply and help me asap.
Edited by: Su Su on Dec 12, 2012 11:39 AM
Might be cache issue.. try to set this in advanced tab prefix to by pass the cache or else add a column in your report with expression current_timestamp(1) or now() this might hit databse..
SET VARIABLE DISABLE_CACHE_HIT=1;
These option when you dont want to disable the cache.
If helps pls mark
You can disable the cache using NQSConfig.ini file
[ CACHE ]
ENABLE = YES;
and set to NO
once you done with changes restart services
Edited by: Srini VEERAVALLI on Dec 12, 2012 12:38 PM