-
Analysis services -> Clear Cache
Just a short note about analysis services and its cache 🙂 One of the reasons for analysis services fast respond time is its cahce. But what if you want to test a query without using the cache? Well, just use this XMLA Script: Also, if you do partial processing, the cache, can in some cases… Continue reading
-
OLE DB error: OLE DB or ODBC error: Invalid column name ‘x’.; 42S22.
After spending time debugging my analysis services cube for the second time having this error, I guess it will be a good idea to blog about it, so I can remember it to another time 🙂 I got the above error after I had modified a dimension, so used it three fields for the key,… Continue reading
-
Comparing Analysis Services and Power Pivot
We are in a period in time where MS soon will be releasing a lot of (new) BI technologies, such as sharepoint 2010 which contains among other things: excel services, performance point services and hosting of powerpivot. I guess office 2010 will be released the same date as sharepoint 2010, and here we also have… Continue reading
