Topic: SSAS

Page 29 of 408 results
  • MDX Studio

    My backlog makes me late on a lot of announcements, but I'd like to post a link to the new MDX Studio by Mosha Pasumansky , because this is a very useful tool when you need to dig into an MDX query issue. There is a forum dedicated to the tool on SSAS  Read more

  • Microsoft released a short whitepaper about how scaling-out queries to a SSAS database leveraging on SAN snapshot features . It's an interesting read if you have a SSAS database with many users and don't have the time to copy a database on several servers  Read more

  • I fixed an issue of the DateTool dimension I presented in a previous post . The DateTool was unusable on OWC 11, which is the component used by BI Dev Studio and SQL Server Management Studio to browse a cube. I only added two statements in MDX Script  Read more

  • Alberto posted one of the patterns we use designing a dimensional model (this one is about the discretization of a measure into a dimension). We'd like to get some feedback about this solution: is there someone who used similar patterns? We consider this  Read more

  • A ranged dimension is a dimension that is used to have a discrete view of a continuous measure. A good example of this is the analysis of amount sold per order. In AdventureWorks we have, for each line of an order, the amount and quantity sold. We would  Read more

  • Microsoft has released a valuable white paper with a self-explaining title: SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services . The document has a part of explanation of  Read more

  • Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write: SCOPE ( Measures. AllMembers ); FORE_COLOR ( THIS ) = IIF ( Measures.  Read more

  • BI Developer Studio does a lot of automatic changes when you change something. Each dimension is stored in a separate file, but many of the dimension informations are copied into cube files. When you modify a dimension which is already used by one or  Read more

Show more