I have performance point 2010 work in sharepoint 2010.
I created a simple dashboard, which data retrives from sql ser 2008 SA cube. In the cube, I have roles to controle each different user to see different data. My question is:
Is there any way I can pass the current user (login the sharepoint site) as a filter into the dashboard to do the same function as the role in cube? Then each user can only see whatever s/he can see base on the role logic has been implemented in the cube. For the sake of simple, the process will work like below:
1. get current user from sharepoint site login;
2. pass it to the dashboard;
3. match the user in cube's role to filter data;
4. show the corresponding data out;

I found there is webpart called Current User Filter under Filters category. However, I got blank screen when I tried to configure the webpart to connect to the dashboard part.

I am wondering if it is the right way I should do? And how?