For question 1), in Cube's "advanced setting" step, you can specify the cuboid whitelist to build.
2018-08-13 22:26 GMT+08:00 Billy Liu <[email protected]>: > Hello Shrikant, > > For 1, seems the 4 dimensions are hierarchy structure. You could > define them as hierarchy dimensions in Cube, and leave A as mandatory > dimension. > > For 2, select 'user_activity' as partition column in model design. > There are a few built-in formats, most date types are supported. > > With Warm regards > > Billy Liu > Shrikant Bang <[email protected]> 于2018年8月13日周一 下午5:39写道： > > > > Hi Team, > > > > We are doing a PoC on building OLAP cubes. Could you please help me > to get answer of below queries? > > > > Selective Cuboids: > > We need to have selective cuboids as part of OLAP cubes. > > Let say if we have 4 dimensions : A, B, C, D then we need just > (A,B,C,D) , (A,B,C), (A,B) and (A) > > > > Refresh Settings: > > How to specify partition column and format while building cube for fact > table. > > e.g. user_activity is partitioned by date 'yyyy-MM-dd' and cube should > be refreshed everyday with previous day's computation. > > > > > > Thank You, > > Shrikant Bang > > > -- Best regards, Shaofeng Shi 史少锋
