has anyone configure excel to be used a client ui for Olap SSAS 2000?

I have it working but trying to implement some security. I want to implement
a function to check the username and only return the data based on user
permission.

Has anyone tried this?

I was trying to create a function or parameter query to check the permission
against the dimension that I need return data based on the user name but not
sure if this can be accomplish in excel.