Topic: SSAS
-
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
-
Darren Gosbell describes a useful technique to clear cache and execute an MDX statement using a single MDX command window. It's very very useful when you're doing performance tuning of your MDX script! 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
-
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given 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