Derived dimensions are empty [Kylin 2.6.1-hadoop3]

[Krzysztof Zarzycki]

Hi Kylin community,
I am using Kylin 2.6.1-hadoop3.
I have a fact table TRANSACTION and lookup table STORE. When I select a
derived dimension from a lookup table and try to group by the derived
dimension, I always get a single row with an empty value for that dimension.
SELECT
     store.region,
     sum(sale_value)
FROM
    transaction
JOIN
    store
ON
    transaction.store_id = store.store_id
GROUP BY
    store.region
;
However, when I define a new cube, where the dimension is marked as normal,
query results are as expected.

What have I missed while using derived dimensions? Any suggestions?


Thank you,
Krzysztof