FM making you go MAD ???

I have created a prompt for query studio,this prompt is basically made for inforcing row level security. User can select using which role he wants to run report. For that you have put filters in the corresponding FACT table so that whenever something is dragged from the FACT table and query studio report is run.. user is asked to select the ROLE.

But when you run the report , you see all the roles of ROLE TABLE are coming in the report and not those roles that are assigned to you.

ID	Role
John	Manager
John	Executive
David	Analyst

So when John is running report , he is saying all the roles in the prompt , Manager, Executive and Analyst. But this is wrong.

But why this is happening ???

So to correct this you go and put this filter exclusively in the ROLE TABLE query subject, you republish the package. But still you get the same kind of result. You would go made surely.. becuase the same thing happened with me  :(

You do one thing , you go one layer down and put the same filter in ROLE TABLE query subject. Re-publish the package and now run the report. Now you would see only Manager and Executive roles appearing for John.

Why Why Why ???  I also don't know .. This is weird!! This is absurd !!

Only thing I can guess is upper layer was inforcing the row level security so below layer should bring all the things which are required

Thanks

Vishwas