AS Guide

Post Reply
User avatar
jim wood
Site Admin
Posts: 3590
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

AS Guide

Post by jim wood » Fri Jul 11, 2008 8:33 am

Guys,

Could anybody recomend a good guide to either download / buy?

Cheers,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Mike Cowie
Site Admin
Posts: 439
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: TM1, MSAS
Version: Anything thru 11.x
Excel Version: 2003 - 2016
Location: Alabama, USA
Contact:

Re: AS Guide

Post by Mike Cowie » Fri Jul 11, 2008 3:30 pm

Hi Jim,

Are you looking for Analysis Services for SQL 2000, 2005 or 2008? I have Professional SQL Server Analysis Services 2005 with MDX by Harinath & Quinn from Wrox, which isn't too bad. I would imagine that Analysis Services in SQL 2008 books are probably not that well-revised if they're already in print - but, there haven't been really significant changes to Analysis Services in 2008 vs. 2005 as best I can tell so maybe that doesn't matter. You may be able to get some SQL 2000 Analysis Services books more cheaply, but if you're using SQL 2005 I wouldn't do that since SQL 2000 vs. 2005 Analysis Services is quite different.

I think there are some books mainly about MDX that you can get as well, and I'm sure there are some bloggers/websites out there that have reviewed far more books on the subject that you could hunt down via google. I also tend to read the reviews on places like Amazon when considering what to get for technical books.

Regards,

Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Re: AS Guide

Post by Marcus Scherer » Sun Jul 13, 2008 3:07 pm

Hi,
some sources may help you:
- "Delivering Business Intelligence with Microsoft SQL Server 2005" by Brian Larson. It covers the ETL steps as well. SSAS is not only about MDX but SQL as well.
- "MDX Solutions" by Spofford et al. Single chapters are very good and the appendices are essential. But the book is not a good starting point because of examples that don't fit together.
- MSDN library.
- Learning modules inside SQL Server (Adventure Works database)

Cheers,
M.

User avatar
jim wood
Site Admin
Posts: 3590
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: AS Guide

Post by jim wood » Mon Jul 14, 2008 6:49 am

Thanks Guys,

I have been out and bought "Fast Track to MDX" By Whiteborn, Zare & Pasumansky. It seems ok. It covers all of the MDX angles but I may need to fill some the other areas with something else.

I have also started to have a look a MSDN. Somewhere I don't normally like to go, but in this case it seems to be ok. (I have found it pain for Excel.)

As for version I've only got 2000 at the moment. It looks like a may have to try to get hold of a version of 2005.

I shall plough on. Wish me luck....

Jim.

PS. The book I bought come with a trial version of ProClarity. Now there's a name I hadn't heard for a while.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Re: AS Guide

Post by Marcus Scherer » Mon Jul 14, 2008 8:01 pm

Jim,

I wouldn't spend too much time with AS2000. There's a difference in MDX (attribute hierarchies and natural hierarchies in SSAS2005) as well as on the ETL side (DTS for SQL 2000 is different from SS Integration Services 2005). You would have to start with 2005 nearly from scratch any way.

Cheers,

M.

Post Reply