#xmla

[pythonjobsupport]

Power BI XMLA Endpoint: Why you should care

The XMLA Endpoint in Power BI can be very powerful. Adam looks at what it is and how to get started with it. If you are using … source

[questpond]

In this article will try to understand the concept XMLA.

[ssastack]

Executing XMLA without SQL Server Agent Jobs

Declare @XMLA nvarchar(1000), @DateSerial nvarchar(35); -- Change date to format YYYYMMDDHHMMSS Set @DateSerial = Convert(nvarchar, getdate(), 112) + Replace(Convert(nvarchar, getdate(), 108), ':', ''); -- Create the XMLA string Set @XMLA = N'<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>Adventure Works DW 2008R2</DatabaseID> </Object> <File>c:\bak\Adventure Works DW 2008R2_' + @DateSerial + '.abf</File> </Backup>'; -- Execute the string across the linked server (SSAS) Exec (@XMLA) At SSAS;

[ssastack]

Deploying a Microsoft BI Solution via Script

This article goes into some detail on how to deploy via script  for all the typical parts of a MS BI solution: the database, integration services packages, SQL Agent jobs and the SSAS cubes.

http://blog.boxedbits.com/archives/50