I still don't quite understand your problem. What exception are your witnessing when you run queries containing (SUM(BaseSalary) + SUM(Hra))/SUM(DA)?
On Wed, Aug 10, 2016 at 1:10 PM, Reshma <[email protected]> wrote: > Hi,To clarify, lets says we want feature likeI have following columns in my > Person table,EmpNo, FirstName, LastName, Department, Phone, BaseSalary, > Hra, > DAPlease see attached Image1When i develop cube, i created > Dimensions(FirstName, LastName, Department) and Measures(SUM(BaseSalary), > SUM(Hra), SUM(DA), Max(BaseSalary))I can easily show it in a Tableau UI in > a > matrix like grouped by dimensions (FirstName, LastName)Measures --> > SUM(BaseSalary), SUM(Hra), SUM(DA)Now i want another calculated measures > Ratio like (SUM(BaseSalary) + SUM(Hra))/SUM(DA)Please see attached > Image2Now > this has to be calculated at runAlso, now we add another grouping dimension > Department, the ratio will again change as SUM(BaseSalary), SUM(HRA) and > SUM(DA) will change at group level.Please see attached Image3Let me know > how > i can configure Kylin do have this. > <http://apache-kylin.74782.x6.nabble.com/file/n5534/Image2.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: http://apache-kylin.74782.x6. > nabble.com/Derived-measures-in-Kylin-tp5513p5534.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Regards, *Bin Mahone | 马洪宾*
