Hi, I got a problem about query samle cube table "KYLIN_SALES" The cube SQL is :
SELECT KYLIN_SALES.PART_DT ,KYLIN_SALES.LEAF_CATEG_ID ,KYLIN_SALES.LSTG_SITE_ID ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME ,KYLIN_SALES.LSTG_FORMAT_NAME ,KYLIN_SALES.PRICE ,KYLIN_SALES.SELLER_ID FROM DEFAULT.KYLIN_SALES as KYLIN_SALES INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID My query SQL1 ??works OK??: SELECT KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, SUM(price) as sum__price FROM KYLIN_SALES as KYLIN_SALES INNER JOIN KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME My query SQL2 (works OK) : SELECT KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, SUM(price) as sum__price FROM KYLIN_SALES as KYLIN_SALES INNER JOIN (SELECT * FROM KYLIN_CATEGORY_GROUPINGS) as KYLIN_CATEGORY_GROUPINGS ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME; My query SQL3 (No data result) : SELECT KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, SUM(price) as sum__price FROM KYLIN_SALES as KYLIN_SALES INNER JOIN (SELECT LEAF_CATEG_ID, SITE_ID,META_CATEG_NAME FROM KYLIN_CATEGORY_GROUPINGS) as KYLIN_CATEGORY_GROUPINGS ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID GROUP BY KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME What's different from SQL2 and SQL3? But in my custom Cube, the query like SQL3 also works OK. Thanks!
