No, only columns that defined as dimension or measure can be queried from the cubes; Other column will be filtered;
On 6/29/15, 12:22 PM, "liangmeng" <[email protected]> wrote: >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
