TAILIEUCHUNG - Pro SQL Server 2008 Analysis Services- P5

Tham khảo tài liệu 'pro sql server 2008 analysis services- p5', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 7 BUILDING A CUBE Many-to-Many If we wanted to define a relationship between customers and products we would have to use a many-to-many relationship one customer can be related to many products one product can be related to many customers . To define the relationship you ll need to select the intermediate measure group and then the tables necessary to make the connection. Data Mining A relationship necessary for a data-mining dimension. We ll cover this in more depth in Chapter 13. This may all seem like a hassle but it becomes very important to have this kind of control when we start looking at more-complex cubes such as the AdventureWorks cube. A portion of the dimension usage table from AdventureWorks is shown in Figure 7-15. Note the dimensions that are marked as no relation with various measure groups. For example the Sales Reasons group is associated with only the Sales Reason and Internet Sales Order Details dimensions. Figure 7-15. The dimension usage table for the Adventure Works cube Having these measure groups and dimensions in a single place can make both development and maintenance easier and it also provides end users an ability to combine data in a single report for example Internet Sales vs. Reseller Sales . If these measure groups were in separate cubes many tools couldn t handle mapping to them both. We ve talked about measure groups a lot. Let s dig more deeply into them. 181 CHAPTER 7 BUILDING A CUBE Measures and Measure Groups We ve covered the concept of measures quite a few times measures are the numbers our users are after to analyze. They re numbers. In OLAP they re generally aggregated in some way so that we can look at various breakdowns of values. In BIDS you can find all the measures and measure groups in a cube on the left side of the Cube Structure tab as shown in Figure 7-16. Figure 7-16. The Measures pane in BIDS Measures Measures are our numbers. Dimensions are around the edge measures are in the middle and where we re .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.