Are these dimensions on Lookup tables or Fact table? If lookup tables, you could use derived dimension. If fact table, would they both become filter? If yes, you can use joint aggragation group; if not, you may use ExtendedColumn measure. But this measure are not enabled on WebUI currently, I remembered a JIRA(KYLIN-1313) about this, but I cannot access JIRA at this moment, you can have a look if needed.
Thanks, Dong Li 2016-06-15 10:23 GMT+08:00 yu feng <[email protected]>: > derived dimension is a better choice. > > 2016-06-14 23:00 GMT+08:00 耳东 <[email protected]>: > > > hi all when I build the cube, there are always dimension like > > (city_id,city_name) or (terminal_id,terminal_name) and so on, which is > one > > to one relation. I don't want to let both id and name be dimension. How > can > > I make name a measure other than a dimension? >
