grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘XMLA’

SSAS 2005/2008: Creating Sub-Cubes Using XMLA, Variables, and Named Query Where Statements

Jul.14, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

I blogged a few weeks ago about creating Local Cubes with XMLA and ascmd.exe, and that is pretty cool, works great. There are some snags though if you use a server that is 64 bit. You can’t connect to the local cubes via .NET, Excel, or any other way. There are no drivers for local [...]

Comments | 1,565 views

Microsoft BI: Creating Local OLAP Cubes using XMLA and ascmd.exe

Jun.25, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

Most people, when using OLAP cubes, are hitting the live version that is located on SQL Server Analysis Services (SSAS). They hit it with Excel, or some other reporting tool, etc. I have blogged previously about offline cubes and how you could possibly use them.
Now, the blog I did before, I talked about creating [...]

Comments | 2,096 views

  

Business Intelligence, SQL, Geek, Music, Programming, and More!

Welcome to stevienova.com. This is my personal blog. I like to write about mostly geeky stuff (Programming, .NET, Microsoft, C#, SQL, Business Intelligence, iPhone, Apple, Mac, Networking, etc) and other stuff that I just run across and feel like posting up to the net!