grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘Offline OLAP’

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,092 views

Using Offline OLAP to Develop Cube Reports Without SSAS

Apr.18, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

One feature of Excel 2007 that I think is really cool, and also a little hidden, is the “Offline OLAP” feature.
If you insert a pivot table connected to an OLAP cube into Excel 2007, and go to the PivotTable Options Ribbon Menu, You will see the “OLAP Tools” Button. Click on that and then “Offline [...]

Comments | 2,734 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!