SSAS tabular: Implement createOrReplace batch using sequence with TSML json
This is a sample of how you would create and assign members to three roles for your tabular cube using TSML json script.
To execute, open new query connection to your ssas tabular server in management studio, then execute
The example in msdn has an extra, invalid bracket set, after "sequence": which fails the script. It has been removed in my working sample below
To execute, open new query connection to your ssas tabular server in management studio, then execute
The example in msdn has an extra, invalid bracket set, after "sequence": which fails the script. It has been removed in my working sample below
{
"sequence": {
"operations": [
{
"createOrReplace": {
"object": {
"database":
"YourTabularCubeName",
"role": "Admin"
},
"role": {
"name":
"Admin",
"modelPermission":
"administrator",
"members": [
{
"memberName":
"domain\\adminUserOrGroup"
},
{
"memberName":
"domain\\adminUserOrGroup2"
},
{
"memberName":
"domain\\adminUserOrGroup3"
},
{
"memberName":
"domain\\adminUserOrGroup4"
},
{
"memberName":
"domain\\adminUserOrGroup"
}
]
}
}
},
{
"createOrReplace": {
"object": {
"database":
"YourTabularCubeName",
"role":
"Process"
},
"role": {
"name":
"Process",
"modelPermission":
"refresh",
"members": [
{
"memberName":
"domain\\processUserOrGroup"
}
]
}
}
},
{
"createOrReplace": {
"object": {
"database":
"YourTabularCubeName",
"role": "Read"
},
"role": {
"name": "Read",
"modelPermission":
"read",
"members": [
{
"memberName":
"domain\\readUserOrGroup"
}
]
}
}
}
]
}
}
Comments