September 2010
Beginner to intermediate
424 pages
12h 17m
English
book
Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Content preview from Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Editing Your Cube
With your dimensions now complete, to finish the base cube development you’ll need to modify the
measure groups. In this lesson you’ll learn how to format the cube to make it more usable for your
end users. You’ll also see how to browse your cube using the simple browser built into the BIDS
environment.
The examples in this lesson start where we left off in Lesson 14. If you didn’t
do the last lesson, you can download the starting point (Lesson14Complete.zip)
from this lesson’s download on
www.wrox.com.
CUBE EDITOR TOUR
To open the Cube Editor (Figure 15-1) double-click the .cube file from the Solution Explorer.
Once it is open you’ll see the Data Source View, which makes up the cube in the right pane.
Yellow items are fact tables and blue items are dimensions. Green tables represent dimensions
that are also fact tables.
On the bottom left you can find a list of the dimensions and their attributes. Finally, on the
top left you can find the measure groups and each of the measures. In this pane you’ll be able
to set the measure properties, such as how the numbers should be rolled up.
You’ll notice that in the Dimensions pane on the left there are multiple date dimensions
(Order Date, Ship Date, and Due Date). These appear to the end user as three different
dimensions with the same attributes, which they can drag over when querying. Each of these
is called a role-pla
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.