"derived" means dimensions from lookup tables?(dim table),and "normal" means dimensions from fact tables? and can 'hierarchy' dimensions come from fact table?(i tryed, but it seemed not working) also, althought i define the join condition like: DEFAULT.DIM_CELL2.CELLID = DEFAULT.USERSERVICE.CELLID if i do not define a dimension like CELLID, i can not query the cube with sql: select dim_cell2.city,sum(userservice.up_bytes) as upflux from userservice inner join dim_cell2 on dim_cell2.cellid=userservice.cellid group by dim_cell2.city it said that there was not 'cellid' column in dim_cell2;
梁猛 中国移动广东公司 网管维护中心 网管支撑室 电话：13802880779 邮箱: [email protected] ，[email protected] 地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 邮编：510623
