one more question: if some attributes in dim table(lookup table) are not defined as dimensions in kylin, so we can query them in the cube query?
梁猛 中国移动广东公司 网管维护中心 网管支撑室 电话：13802880779 邮箱: [email protected] ，[email protected] 地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 邮编：510623 发件人： liangmeng 发送时间： 2015-06-29 09:29 收件人： dev 主题： what 's the difference between dimension types? "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
