OWC filter based on user credential

[olap]

hi,
i'm using OWC 11 and SQLServer Analysis Services. i have to filter the
dimension of the cube displayed by the owc basing on the user credential.

For example: the user is "fed"; he logs on my web application; then i have a
cube with the seguent dimension:
"Structure"
"Fed"
"Uni"
"Bob"

So the user "fed", in the dimension "Structure", have to see only the "Fed"
entry.

Do you have any idea?

 

[Effie]

You can do something like
<%
Test = Request.ServerVariables("AUTH_USER")
%>
here come your OWC code...
Set fld = .FilterAxis.FieldSets("Name").Fields(0)
fld.IncludedMembers = array("<%=ucase(Test)%>")
set fld = nothing