Hi I've done some test for comparison with cognos which we used for olap. Below is one case:
Fact table size: 500M Dimension: 19( 16 derived, 3 normal) Measure: 56 Cognos building this cube in about one hour with a 1.2G cube file. While in kylin, cube size is already up to 64G with 10 Dimensions and 20 Measures. If i understand right, the cube size will double at least for each additional dimension. As to the test case, cube size is estimated in TB which is beyond our expectations greatly. So, is there any test report we can refer to for comparison with traditional olap tools like cognos, if so, please let me know, it will be very helpful. Looking forward to reply. Thanks
