Olap access grants

[simonabertozzi]

 Hi all,

I have created a cube and successfully written a xml access grants for it based on the profile attributes of our users. However, I have a question: can I filter my users using only certain values of their profile attributes? For example, can I only use the first value of an attribute (ignoring all the others) to filter certain data and if so, what is the syntax I have to use in the xml file?

Right now my xml access grants looks like this:

 

<Roles>

<Role name="ROLE_DIRECTOR">

<SchemaGrant access="all">

<CubeGrant cube="Customer_Cube" access="all">

<HierarchyGrant hierarchy="[Cities]" access="custom">

<MemberGrant member="[%{Cities}]" access="all"/>

</HierarchyGrant>

</CubeGrant>

</SchemaGrant>

</Role>

</Roles>

where Cities is the attribute name used for the filtering.

Best regards,

Simona