Hello Kylin users please let me know if you have any information for this issue
I am running Apache Kylin apachekylin/apache-kylin-standalone:3.0.0-alpha2 Docker image. I started out by creating two Hive tables one to record store sales and one consisting of store metadata *CREATE TABLE IF NOT EXISTS STORESALES (id INT,food FLOAT,drugs FLOAT,cosmetic FLOAT,baby FLOAT,reportdate DATE);CREATE TABLE IF NOT EXISTS STOREMETA (id INT,address STRING,brand STRING,owner STRING);*I then created a model in which I declared *STORESALES* as my fact table and *STOREMETA* as a lookup table with left join *STORESALES.ID <http://STORESALES.ID> = STOREMETA.ID <http://STOREMETA.ID>* I then declare - STOREMETA.ID - STOREMETA.ADDRESS - STOREMET.OWNER - STOREMETA.BRAND as dimensions. I explicitly deleted *STORESALES.ID <http://STORESALES.ID>* I also specify measures - STORESALES.DRUGS - STORESALES.BABY - STORESALES.COMSETICS - STORESALES.FOOD and also specified *STORESALES.REPORTDATE* as my partition So then I go on to set up my cube. Again I add *STOREMETA[ID, BRAND, OWNER, NAME]* as dimensions, but for some reason *STOREDATA.ID <http://STOREDATA.ID>* shows up as a choice for a dimension as well. I add measures as *MAX_FOOD, MAX_DRUGS, MAX_COSMETICS, MAX_BABY*. The issues is once I get to Advanced Settings the only options for grouping available are *STORESALES.ID <http://STORESALES.ID>*. If I manually enter anything else it disappears from the list. I went back to edit the model and noticed that *STORESALES.ID <http://STORESALES.ID>* is now in the list of measures as well. Not sure if this is what breaking things for me. Or if my general lack of experience here is hindering my progress. Please assist. P.S. This question has also been posted to stack overflow, feel free to respond and engage there. It contains screenshots I felt may be relevant https://stackoverflow.com/questions/58649747/unable-to-create-a-grouping-in-apache-kylin
