SQL 2005 DataWarehouse Note
来源:互联网 发布:mac os最高版本是多少 编辑:程序博客网 时间:2024/05/22 10:23
@2007 June 02
MS BI Studio
fact table (transaction table)
dim table (master file: product, customer)
BI Studio
1)Datasource: Delphi ADOConnection
2)Datasource View: ADOTable
3)Cube
4)Dimension
mainly involve: data source view, cube, dimension
Cube
N measures (sale, qty) from a fact table
N dimensions (produt, time)
=========================================
Task: Add a new cube without a datasource
=========================================
1)select AdvWorks standard edition
2)choose measures:
clear all
select internal sales amount, qty
3)choose dimension
4)define time period: year, quarter, month, Data is mandatory key column
5)add special calendar
6)relate dimension to measure
7)name and complete
click measure panel, select the target cube, set default measure to a valid one: internal sales amount
8)GENERATE a database table base on the cube
9)load data into the newly generated table
10)deploy. (the Analysis Service must be started)
Cube deploy located in <SQL Dir>/MSSQL.x/OLAP/Data/<Cube Name>
Similar to EJB container
11)complete and cube is ready for browse
OBJECT RELATIONS
DB engine: provide underlying data fact tables, dimension tables
Analysis Service: Cube container(similar EJB container)
BI Development Studio: Development tools(VS.2005), develop a cube and deploy it into Analysis Service directory.
SQL Mgmt Stduio: connect to Analysis Service Server and query the Cube with MDX
MS BI Studio
fact table (transaction table)
dim table (master file: product, customer)
BI Studio
1)Datasource: Delphi ADOConnection
2)Datasource View: ADOTable
3)Cube
4)Dimension
mainly involve: data source view, cube, dimension
Cube
N measures (sale, qty) from a fact table
N dimensions (produt, time)
=========================================
Task: Add a new cube without a datasource
=========================================
1)select AdvWorks standard edition
2)choose measures:
clear all
select internal sales amount, qty
3)choose dimension
4)define time period: year, quarter, month, Data is mandatory key column
5)add special calendar
6)relate dimension to measure
7)name and complete
click measure panel, select the target cube, set default measure to a valid one: internal sales amount
8)GENERATE a database table base on the cube
9)load data into the newly generated table
10)deploy. (the Analysis Service must be started)
Cube deploy located in <SQL Dir>/MSSQL.x/OLAP/Data/<Cube Name>
Similar to EJB container
11)complete and cube is ready for browse
OBJECT RELATIONS
DB engine: provide underlying data fact tables, dimension tables
Analysis Service: Cube container(similar EJB container)
BI Development Studio: Development tools(VS.2005), develop a cube and deploy it into Analysis Service directory.
SQL Mgmt Stduio: connect to Analysis Service Server and query the Cube with MDX
- SQL 2005 DataWarehouse Note
- datawarehouse
- sql note
- SQL note
- SQL note
- sql note
- sql note
- DataWarehouse Architecture
- Inside SQL Server 2005 -- T-SQL Querying read note
- SQL Note I
- note of SQL
- SQL knowledge Note I
- SQL Azure Note
- SQL2008 T-SQL Note
- PL SQL note.
- sql injection note day01
- ms sql study note
- Pro Oralce SQL[NOTE]
- IT 人士群聚喝酒的讲究
- C#委托示例
- 小电影: 用 MyEclipse 开发 Spring + Struts 的总结与操作视频(7分钟)
- C++中一个容易被忽视的名字查找规则
- Java中易混淆的概念
- SQL 2005 DataWarehouse Note
- 众多大牌安全产品测试结果不尽如人意
- 面向对象软件开发的十大原则
- 拖动表格
- 深入理解mysql之BDB系列(1)---BDB相关基础知识
- 思科重组技术开发部 强调以网络为核心
- 构建自己的轻量级XML DOM分析程序
- BONO:不走寻常路的服装直销
- Java解析XML文档——dom解析xml