Digging into the blog post from earlier this summer I wanted to see what was new and exciting in Excel 2010. Recently I have been working on an cube and we want to be able to budget right from the cube. There are also many other cubes/scenarios where the ability to writeback to the cube [...]
View Comments | 2,394 views
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 [...]
View Comments | 2,846 views
Ok, I just spent a few hours debugging a cube that wasn’t bringing back any data. Checking all the relationships, the source data, the marts, etc, etc. And lo and behold, find out that a colleague commented out all the calculations, including the CALCULATE statement which says: The CALCULATE command controls the aggregation of leaf [...]
View Comments | 1,520 views
