I am facing another issue where i have a webi odcument on which security is applied, So when user opens a document and refresh the data it brings data for him only based on BOUSER mapping.
Later i decided to define the schedule for automatic data refresh from database and assigned sInstance=Last in document link for that webi document.
But i noticed that when user opens that latest instance , he is not getting his data, it is all the data and when he clicks on refresh then security applies and he gets his data.
Please tell me how we can fix this, as i do not want manual refreshes to database each time.
Looking forward to your suggestions.