Hello, I was wondering how the hierarchy dimensions are managed in the cube and what happens if I update the Hive table that contains the dimension.
Let's say I have a fact table with a storeID and then a dimension table that goes like this : - storeID - city - country - region and I want the sum of products sold either by store, city, region, etc. This seems fine with Kylin. For regions, internally is a row going to be created with key as something like region and the pre-calculated sum? Now let's say there is rebranding and the region is renamed, or that the strategy changes and that a country that was part of region is now part of another region. Every time some of those changes occur, should I rebuild completely my cube or is there any way to manage those changes?
