Hi, I have a olap cube in sql server and i would like me that some
users had access some members of a dimension but not others. I think I
must use roles but I've got a trouble. The information about security
is in a table database, so, I must build these roles dinamically,
programatically, is this possible?, anybody has got an example code
please?

Thanks in advance.

David

Hi,

you must build the roles and permissions progamatically.
The simple way is to create a role with data dimension restriction using the
management studio and then look/save the xmla what is generated.
Then you can generate your xmla's and sent them to the AS.

Radu

P.S: this is working for AS2005

"Ixabre" <ixabre (AT) gmail (DOT) com> wrote

Radu Colceriu ha escrito:

Thank you for your answering Radu, just one more question, Pivot Table
is able to read xmla sentences in command text property as does with
MDX expresion?.

Thanks in advance Radu.