-
Recent Posts
Tag Cloud
analytics BI Bing Maps Churn CIMA Context correlation CRM Data shaping Data Warehouse Date DAX Dirty data EARLIER Excel Excel Hell Except Facts Filter Forecasting Hierarchies Leadership linkedin MDX modelling OLEDB Performance management Pivot Tables Power Pivot PowerPivot Rank Role Playing Tables Self Service Sort Order Spatial SQL SSBI SSDI SSRS statistics STDEV Talk Time Management Top N VBABlogroll
Meta
Tag Archives: OLEDB
Querying Analysis Services with VBA
Many people use excel pivot tables as a means of retrieving data from an Analysis Services OLAP cube. This is okay for most situations where you want a quick way of retrieving data for analytical purposes. However, there is a different way to do … Continue reading