@Reshma, you can try on a simple data set to verify. Your requirement shall just work, no special configuration is needed.
On Thu, Aug 11, 2016 at 10:49 PM, ShaoFeng Shi <[email protected]> wrote: > You don't need configure formula "(SUM(BaseSalary) + SUM(Hra))/SUM(DA)" as > a measure; you just send your query to Kylin, like "select (SUM(BaseSalary) > + SUM(Hra))/SUM(DA) from table group by dim1, dim2..." > > > > 2016-08-11 12:05 GMT+08:00 Reshma <[email protected]>: > > > hi, > > > > the question 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.74782.x6. > > nabble.com/Derived-measures-in-Kylin-tp5513p5555.html > > Sent from the Apache Kylin mailing list archive at Nabble.com. > > > > > > -- > Best regards, > > Shaofeng Shi >
