Hi Tried with dual but always the session variable takes the default initialization value!!

nope, am not able to as its configured with SSO.

Have any one come across such scenarios?

Yes, this issue is there since 11g. Until its reset the values wont be cleared. Experienced the same issue not able to find any workarounds.

Lets say there are 2 columns, one with descriptor id and one without, and am using the one without in the dashboard prompt and using Limit Values By. Now the description will be passed to other prompt fields where Limit By is enabled But, when we use the one with descriptor id in the anlaysis filter as 'is prompted' will…

thanks much for the response.

@cesar.advincula.o This issue is not happening when I drill the data, but when I use column selectors and try to use the pagination button to navigate the pivot table to see more data@