I'll count 4, including DimA, DimC1, DimC2, and DimC3. Derived dimensions are reconstructed at query time, thus don't affect build time and cube size.
An easy way is to use number of columns in rowkey as an measure of "num of dimensions". BTW, if you know how to tune your cube via proper aggregation group settings, it's not impossible to go beyond 16 dimensions. We have many such cubes in production, with max build time less than 2 hours. Best Regards, Dayue > 在 2016年6月8日，下午4:17，251469031 <[email protected]> 写道： > > Hi all: > > > As was shown in some ppts about kylin, the max num of dimensions may less > than 16, or they would lead to large time-cost during cube building. > > > If I have the following dimensions, what's the total num of dimensions: > > > > 1 normal dimension: DimA > 1 derived dimension: DimB, and the derived columns are dimB1 and dimB2 > 1 hierarchy dimension: DimC, and the levels are dimC1, dimC2 and dimC3
