Re: Queries For Building Cube

2018-08-15 Thread Shrikant Bang
Thank you, ShaoFeng & Billy for responses. I could able to set hierarchies in dimension. While building cube, step "fact distinct column" job is failing in a reducer with Out Of Memory exception. java.lang.OutOfMemoryError: Java heap space at java.util.IdentityHashMap.resize(IdentityHashMap.java

Re: Queries For Building Cube

2018-08-13 Thread Billy Liu
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. Wi

Queries For Building Cube

2018-08-13 Thread Shrikant Bang
Hi Team, We are doing a PoC on building OLAP cubes. Could you please help me to get answer of below queries? 1. 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) an