Tham khảo tài liệu 'pro sql server 2008 analysis services- p4', 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 6 CREATING DIMENSIONS Figure 6-16. Setting the deployment server 18. Select the Build menu and then Deploy SSAS AdventureWorks to deploy the solution to the server. 19. Now either click the Process button or choose Dimension Process. 20. When the Process Dimension window comes up click Run. We ll dive into this window in depth in Chapter 8. 21. Now we can browse our dimension. In the dimension designer click the Browser tab. 22. You should see a single member labeled All. Expand it by clicking the icon next to it. You should see something like Figure 6-17. 131 CHAPTER 6 CREATING DIMENSIONS Figure 6-17. Our new dimension 23. That s odd. Hold on look at the Hierarchy selection. These are the available Discount Percentages. Change the selection to Promotion Key and open the tree again Figure 6-18 . 132 CHAPTER 6 CREATING DIMENSIONS Figure 6-18. The promotions in the dimension 24. This looks more like a list of dimensions. So how do we make them come up first We ll use a little trickery. Let s also clean up the dimension a bit. Click the Dimension Structure tab again. 25. Right-click English Promotion Category select Rename and rename it Category. 26. Similarly rename English Promotion Type to Type and Promotion Key to Promotion. 27. Now we re going to create a hierarchy. Drag Category to the Hierarchies section in the middle of the designer. This will create a Hierarchy container. Drag Type to the new level area under Category. 28. Finally drag Promotion under Type. 29. Right-click Hierarchy and select Rename. Rename the hierarchy Promotions. It should look like Figure 6-19. .
