PowerPivot BlogRoll – 13th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 13th January 2013.   The New Internal Data Model in Excel 2013 – bit.ly/VFumXvk New Customers Per Day Generalized to “New Customers per Month,” etc. – bit.ly/RP7EeK PowerPivot User Experience Survey – t.co/aGlhdPu7 New Customers per Day – bit.ly/VJtD7j Getting the active products between a date range using DAX – bit.ly/VDT7AH [Update] What is using all that memory on my Analysis server instance? – bit.ly/T51Hsc Parameterising PowerPivot Connection Strings in Excel 2013 – bit.ly/XKBOTH Technitrain 2013 Course Schedule: SSAS, PowerPivot, MDX, SSIS, TSQL and SQL … Continue reading PowerPivot BlogRoll – 13th January 2013

CUBEs For Dessert

Microsoft sneaked a couple of ne Introduction A few weeks ago I showed how to create a fully dynamic table using CUBE formulae against a PowerPivot model in Cooking With Cubes.This example presented data from the AdventureWorks database of sales of product categories over years, all integrated with a Fiscal Year slicer. I recently had a similar need, but with the further challenge of presenting two levels in a hierarchy (actually, this was related tables in a snowflake schema). I needed to show all of the items in the first level, and for each of these items, all of the … Continue reading CUBEs For Dessert