RE: optimal parameters

Thanks for your inputs.. Is there any other way to get 80+ dimensions into one Cube? Can we split the cube – 20 Dimension Cube 1 – 20 dimensions Cube2 – 20 dimensions Query should take the data from both cube – Cube1+cube2 – so that Tableau will have 40 dimensions into one worksheet. Pls. advi

RE: Manager employee hierarchy in Kylin

One Employee – Manager1-manager2-manager3 – It will be like that.. It depends upon data set Write the code for flattening out for per employee – in that case, employee code wont be repeated.. Regards, Manoj From: deva namaste [mailto:ohd...@gmail.com] Sent: Friday, February 02, 2018 6:03 PM To

RE: Problem starting Kylin Web interface

Hello, Thanks for the suggestion. I tried on another machine with Firefox and Chrome, but I get the same result as before. I also rebuilt the project ‘sample’ from scratch, with no change. My cluster seems to have problems on its nodes, especially memory which is nearly full on most nodes. I su

Re: Manager employee hierarchy in Kylin

Hi Shao, I am using following concept for OLAP so I can get all the child (descendants) and their levels by querying parent employee. So that I can have sum(sales revenue) for each employee and I can aggregate them upto their manager. e.g. manager can have 5 employees, so he can see total sum for

Re: New Blog: Get Your Interactive Analytics Superpower, with Apache Kylin and Apache Superset

Thanks, billy. If anyone from community try out using superset with kylin, let me know your feedback hejingke 邮箱：hejin...@gmail.com 签名由 网易邮箱大师 定制 在2018年02月01日 12:56，Luke Han 写道： Nice one! Best Regards! - Luke Han On Mon, Jan 29, 2018 at 8:10 PM, Billy Liu wrote: Thanks Joan

Re: Manager employee hierarchy in Kylin

Hi Deva, Does the fact table has "project" information? If yes, can you use employee + project to join the dimension table (assuming employee + project is unique in the dimension table) ? If you can share the table structure, that would be easier to understand the problem. 2018-02-02 20:33 GMT+0

Re: Problem starting Kylin Web interface

Please try Chrome; Most developers are using Chrome; And if there is an error, you can press F12 to check the HTTP request/response, there should be more information. 2018-02-02 21:54 GMT+08:00 BELLIER Jean-luc : > Hello again, > > > > I forgot to mention that I use IE or Secured Firefox as Web b

RE: Problem starting Kylin Web interface

Hello again, I forgot to mention that I use IE or Secured Firefox as Web browsers. I have the same issue with both. Could there be the cause of the problem ? Best regards Jean-Luc. De : BELLIER Jean-luc Envoyé : vendredi 2 février 2018 14:48 À : user Objet : RE: Problem starting Kylin Web inte

Re: Manager employee hierarchy in Kylin

Thanks Manoj and ShaoFeng, I already tried creating view and using within cube, but my challenges were - 1. One employee can have more than one manager for different projects (So duplicate key problem comes) 2. I need recursive total per all descendant hierarchy employees (So I need from that lev

RE: optimal parameters

Any updates on this?? How to process 450 milions of records in one partition - fact table has this much data for one COB. Regards, Manoj From: Kumar, Manoj H Sent: Friday, February 02, 2018 11:45 AM To: 'user@kylin.apache.org' Subject: optimal parameters Importance: High Hi Folks - Need your i

Re: optimal parameters

Hi Manoj, 450 millions in one build is a common case for Kylin. But 80+ dimensions is too many, as by default the cube will have 2^N dimension combinations (N is dimension number). I think you have optimized the aggregation group, as by default Kylin only allows 2048 combinations in one Cube. I

Re: Problem starting Kylin Web interface

Hi Jean-luc, The kylin.log seems okay, the service is started and the job scheduler is running up. The kylin.out has some error about missing ".keystore", but by default if you accessing kylin via http, it shouldn't need to load keystore. Please try visit http://host:7070/kylin again to see wheth

Re: Manager employee hierarchy in Kylin

I agree Manoj about "need to flatten it out"; You can easily achieve this by creating a Hive view, in which join the fact table with the dimension table. Then use the view as the only table for the model and Cube. In the cube, you still have the chance to specify "manager" and "employee" as a hiera

Re: Welcome new Apache Kylin committer: Jianhua Peng

Congratulations,  Jianhua ! Original message From: Luke Han Date: 2/1/18 10:02 PM (GMT-08:00) To: dev , user , Apache Kylin PMC Subject: Welcome new Apache Kylin committer: Jianhua Peng I am very pleased to announce that the Project Management Committee(PMC) of  Apache Kyli