Hello, I have created a cube in KYLIN that has TOP_N measure. When I run the query in Insight I am getting Cartesian Join Not supported error. I have given the details in the below email thread. Can you please let me know If I am doing anything wrong? Or is my usage wrong? If yes, how to use this measure?
Below are complete details: Fact: Product_ID, Amount. Product Dimension: Product_ID, PROD_DESC TIME Dimension: Time_ID, TIME_DESC In Kylin Cube: Dimensions: TIME.TIME_DESC Measure: TOP_N. Column: FACT.Amount GROUP BY: PRODUCT.PROD_DESC Query: SELECT SUM(FACT.AMOUNT), PRODUCT.PROD_DESC FROM FACT,PRODUCT GROUP BY PRODUCT.PROD_DESC ORDER BY SUM(FACT.AMOUNT) DESC; Error: Cartesian join not supported. While executing SQL: SELECT SUM(FACT.AMOUNT), PRODUCT.PROD_DESC FROM FACT,PRODUCT GROUP BY PRODUCT.PROD_DESC ORDER BY SUM(FACT.AMOUNT) DESC; Regards, Nithya -- Sent from: http://apache-kylin.74782.x6.nabble.com/
