Hot answers tagged

1

I highly recommend you check out Analysis Management Objects (AMO) - I use it to perform all maintenance tasks in SSAS such as creating Roles, Permissions, Databases and Models. I prefer to use C# but there are plenty of examples online of using the same classes in PowerShell. You need to make sure you use the correct classes based on the type of install ...


1

on this link: A quick overview of SSAS for DBAs you can find relevant information about SSAS that can help you to see why there are so many advantages using SSAS. You also need to manage permissions, as you mentioned Power BI, SSAS interacts very well with Power BI, in many environments I restrict the Power BI views by managing the permissions using AD and ...


1

That means that a VM with 16 CPUs will have 16 vCPUs with 1 core each. Not exactly, that means initially a Host with a CPU of 16 cores should only have 1 VM with 16 vCPUs or 2 VMs with 8 vCPUs each instead. But as the chapter 3.5.2 Allocating vCPU says: if the physical server that the various SQL Server workloads currently run on equates to 16 ...


1

For what it's worth, this might have to do with the mode, in which SQL Server Analysis Services is installed. If it is installed in the Tabular mode (the default), then the New Database... menu item is not available. If Multidimensional and Data Mining mode is selected during the installation, then the New Database... menu item becomes available. A much more ...


Only top voted, non community-wiki answers of a minimum length are eligible