Hello, i am trying to create a cube in kylin with the following Star schema:
- fact table: click with 32 measures - dimension tables: - brand : 2 columns - campaign: 8 columns - traffic_source: 11 columns - shop_source: 40 columns - traffic_source: 4 columns - category; 8 columns i tried to reduce the complexity of the cube based on the rules like hierarchies, join columns and mandatory columns. however, none of these rules can be applied to my sql statements. Moreover, building a cube of 73 dimensions (all columns of the dimensions tables) is not possible in KYLIN (kylin throws exception and says i should use derived, hierarchies, and join columns to reduce the dimensions combinations). is there any way can i do this or am i doing something wrong in kylin? thank you in advance. Noureddine -- Noureddine Dahmane Software Developer Phone: Fax: +49 721 98993-66 E-mail: [email protected] solute GmbH Zeppelinstraße 15 76185 Karlsruhe Germany Marken der solute GmbH | brands of solute GmbH billiger.de | Shopping.de | ka'ching Technology | Friends Communication Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten Webseite | www.solute.de Sitz | Registered Office: Karlsruhe Registergericht | Register Court: Amtsgericht Mannheim Registernummer | Register No.: HRB 110579 USt-ID | VAT ID: DE234663798 Informationen zum Datenschutz | Information about privacy policy http://solute.de/ger/datenschutz/grundsaetze-der-datenverarbeitung.php
