问题就是，维度数据每构建一次就需要变动一次，导致了前面构建的也用了最新的维度数据，但是构建时间跨天就不会有这种问题，还是维度快照的更新机制问题，怎么能解决维度数据变了，前面已经构建过的关联的维表还是当时的那种状态呢？
| | 李甜彪 | | ltb1...@163.com | ---- Replied Message ---- | From | P.F. ZHAN<dethr...@gmail.com> | | Date | 8/2/2023 15:34 | | To | <user@kylin.apache.org> | | Subject | Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table | 这种你不是应该将需要查询的列设置成维度，然后预计算存储到cube么？cube的维度数据，如果不做刷新，那么就不会变化。 On Wed, Aug 2, 2023 at 11:35 李甜彪 <ltb1...@163.com> wrote: 大神，能帮我解决一下我碰到的问题吗？维度表的快照怎么能不让取最新的，在kylin4.0.3的使用过程中，在同一天构建不同日期分区数据时，维度表需要切换，但是当天的最后一次构建会导致今天构建的其他天数据也使用了最后一次所关联的维度表，现在的想法是每次构建关联维度表的数据在变，但是也要让当天已经构建过的数据不发生变化，有什么方法可以实现。 | | 李甜彪 | | ltb1...@163.com | ---- Replied Message ---- | From | Xiaoxiang Yu<x...@apache.org> | | Date | 8/2/2023 11:31 | | To | <user@kylin.apache.org> , <mk1853...@gmail.com> | | Subject | Re:measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table | Do you check the answer by Hive/SparkSQL, do Hive/SparkSQL give the expected answer? If you have checked, I think you can give us you cube defination(CubeDesc in Json) and the SQL statement you queried, so we can discuss in detail? -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-08-02 04:35:04, "marc nicole" <mk1853...@gmail.com> wrote: The measure is of type column (not constant) and is bigint. I selected the measure from the dropdown corretly as well. measure column returns 1 for all column values instead of actual values when querying the cube. What could be the underlying problem? cube or model defining? or maybe data source attribute types? Maybe I should create a lookup table with the fact table (which I am not doing so far)? Why the measure column in query answer is showing only 1 as values ??
