Microsoft SQL Server 2008 Analysis Services Unleashed
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £5.15
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Microsoft SQL Server 2008 Analysis Services Unleashed for an Amazon.co.uk gift card of up to £5.15, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes).
Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.
- Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)
- Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces
- Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
- Learn the key concepts of multidimensional modeling
- Explore the multidimensional object model and its definition language
- Integrate multidimensional and relational databases
- Build client applications to access data in Analysis Services
- Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
- Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
- Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
- Discover how Analysis Services manages memory
- Explore the security model, including role-based security, code-access security, and data security
Category: Microsoft SQL Server
Covers: Microsoft SQL Server 2008 Analysis Services
User Level: Intermediate-Advanced
$59.99 USA / $65.99 CAN / £38.99 Net UK±
From the Back Cover
As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes).
Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.
- Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)
- Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces
- Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
- Learn the key concepts of multidimensional modeling
- Explore the multidimensional object model and its definition language
- Integrate multidimensional and relational databases
- Build client applications to access data in Analysis Services
- Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
- Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
- Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
- Discover how Analysis Services manages memory
- Explore the security model, including role-based security, code-access security, and data security
Category: Microsoft SQL Server
Covers: Microsoft SQL Server 2008 Analysis Services
User Level: Intermediate-Advanced
$59.99 USA / $65.99 CAN / £38.99 Net UK±
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
Format:Paperback
I've taught myself SQL from books, and managed to get involved with a project to create a large data warehouse and various cubes off of that.
The project has been fascinating, but I realised that while I'm enthusiastic and have taught myself a lot, Analysis Services is a very complex offering. Sure once you've created a data warehouse you can put together a cube relatively easily, but there's much more to Analysis Services.
It's a big text book, but it's also surprisingly readable. I've started working through it so that I have a comprehensive understanding of the systems I'm using, but it's also great for looking up specific things, and yesterday I used it to establish how to set up security which effectively creates "sub-cubes".
I would highly recommend this book for anyone who is or will be working with Analysis Services, with the only note being that it will be (very) heavy going if you have literally no knowledge of data warehousing or Analysis Services.
The project has been fascinating, but I realised that while I'm enthusiastic and have taught myself a lot, Analysis Services is a very complex offering. Sure once you've created a data warehouse you can put together a cube relatively easily, but there's much more to Analysis Services.
It's a big text book, but it's also surprisingly readable. I've started working through it so that I have a comprehensive understanding of the systems I'm using, but it's also great for looking up specific things, and yesterday I used it to establish how to set up security which effectively creates "sub-cubes".
I would highly recommend this book for anyone who is or will be working with Analysis Services, with the only note being that it will be (very) heavy going if you have literally no knowledge of data warehousing or Analysis Services.
2 of 3 people found the following review helpful
Format:Paperback
A disappointing purchase. I've previously read Microsoft's "SQL Server 2005 Analysis Services - Step by Step" which was an excellent book. I decided to purchase this "Unleashed" version and was very disappointed. So many examples on using script to modify cubes when most sensible developers would be using Visual Studio most of the time. Too theoretical and not very practical. Currently gather dust. Definitely not for the beginner.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
12 reviews
10 of 10 people found the following review helpful
Excellent book for the internals of SSAS
9 Feb 2009
Format:Paperback
First, this book is not a tutorial. If you don't know SSAS and want to learn it, look elsewhere first and return to this book later.
What this book provides is an in-depth view of how Analysis Services really works. For those of us who spend most of our time working with Analysis Services, this book is invaluable for understanding how the engine behaves and why. You'll find details on processing, aggregations, attribute relationships, and virtually every other aspect of SSAS. The level of detail is exactly what you would expect from members of the SSAS team at Microsoft, which is to say it is very detailed and technical in nature.
There are five chapters on MDX that explain the subtleties of the various functions and how they perform. There are also chapters that delve into performance tuning, security, and administrative tasks. I highly recommend this book to anyone already familiar with SSAS because it contains valuable information not found anywhere else.
What this book provides is an in-depth view of how Analysis Services really works. For those of us who spend most of our time working with Analysis Services, this book is invaluable for understanding how the engine behaves and why. You'll find details on processing, aggregations, attribute relationships, and virtually every other aspect of SSAS. The level of detail is exactly what you would expect from members of the SSAS team at Microsoft, which is to say it is very detailed and technical in nature.
There are five chapters on MDX that explain the subtleties of the various functions and how they perform. There are also chapters that delve into performance tuning, security, and administrative tasks. I highly recommend this book to anyone already familiar with SSAS because it contains valuable information not found anywhere else.
25 of 31 people found the following review helpful
Wait for other SSAS 2008
4 Mar 2009
Format:Paperback|Amazon Verified Purchase
I have thousands of hours of experience with SSAS 2000 and 2005. I think that SSAS is one of the best (if unappreciated) Microsoft products.
I bought this book for one reason - it was the first one available. If you need one now, then get it. But be warned that it's not particularly good.
The key problem is that the authors are fascinated with XML. They use raw XML to explain a wide variety of concepts and tasks. For the authors and publishers, it has the benefit of wasting a lot of space. This fattens the book and makes it look like you are getting more for your money.
Unfortunately for the readers, the book is difficult to read and completely misses the point of the SSAS interface. XML is the underlying metadata structure of SSAS. That is the last place you should look to understand cube and dimensional structure, or for modifying how the cube works.
For a professional programmer (me), time is money and productivity is everything. First you should should use the graphical and tabular representation of metadata to manipulate the cubes and dimension. THEN, you write MDX functions when necessary. If all else fails, mess with the XML.
If you can wait a few weeks, there are two new books coming out for AS 2008. I believe either would a much better alternative to this book.
Don't waste your money buying this book like I did.
Regards,
Dan.
I bought this book for one reason - it was the first one available. If you need one now, then get it. But be warned that it's not particularly good.
The key problem is that the authors are fascinated with XML. They use raw XML to explain a wide variety of concepts and tasks. For the authors and publishers, it has the benefit of wasting a lot of space. This fattens the book and makes it look like you are getting more for your money.
Unfortunately for the readers, the book is difficult to read and completely misses the point of the SSAS interface. XML is the underlying metadata structure of SSAS. That is the last place you should look to understand cube and dimensional structure, or for modifying how the cube works.
For a professional programmer (me), time is money and productivity is everything. First you should should use the graphical and tabular representation of metadata to manipulate the cubes and dimension. THEN, you write MDX functions when necessary. If all else fails, mess with the XML.
If you can wait a few weeks, there are two new books coming out for AS 2008. I believe either would a much better alternative to this book.
Don't waste your money buying this book like I did.
Regards,
Dan.
8 of 9 people found the following review helpful
Needs an editor
9 Feb 2009
Format:Paperback
If this is the best SSAS book for the hardcore technologist, then I shudder to think what the worst one is.
I bought this book having no knowledge of the SSAS product or MDX. However my preference is for a theory-heavy book rather than a step-by-step introductory tutorial, so I would rather go straight for the jugular with the expert level book. To their credit the authors being deeply involved in the development of SSAS seem to know the product quite well, but their ability to explain concepts effectively and give you the big picture, enabling you to best construct an OLAP system with their product, is a bit lacking.
First, I'm puzzled how a book can go to mass production without someone at least running the text through the grammar checker--there are numerous grammatical errors throughout this book. The index also doesn't seem very accurate. I also found myself questioning the correctness of a couple code samples. These are but the first signs that the book was hastily written & published in an effort to be the first book to market on the 2008 version.
My second problem is with the ability of the authors to explain concepts of a technology that is foreign to people coming from the RDBMS mindset. MDX is an odd language, but many of their explanations & code samples often make the language even more confusing than is probably necessary. Let's take an example: in the cube-based mdx script chapter, they introduce the concept of static vs. named sets. They essentially explain it as such: "dynamic named sets are different than static named sets. Without explaining what a dynamic named set is, we'll just give you a code sample showing you the difference and hope you figure it out." While it is possible to then figure out the concept, I found myself very slowly reading the MDX chapters to try to both grasp the odd syntax of the language while understanding the subtleties of their cryptic code samples. Having gone through the MDX chapters I still don't think I know how to best use all the features of the language, and will probably only learn it by writing it.
Third, while it might not necessarily be the fault of this book, reading it makes me want to strangle whoever created MDX. Where is Anders Helsberg when you need him? This language is a mess. For example, we have a NON EMPTY operator and NonEmpty function being deceptively similar, yet different. Why not give them different names, just to make it a little less confusing? Also if the WHERE clause is so different from a SQL WHERE clause, why not call it something else? I get the feeling this language has gone through a few iterations to make it more SQL-like, and in so doing the original vision has been hijacked with "improvements" that only muddle it. My frustration with this book is it hasn't successfully enabled me to "get" the method to the madness of this language; i'm often distracted by its peculiarities.
One positive note, if you read carefully you will pick up some best practices, recommendations for optimizing performance, etc. It would've been nice to have a chapter dedicated to best practices, so if you don't have the time and need to skim, you can get the information quickly. However its there if you dig.
I bought this book having no knowledge of the SSAS product or MDX. However my preference is for a theory-heavy book rather than a step-by-step introductory tutorial, so I would rather go straight for the jugular with the expert level book. To their credit the authors being deeply involved in the development of SSAS seem to know the product quite well, but their ability to explain concepts effectively and give you the big picture, enabling you to best construct an OLAP system with their product, is a bit lacking.
First, I'm puzzled how a book can go to mass production without someone at least running the text through the grammar checker--there are numerous grammatical errors throughout this book. The index also doesn't seem very accurate. I also found myself questioning the correctness of a couple code samples. These are but the first signs that the book was hastily written & published in an effort to be the first book to market on the 2008 version.
My second problem is with the ability of the authors to explain concepts of a technology that is foreign to people coming from the RDBMS mindset. MDX is an odd language, but many of their explanations & code samples often make the language even more confusing than is probably necessary. Let's take an example: in the cube-based mdx script chapter, they introduce the concept of static vs. named sets. They essentially explain it as such: "dynamic named sets are different than static named sets. Without explaining what a dynamic named set is, we'll just give you a code sample showing you the difference and hope you figure it out." While it is possible to then figure out the concept, I found myself very slowly reading the MDX chapters to try to both grasp the odd syntax of the language while understanding the subtleties of their cryptic code samples. Having gone through the MDX chapters I still don't think I know how to best use all the features of the language, and will probably only learn it by writing it.
Third, while it might not necessarily be the fault of this book, reading it makes me want to strangle whoever created MDX. Where is Anders Helsberg when you need him? This language is a mess. For example, we have a NON EMPTY operator and NonEmpty function being deceptively similar, yet different. Why not give them different names, just to make it a little less confusing? Also if the WHERE clause is so different from a SQL WHERE clause, why not call it something else? I get the feeling this language has gone through a few iterations to make it more SQL-like, and in so doing the original vision has been hijacked with "improvements" that only muddle it. My frustration with this book is it hasn't successfully enabled me to "get" the method to the madness of this language; i'm often distracted by its peculiarities.
One positive note, if you read carefully you will pick up some best practices, recommendations for optimizing performance, etc. It would've been nice to have a chapter dedicated to best practices, so if you don't have the time and need to skim, you can get the information quickly. However its there if you dig.
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
