Blog

Know-how von Experten für Experten

BI & Big Data Blog

12.04.2009
Technical Value
SQL Server 2008 Vidas Matelis posted an overview of the SSAS performance counters at ssas-info.com . You can find the complete list here: http://www.ssas-info.com/analysis-services-articles/58-ssas-2008/1113-analysis… Weiterlesen
21.03.2009
Technical Value
SQL Server 2005 | SQL Server 2008 In my last post I wrote about context sensitive formatting. The goal was to format values differently depending on their digits, so that for example. 532 formats to 532 but 143,134… Weiterlesen
17.03.2009
Technical Value
SQL Server 2005 | SQL Server 2008 It's commonly known that you can provide a format string for measures like in the following example: with MEMBER [Measures].[Sales Amount Fmt] AS  [Measures… Weiterlesen
23.02.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Many of us are not aware of the BI functionality in the other office programs like in Visio. And although I prefer the pivot functions of Excel you should take a look at these… Weiterlesen
15.02.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Deploying an OLAP application using deployment scripts is a common scenario in larger development environments. Of course we can use XMLA scripts to do the deployment but running the… Weiterlesen
25.01.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Stored procedures offer a really powerful extensibility for Microsoft OLAP. But the more complex the functions get, the more you need debugging capabilities. Of course you will want… Weiterlesen
25.01.2009
Technical Value
SQL Server 2005 | SQL Server 2008 There is a nice example for an Excel add-in to enhance the abilities of the Excel pivot table with features like displaying the MDX query, adding calculated members or searching in… Weiterlesen
29.12.2008
Technical Value
SQL Server 2005 | SQL Server 2008 There had been some posts discussing the multi select problems in MDX. If, for example, you have a calculated measure using CURRENTMEMBER, the measure might not be computable when… Weiterlesen
05.12.2008
Technical Value
SQL Server 2005 | SQL Server 2008 Being able to specify the preferred format for measures and calculated measures in SSAS is a great feature since you just do the definition once and clients can leverage this central… Weiterlesen
15.11.2008
Technical Value
SQL Server 2005 | SQL Server 2008 In the last post we had a very simple time dimension with a non-natural hierarchy. In this post I show how to turn this hierarchy into a natural hierarchy. The basic idea is to… Weiterlesen
28.10.2008
Technical Value
Setting proper attribute relationships for the attributes of a dimension is essential for query performance and usability. As Mosha wrote in his blog, it might be the most important advice for cube designers to set the… Weiterlesen
07.10.2008
Technical Value
SQL Server 2005 | SQL Server 2008 In my last post I had an example for a function to return a single value from an MDX query which has certain performance drawbacks when being used in many Excel fields. Since Excel… Weiterlesen

Newsletter Anmeldung

Abonnieren Sie unseren Newsletter!
Lassen Sie sich regelmäßig über alle Neuigkeiten rundum ORAYLIS und die BI- & Big-Data-Branche informieren.

Jetzt anmelden