Can you pls. advise on this case - I have Cube built on for below case - It has 234 dimension(224 dimensions are for Derived & 10 dimensions from Fact table which are normal one).
Fact table - 1 Dimension/look up table - 9 [ All these are linked to Fact table column Mapping] ________________________________ Model Name Data_model Cube Name CUBE_1 Fact Table V_EP_FACT_ACTUALS Lookup Table 9 Dimensions 234 Measures 13 (Sum of Columns) User will be using Tableau Desktop to get the data viewed - which way I should write the query to get faster response from Hbase Cube which includes Dimensions & Fact table. Pls. advise. Pls. let me know if you need any other information. Regards, Manoj This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.