Topic: Denali
Drillthrough for #BISM Tabular and attribute keys in #SSAS #Denali
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 Read more
Parent-child special calculations in #BISM #Tabular #Denali
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 Read more
Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3
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 Read more
Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect
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, Read more
Detect Tabular or Multidimensional Version in #ssas #denali #ctp3
If you want to detect if a particular instance of Analysis Services “Denali” is running in Tabular or Multidimensional mode, you have several choices. In the Books On Line you can find a few instructions to detect the version by looking at the icon used Read more
First steps with #ssas #Tabular in #Denali #CTP3
The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and acronyms Read more