In this 30-minute video, part of our Cube Design series, Chris Webb explains SQL Server Analysis Services security. You will learn about administrative and data security, the latter on three levels: at cube, dimension hierarchy, and at cell levels.

Chris Webb introduces the subselect in this short 3-min video. It uses an MDX SELECT statement instead of a cube’s name, and it allows you to pre-filter the members on a hierarchy before you run a query.

MDX has a lot of set and member functions that make it easy to create all kinds of advanced common business calculations. Watch this full-length, 1-hour 40-minute, demo-rich video by Chris Webb to learn how to compute important business reporting metrics using MDX. You will learn about: ParallelPeriod(), PeriodsToDate(), YTD(), QTD(), MTD(), Filter(), NonEmpty(), TopCount(), BottomCount(), TopPercent(), BottomPercent(), Head(), Tail(), Generate(), StrToX/XToStr function family.

The CurrentMember function is, probably, the most important function in MDX: understanding how it works is the key to being able to write all kinds of really useful calculations in MDX, such as time intelligence calculations. Let Chris Webb, noted authority on MDX, explain this function to you in this short, free video.

Being able to think in sets is the key to being able to write more advanced queries and calculations in MDX. Chris Webb introduces the commonest MDX functions that return sets in this 40-minute, demo-driven video, including: .MEMBERS, CROSSJOIN(), .PARENT, DESCENDANTS( ), ANCESTOR(), .NEXTMEMBER, .PREVMEMBER, .LEAD() and .LAG(). You will need these functions for rudimentary navigation using MDX.

Calculated members are the most commonly used way of performing calculations in MDX. Let Chris Webb explain the different ways in which they can be created in this 45-minute video, part of our online MDX course.

Carmel Gunn, a Data Management Specialist from Prodata introduces fundamental concepts of Excel BI: measures, dimensions, attributes, and hierarchies, while explaining how to use them in your pivot tables. In the extensive, 30-min demo, you will also learn about the layout of the Excel BI tools, including the Pivot Table Fields List and its Fields Section, the Design ribbon, and even how to add a new calculated measure.