I got some more information about Gemini. As Mosha said, it is Analysis Services. As you know, SSAS has always been available also as a client tool, using the same engine of the server product to create local cubes. The Kilimanjaro release will add several features to this engine that, integrated with the client part of Gemini (which allows end ...

Mosha released a new version of MDX Studio (0.4), which offers an ''MDX Analysis'' function that suggest best practices for a given MDX query. I tried the tool with some MDX query and it offers very good suggestion (when possible with link to further information about the issue) for both the MDX beginner and the MDX veteran. Sometime, the ...

More than one year ago I published a paper about design patterns for many-to-many dimension relationships. Since then, I built other models and I got more experience about possible performance optimizations. Unfortunately, I still hadn't time to write about it and this topic requires verbose document and analysis to be reproducible and ...

Today I discovered that DefaultMember might result in a member other thant the default dimension member. Reading documentation, I got the idea that DefaultMember would be always the default member defined for a dimension into a cube. In reality, the default member could change into a subcube that excludes the original default member from a ...

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 that you might have a server-side feature doing that (so you don’t discriminate Excel users). ...

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.CurrentMember < 0, 255, 0); // 255 = RED END SCOPE;  MDX Script is so better than ...

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 more cubes in the same project, the editor automatically updates many of these informations. Each ...

I just found that this query has different behavior (with breaking differences in result) with different builds of Analysis Services 2005. This is the query (I used a bitmap because this query throws an error when I try to put it in text in Community Server blog - if someone want to check this other issue...): With Analysis Services 2005 ...

Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer. It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank you Chris, if I only had this tool three months ago! :-) Chris has also posted the news of an ...

I just posted this bug on the Microsoft Connect site. Please vote it if you think it would be a useful change. This is the issue description. If you set the''Aggregation Usage'' to true for an attribute of a dimension (i.e. Customer), you cannot run the aggregation design wizard on a partition of a measure group that is not linked to ...