Dear Sir/Madam, I am using Apache Kylin and I have multiple real UHC dimensions (unfortunately I can not remove them) and because of that, the query building process requires a lot of time. Do you have any recommendations? I am thinking of using near-real-time OLAP (because it does not have the first two steps in batch processing) and building multiple cubes simultaneously in short periods. But even in this case, I have to keep user-id (which is a UHC dimension) for each cube and one other UHC dimension as well. Do you think this solution is practical? If you have any opinion about this problem I would deeply appreciate it.
yours sincerely, Fatemeh
