?????? measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

[????????]

????




------------------ ???????? ------------------
??????: "??????"<ltb1...@163.com&gt;; 
????????: 2023??8??2??(??????) ????3:45
??????: "user"<user@kylin.apache.org&gt;; 
????: Re:  measure column showing 1 as values instead of the actual values in 
Kylin SQL Query answer table



     
     
????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
                           
              
                                              ??????

ltb1...@163.com

         
     
  
 
        ---- Replied Message ----   
                                  From                                P.F. 
ZHAN<dethr...@gmail.com&gt;                             
                          Date                            8/2/2023 15:34        
        
                          To                                                    
 <user@kylin.apache.org&gt;                                        
                          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&gt; wrote:

            
     
??????????????????????????????????????????????????????????????????????kylin4.0.3??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
     
                                              ??????

ltb1...@163.com

         
     
  
 
        ---- Replied Message ----   
                                  From                                Xiaoxiang 
Yu<x...@apache.org&gt;                             
                          Date                            8/2/2023 11:31        
        
                          To                                                    
 <user@kylin.apache.org&gt;             ,
                                   <mk1853...@gmail.com&gt;                     
                   
                          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&gt; 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 ??