-
Error code: 0x80040E21 Reading from SSAS with SSIS
So, I upgraded a big project for a customer to 2012 from 2008R2. Everything worked fine, except the last part, where some datamarts was loaded with SSIS from SSAS. They had worked with no problem before, but suddenly, I received the above error code. It made no sense to me, and it was hard to… Continue reading
-
SSAS Tip -> Format seconds as HHHH:MM:SS
A common way of showing durations in SSAS, is to format them as HH:MM:SS. A common scenario is to store the durations in seconds. To display them in the HH:MM:SS format, first we have to convert the duration to hours, and then put on the format, like so CREATE MEMBER CURRENTCUBE.[MEASURES].[someMeasure] AS [Measures].[someMesureInSeconds]/86400,FORMAT_STRING = “HH:MM:SS”,… However,… Continue reading
-
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
