In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL Server “Denali”. In the current CTP3 you can already use the drillthrough on a Tabular model: by default, all the columns of ...

Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child hierarchy) and the other is the Sum of Children (computes all the nodes that are descendants ...

When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot open the BIM file. Reason: The workspace database server ‘localhost’ was not found. Verify that there is ...

If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the ...