How to Deploy Cubes in AAS
In Visual Studio > Solution Explorer, right-click the project > Properties. Then in Deployment > Server paste the server name. In Solution Explorer, right-click Properties, then click Deploy. You may be prompted to sign in to Azure
Other options available
SSAS Cube Deployment
BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO)
Deployment wizard.
XMLA Script.
Synchronize Database wizard.
Backup and Restore.
How to create Roles in AAS – Sh
In Object Exporer, right-click Roles > New Role.
In Create Role, enter a role name and description.
Select a permission.
TABLE 2
Permission | Description |
Full control (Administrator) | Members can modify the model schema, process, and can query all data. |
Process database | Members can run Process and Process All operations. Cannot modify the model schema and cannot query data. |
Read | Members can query data (based on row filters) but cannot modify the model schema. |
Click Membership, then enter a user or group in your tenant Azure AD by email address.
If the role you are creating has Read permission, you can add row filters by using a DAX formula. Click Row Filters, select a table, and then type a DAX formula in the DAX Filter field.
“Exception has been thrown by the target of an invocation”
While deploying to Analysis service tabular model – we encountered this error message, we have to check for other error messages . This can be found under Output tab window. We have to fix the error in output window.
AAS - user does not have permission to create a new object
Delete and add back or whitelist your client IP address to resolve the issue
