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.
