Re: question about joint dimensions
I see, it cannot use old cube data if we want to add new aggregation group to speed up query. 2017-10-27 9:18 GMT+08:00 ShaoFeng Shi : > You can disable the cube, purge the data, edit it to add new group, and > then rebuild it. > > Or you can clone it into a new cube, and then make the change on it. After > the new cube is ready, disable the old one. > > 2017-10-26 16:31 GMT+08:00 杨浩 : > > > Thanks for your explanation. If we want to add new aggregation group , > what > > should I do? > > > > 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi : > > > > > Hi hao, > > > > > > It will go to the base cuboid: ABCDE, and aggregate D at running time. > So > > > in theory, it can answer all combinations even if you customized the > > > groups. > > > > > > 2017-10-25 14:58 GMT+08:00 杨浩 : > > > > > > > I have used aggregation groups to reduce cuboids, but it seems not > take > > > > effect. A table has dimension A, B, C, D, E, and set this aggregation > > > > groups: > > > > group 1: A,B,C which has joint dimensions A,B,C > > > > group 2: A,B,D which has joint dimensions A,B,D > > > > group 3: A,B,E which has joint dimensions A,B,E > > > > but I can query the table using "group by A B C E" , is it OK? > > > > > > > > > > > > > > > > -- > > > Best regards, > > > > > > Shaofeng Shi 史少锋 > > > > > > > > > -- > Best regards, > > Shaofeng Shi 史少锋 >
Re: question about joint dimensions
You can disable the cube, purge the data, edit it to add new group, and then rebuild it. Or you can clone it into a new cube, and then make the change on it. After the new cube is ready, disable the old one. 2017-10-26 16:31 GMT+08:00 杨浩 : > Thanks for your explanation. If we want to add new aggregation group , what > should I do? > > 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi : > > > Hi hao, > > > > It will go to the base cuboid: ABCDE, and aggregate D at running time. So > > in theory, it can answer all combinations even if you customized the > > groups. > > > > 2017-10-25 14:58 GMT+08:00 杨浩 : > > > > > I have used aggregation groups to reduce cuboids, but it seems not take > > > effect. A table has dimension A, B, C, D, E, and set this aggregation > > > groups: > > > group 1: A,B,C which has joint dimensions A,B,C > > > group 2: A,B,D which has joint dimensions A,B,D > > > group 3: A,B,E which has joint dimensions A,B,E > > > but I can query the table using "group by A B C E" , is it OK? > > > > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi 史少锋 > > > -- Best regards, Shaofeng Shi 史少锋
Re: question about joint dimensions
Thanks for your explanation. If we want to add new aggregation group , what should I do? 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi : > Hi hao, > > It will go to the base cuboid: ABCDE, and aggregate D at running time. So > in theory, it can answer all combinations even if you customized the > groups. > > 2017-10-25 14:58 GMT+08:00 杨浩 : > > > I have used aggregation groups to reduce cuboids, but it seems not take > > effect. A table has dimension A, B, C, D, E, and set this aggregation > > groups: > > group 1: A,B,C which has joint dimensions A,B,C > > group 2: A,B,D which has joint dimensions A,B,D > > group 3: A,B,E which has joint dimensions A,B,E > > but I can query the table using "group by A B C E" , is it OK? > > > > > > -- > Best regards, > > Shaofeng Shi 史少锋 >
Re: question about joint dimensions
Hi hao, It will go to the base cuboid: ABCDE, and aggregate D at running time. So in theory, it can answer all combinations even if you customized the groups. 2017-10-25 14:58 GMT+08:00 杨浩 : > I have used aggregation groups to reduce cuboids, but it seems not take > effect. A table has dimension A, B, C, D, E, and set this aggregation > groups: > group 1: A,B,C which has joint dimensions A,B,C > group 2: A,B,D which has joint dimensions A,B,D > group 3: A,B,E which has joint dimensions A,B,E > but I can query the table using "group by A B C E" , is it OK? > -- Best regards, Shaofeng Shi 史少锋