Re: Get daily average for periodic readings

Thanks Alberto. So you would recommend me to create daily one record in fact table? so from 6 records for year, you would recommend to create 365 records with difference invalues between them. So I can sort data from dimension based on week, month, year, etc. But I was more worried about amount

Re: Get daily average for periodic readings

You cant portioned your cube per week. Must be per -mm-dd You can perform your own test. Doing a calculate per year as dim and year as sum of days On 1 Mar 2018 3:50 p.m., "deva namaste" wrote: > Hi Alberto, > > when I was saying 6 vs 365 its for one item. for 20

Re: Get daily average for periodic readings

Hi Alberto, when I was saying 6 vs 365 its for one item. for 20 Million items it will multiply by a lot. Do you think it wont make much differnce? Also what is YY-MM-WW ? so I can explain you? Basically I need same avg() for week, month, year, etc. Thanks Deva On Thu, Mar 1, 2018 at 8:42 AM,

Re: Get daily average for periodic readings

- the 95% of time response, are latencies (= there is no difference between sum one int or 365, I thought the same when I started with Kylin) - The YY-MM-WW, is not implemented, but can be nice if you can contribute to it Alb On 28 February 2018 at 22:59, deva namaste wrote:

Re: Questions about 'RAW' measure

MailList : Kylin 3062 v2.3 Propose to disable RAW from UI Nowadays you cant control the execution (or not) to create Flat Tables, there is a

Re: about kylin Sample problem

Hi, The log contains a complete Hive command to be run. It looks that step failed. You can find that Hive command and try to run that by yourself in Hive CLI to see if it reports any errors. Thanks, Silas On 1 Mar 2018, at 9:43 AM, nitc_...@qq.com wrote:

RE: Questions about 'RAW' measure

Hello Alberto, Thank you for your answer. I will look further for this mistake on the cube building. Concerning the RAW measure, are you referring to this discussion ? I still can see this option on measures section on Kylin 2.2, that is why it kept my attention. Does it mean that to access