Chapter 54. Scripting SSAS databases – AMO and PowerShell, Better Together
Darren Gosbell
Have you ever found yourself clicking repetitively through an action in Business Intelligence Development Studio (BIDS)? Or struggling to compose XML for Analysis (XMLA) Create or Alter statements? Then read on to find out how to make your life a whole lot easier.
For designing and building Analysis Services databases, Microsoft has given you a great tool in the form of BIDS. For administrative tasks, you have SQL Server Management Studio (SSMS). These are both great GUI tools, but like all GUI tools, they fall short when you need to perform repetitive actions or when you have to automate a series of actions. Fortunately, both of these GUI tools have ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
