Titlebook: Pro SQL Server 2008 Analysis Services; Philo Janus,Guy Fouché Book 2009 Philo Janus and Guy Fouche 2009 Microsoft SQL Server.SQL.SQL Serve

破裂

User Interfaces,r, most of our work has been in BIDS, which isn’t exactly a user-friendly front end. So how do we get the value of our OLAP solutions out to “the general population”? In this Chapter we’ll look at the various front ends we can leverage to display the data in our cubes.

Factorable

nonchalance

不成比例

Creating Dimensions,n names give us the nomenclature we’ll use to break down our data, attributes will give us additional information about the members, and the members themselves provide the semantic points against which our measure data will be arrayed. Finally, well-designed dimension and attribute relationships will ensure the scalability of our cube solutions.

CARE

Building a Cube,e so far, we need to assemble the dimensions into a cube. That’s what we’re going to do in this chapter. In addition to building a cube from our dimensions, we’ll also look into calculated measures (deriving additional values from existing values), partitions (dividing data to ease management), and a deeper dive into aggregations and their design.

治愈

Deploying and Processing,er, we’re going to discuss what . actually means and the various ways of doing it. We’ll talk a bit about synchronizing databases between servers—similar to mirroring for transactional databases. Finally, we’ll talk about processing the various Analysis Services objects and how to schedule processing should you need to.

傻

Firefly

BRINK

CBC471

978-1-4302-1995-8Philo Janus and Guy Fouche 2009