Stairway to SSAS?


Love the existing Stairways, and have used the learnings in much of my work.

I am now getting into the world of SSAS and am wondering if there exists, or are there plans to create a Stairway for SSAS?

Best Regards,


more ▼

asked Oct 05, 2012 at 12:37 PM in Default

avatar image

50 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Thanks for your comments and it's great to have feedback about content across SQL Server Central. Someone from SQL Server Central or RedGate will be able to inform you if there are plans to create the Stairways that you suggest.

While you are waiting for their response would you have any specific techniques that you'd like to see covered? If you are early enough you may be able to guide how the stairway is written!

more ▼

answered Oct 08, 2012 at 09:11 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

Well it is, I am finding, a far more complex aspect of BI than anything else I have done. I would be particularly interested in seeing sections on the use of Surrogate Keys, How Hierarchies are created, a section on how to make the transition from from an OLTP background (i.e. relational) to Dimensional, How to use cubes in SSRS and optimization of the OLAP environment, as it relates to query performance.

Best Regards,


Oct 11, 2012 at 01:37 PM teetime
(comments are locked)
10|1200 characters needed characters left

Hi Dave,

We are looking to commission an SSAS Stairway, but right now we haven't found an author for it - we want the stairways to be as good as possible, so we're not rushing them out, but rather building them up slowly with a lot of tech reviewing, editing, etc...

Hopefully there will be one before too long, but we have a lot of topics that we want to cover...


Dave C

more ▼

answered Oct 12, 2012 at 09:26 AM

avatar image

DaveC ♦♦
1.8k 4 6 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 05, 2012 at 12:37 PM

Seen: 1821 times

Last Updated: Oct 12, 2012 at 09:26 AM

Copyright 2018 Redgate Software. Privacy Policy