One option is to create a view first to combine these two column into one. Then pickup this view as Fact table.
Thanks. Best Regards! --------------------- Luke Han On Mon, Aug 8, 2016 at 11:46 AM, ShaoFeng Shi <shaofeng...@apache.org> wrote: > 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 <reshma.pra...@socgen.com>: > > > 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 know. > > > > Regards, > > Reshma > > ========================================================= > > > > Ce message et toutes les pieces jointes (ci-apres le "message") > > sont confidentiels et susceptibles de contenir des informations > > couvertes par le secret professionnel. Ce message est etabli > > a l'intention exclusive de ses destinataires. Toute utilisation > > ou diffusion non autorisee interdite. > > Tout message electronique est susceptible d'alteration. La SOCIETE > GENERALE > > et ses filiales declinent toute responsabilite au titre de ce message > > s'il a ete altere, deforme falsifie. > > > > ========================================================= > > > > This message and any attachments (the "message") are confidential, > > intended solely for the addresses, and may contain legally privileged > > information. Any unauthorized use or dissemination is prohibited. > > E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any > > of its subsidiaries or affiliates shall be liable for the message > > if altered, changed or falsified. > > > > ========================================================= > > > > > > -- > Best regards, > > Shaofeng Shi >