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 <[email protected]>: > 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
