Browse by Tags

• Analysis Services
• BIDS
• BISM
• CTP3
• DAX
• MDX
• PowePivot
• PowerPivot
• SSAS

• 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... Posted Thursday, August 18, 2011 12:18 AM by Marco Russo (SQLBI) | 1 Comments Filed under: BISM, Denali, SSAS

• 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... Posted Friday, July 22, 2011 10:55 AM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, DAX, Denali, PowerPivot

• 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... Posted Wednesday, July 20, 2011 10:01 AM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, BIDS, BISM, CTP3, Denali

• 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... Posted Tuesday, July 19, 2011 10:24 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BIDS, BISM, CTP3, Denali, MDX, PowePivot, SSAS

• 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... Posted Monday, July 18, 2011 11:15 AM by Marco Russo (SQLBI) | 7 Comments Filed under: Analysis Services, CTP3, Denali

• 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... Posted Thursday, July 14, 2011 7:25 AM by Marco Russo (SQLBI) | 2 Comments Filed under: Analysis Services, BIDS, CTP3, DAX, Denali, SSAS