On which port does the default instance of...

How many dimensions can you have in a...

Analysis Services Performance Tuning Whitepape

A whitepaper on getting the best performance from your system.

MDX Operators: The IsLeaf() Operator: Conditional Logic within Filter

In this article, we will examine IsLeaf(), once again as a conditional logic modifier, but within the context of a filter. Combining IsLeaf() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practical aspects of its employment in this way will serve to round out our overall awareness of the potential of IsLeaf().

MDX Operators: The IsLeaf() Operator: Conditional Logic within Calcula

In this article, we will concentrate upon the useful IsLeaf() operator, from the perspective of its use within a calculation. We will discuss the straightforward purpose of the operator, to ascertain whether a member is a leaf-level member of a dimension; the manner in which IsLeaf() manages to do this; and ways we can leverage the operator to support effective conditional logic to meet various business needs within our own environments.

MDX Numeric Functions: The .Ordinal Function

In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level.

Using Excel 2007 with Analysis Services

In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.

Storage Modes in SSAS 2005

Analysis Services and business intelligence are new structures for most of the SQL Server world. BI expert Yaniv Mor brings us another article on Analysis Services, this time explaining the various different options for storing your cube data.

Introducing Actions in Analysis Services 2005

In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.

Mastering OLAP Reporting: Prototype KPIs in Reporting Services

Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.