Tracy.Bai

Focus on Data analysis and Mining

导航

随笔分类 -  data warehouse

sql server 2005 analysis service step by step(三)：创建父子维度
摘要：1.什么是父子维度。 the parent-child relationship in the table that the wizard detected by the self-referencing join on the table.例如在Dim.Employee表中有个外键是ParentEmployeeKey,她关联的主键就是.Employee表的EmployKey建。 2. 创建父子维... 阅读全文

posted @ 2009-04-27 22:47 Love Fendi 阅读(455) 评论(0) 推荐(0)

sql server 2005 analysis service step by step(二)：创建时间维度
摘要：1. In Solution Explorer, right-click the Dimensions folder, click New Dimension, and then click Next. 2. Clear the Auto Build check box, and then click Next. 3. Click the SSAS Step by Step DW DSV, and... 阅读全文

posted @ 2009-04-26 21:30 Love Fendi 阅读(670) 评论(0) 推荐(0)

sql serve 2005 analysis service step by step(一)：创建标准维度
摘要：一. add a datasource 新增数据源 Add a data source to an Analysis Services project1. If necessary, start SQL Server Business Intelligence Development Studio (BIDS).2. On the File menu, point to New, and then... 阅读全文

posted @ 2009-04-23 21:48 Love Fendi 阅读(511) 评论(0) 推荐(0)