回复: what 's the difference between dimension types?

[liangmeng <13...@139.com>]

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
邮箱: liangmeng@gd.chinamobile.com  ，13802880779@139.com
地址：广东省广州市珠江新城珠江西路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
邮箱: liangmeng@gd.chinamobile.com  ，13802880779@139.com
地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 
邮编：510623