XMLA

XMLA related posts

I've been meaning to post this for a little while, and a recent post on the SSAS forum at ssas-info.com prompted me to finally get around to it. Basically the small Powershell script below will attach to the specified SSAS server and script all of the databases out to an XMLA file. In this example I also add a timestamp in the form of YYYYMMDD to the end of the file. $serverName = "localhost\sql08" $outputFolder = "C:\data\" ## load the AMO and XML assemblies into the current runspace [System.Reflection.Assembly... ......

Share This Post:
Short Url: http://wblo.gs/Zv6

Mosha commented on my last post on this topic that there was another simpler way of doing the same thing from SSMS. And that is to execute the following commands from an MDX window. First run ...<BeginTransaction xmlns="http://schemas.micro... /> and then...<Lock xmlns="http://schemas.micro... <ID>496CEC1F-D66A-4C8... <Object> <DatabaseID>Adventure Works DW</DatabaseID> ......

Share This Post:
Short Url: http://wblo.gs/UuX

I put the following code sample together in response to this question on the Analysis Services forum. If you read Books Online, you might think that running the following statement in SSMS would work : <Lock xmlns="http://schemas.micro... <ID>496CEC1F-D66A-4C8... <Object> <DatabaseID>Adventure Works DW</DatabaseID> </Object> <Mode>CommitShared<... But it will throw the following ......

Share This Post:
Short Url: http://wblo.gs/UpJ

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.

Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 11 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 111 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 155 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 247 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 303 days ago

darrengosbell @Technitrain I can see it too about 304 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 429 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 429 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 587 days ago

darrengosbell Really hard choice for this timeslot @Kjonge, @jenstirrup & @marcorus all have sessions at the same time. Lucky I ordered the DVDs #sqlpass about 587 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness

XMLA

SSAS: Automating the Scripting of an SSAS database

SSAS: Acquiring Locks using XML/A from SSMS - Part 2

SSAS: Acquiring Locks using XML/A from SSMS

News

Twitter

Tag Cloud

Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: