Hi Nithya, The fact table and lookup table need be joined explicitly. That means, the sql need be:
select bla, bla FROM FACT inner join PRODUCT on FACT.fk = PRODUCT.pk group by x, y Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] [email protected] <[email protected]> 于2019年5月9日周四 下午3:08写道： > 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/ >
