Re: Derived measures in Kylin

2016-08-18 Thread Alberto Ramón
directly we had a > workaround by creating a column TotalSalary = SUM(HRA) + SUM(DA) > in hive and need to populate it in KYLIN Cube. > > Regards, > Bhanu Prakash. > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/Derived-measures-

Re: Derived measures in Kylin

2016-08-18 Thread Bhanu Prakash Sunkesula
) in hive and need to populate it in KYLIN Cube. Regards, Bhanu Prakash. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-tp5513p5592.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Derived measures in Kylin

2016-08-17 Thread Reshma
is calculated on the fly depending upon the formula given by me Please let me know. Regards, Reshma -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-tp5513p5591.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Derived measures in Kylin

2016-08-17 Thread Li Yang
> configured and calculated by Kylin cube, how can i configure Cube to > > calculate formula > > (SUM(BaseSalary) + SUM(Hra))/SUM(DA)? > > > > Regards > > > > > > -- > > View this message in context: http://apache-kylin.74782.x6. &g

Re: Derived measures in Kylin

2016-08-11 Thread ShaoFeng Shi
uestion is since the SUM(HRA), SUM(BaseSalary), SUM(DA) will be > configured and calculated by Kylin cube, how can i configure Cube to > calculate formula > (SUM(BaseSalary) + SUM(Hra))/SUM(DA)? > > Regards > > > -- > View this message in context: http://apache-kylin.7478

Re: Derived measures in Kylin

2016-08-10 Thread Reshma
-measures-in-Kylin-tp5513p.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Derived measures in Kylin

2016-08-10 Thread hongbin ma
.png> time by > Cube > based on grouping selected(in this case FirstName, LastName). > <http://apache-kylin.74782.x6.nabble.com/file/n5534/Image1.png> > <http://apache-kylin.74782.x6.nabble.com/file/n5534/Image3.png> > > -- > View this message in context: htt

Re: Derived measures in Kylin

2016-08-09 Thread Reshma
x6.nabble.com/Derived-measures-in-Kylin-tp5513p5534.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Derived measures in Kylin

2016-08-09 Thread ShaoFeng Shi
p://apache-kylin.74782.x6. > nabble.com/Derived-measures-in-Kylin-tp5513p5530.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi

Re: Derived measures in Kylin

2016-08-09 Thread Reshma
side based on what dimensions are selected? Thanks, Reshma -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-tp5513p5530.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Derived measures in Kylin

2016-08-08 Thread Luke Han
is defining an > additional column with the value of 'PersonHra' + 'PersonDa', and then use > that in the measure; > > 2016-08-05 14:48 GMT+08:00 PRABHU Reshma : > > > Hi, > > > > Is it possible to have Derived Measures in Kylin? > > For exam

Re: Derived measures in Kylin

2016-08-07 Thread ShaoFeng Shi
So far the SUM measure only support 1 column; The workaround is defining an additional column with the value of 'PersonHra' + 'PersonDa', and then use that in the measure; 2016-08-05 14:48 GMT+08:00 PRABHU Reshma : > Hi, > > Is it possible to have Derived Measures

Derived measures in Kylin

2016-08-04 Thread PRABHU Reshma
Hi, Is it possible to have Derived Measures in Kylin? For example, Fact Table has 2 columns ( PersonHra, PersonDa) Is it possible to have Kylin cube created on the fact table and computing Salary measure as SUM of 'PersonHra' + 'PersonDa'? Please let me kn