Hi
When you are working with many dimension you need works with Derived Dim
is mandatory
BR, Alberto
On 5/12/19 12:52, Yaqian Zhang wrote:
Hi Noureddine:
The max physical dimension number (exclude derived column in
lookup tables) in a cube is 63; If you can normalize some dimensions
to lookup tables, with derived dimensions, you can create a cube with
more than 100 dimensions.
But a cube with > 30 physical dimensions is not recommended;
You even couldn’t save that in Kylin if you don’t optimize the
aggregation groups. Please search “curse of dimensionality”.
在 2019年12月4日，22:41，Noureddine Dahmane <[email protected]
<mailto:[email protected]>> 写道：
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] <mailto:[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
--
========================
DRAKOSDATA: Apache Kylin Experts
Kyligence Partner Spain (Madrid)
========================
This message and any attachments are confidential and privileged and intented
for the use of the addressee only.
You are entitled to exercise your rights of access, rectification, cancellation
and opposition by addressing such written application to address
admin@[email protected]
