XMLA : How can i get the XmlaResultCollection of Role AttributePermissions with XMLA

 

hi all,

i set attribute permissions role xmla. have no problem in that. role can see data (saturday , sunday). (xmla below)

 

after settings value how can query roles attribute permissions xmla query.

<discover xmlns="urnchemas-microsoft-com:xml-analysis">

<requesttype>mdschema_cubes</requesttype>

.....???????????

</discover>

 

i think have write discover statement couldnt find exact xmla query. request type?

i want these restriction list in microsoft.analysisservices.xmlaresultcollection

 

 

------ set permissions -------

public myolapserver as new microsoft.analysisservices.server

myolapserver.connect("data source=" & myolapservername & ";localeidentifier=" & cstr(dwlocaleidentifier))

myolapserver.execute(xmlxmla.innerxml())

myolapserver.update()

 

 

 

<alter allowcreate="true" objectexpansion="objectproperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<object>

<databaseid>mydb_olap</databaseid>

<dimensionid>dim date</dimensionid>

<dimensionpermissionid>dimensionpermission 1</dimensionpermissionid>

</object>

<objectdefinition>

<dimensionpermission xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlnsdl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<id>dimensionpermission 1</id>

<name>dimensionpermission 1</name>

<roleid>gr1</roleid>

<read>allowed</read>

<attributepermissions>

<attributepermission>

<attributeid>day name</attributeid>

<allowedset>{[date].[day name].&amp;[saturday], [date].[day name].&amp;[sunday], [date].[day name].&amp;[thursday]}</allowedset>

</attributepermission>

</attributepermissions>

</dimensionpermission>

</objectdefinition>

</alter>

if know id of particular permissions after can following

 

<discover xmlns="urnchemas-microsoft-com:xml-analysis">

  <requesttype>discover_xml_metadata</requesttype>

  <restrictions>

    <restrictionlist>

      <databaseid>mydb_olap</databaseid>

      <dimensionid>dim date</dimensionid>

      <dimensionpermissionid>dimensionpermission 1</dimensionpermissionid>

    </restrictionlist>

  </restrictions>

  <properties>

    <propertylist></propertylist>

  </properties>

</discover>

 

if after list of permissions in give database xmladiscover class in analysis services stored procedure project www.codeplex.com/asstoredprocedures is worth look. let query like:

 

call assp.discoverxmlmetadata("\database\dimensions\dimension\dimensionpermissions\dimensionpermission");

 

that give list of permissions dimensions in current database in flat table structure (that work reporting services).

 

SQL Server  >  SQL Server Analysis Services