Connect to a Remote SSAS 2005 Database

Connecting to a SQL Server 2005 database is a simple process, but connecting to an Analysis Services 2005 database takes a bit more effort. Longtime data warehousing author Jacob Sebastian brings us a quick tutorial on how you can connect from Management Studio.

Creating a Basic SSAS Cube

In this demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube.

SQL Server Profiler for Analysis Services

Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.

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.