create table TestOrganization
(
id int,
name varchar(20),
p_id int
)
2.插入测试数据
insert into TestOrganization values (1,'总经理',null);
insert into TestOrganization values (2,'经理',1);
insert into TestOrganization values (3,'人事',1);
insert into TestOrganization values (4,'财务',1);
insert into TestOrganization values (5,'开发主管',2);
insert into TestOrganization values (6,'网管',2);
insert into TestOrganization values (7,'开发组长',5);
insert into TestOrganization values (8,'开发人员1',7);
insert into TestOrganization values (9,'开发人员2',7);
insert into TestOrganization values (10,'前台',3);
2 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-03-27 回答
赞同来自: Evan 、天涯浪子
1. 建表
2.插入测试数据
3、建ssas
**4、在用刚才维度选项右边的浏览器看一下结果。
**
Evan 2014-03-26 回答
赞同来自:
http://database.51cto.com/art/201108/283318.htm
http://blog.csdn.net/jzdzhiyun ... 20674
http://database.51cto.com/art/201108/283318.htm
有具体的疑问就继续提吧