Calculated dimensions in measures

[#1]

Hi Experts,

Is it possible to use an calculated dimension in an measure?

I've created an dimension to group some values, Now I want to use that dimension in an measure, is it possible.

Thanks in advanced.

[devarasu07]

Hi,

Yeah we can do that by using set analysis,

example,

Expression = SUM({<Employee = {"=Rank(SUM(Salary),4)<=10"}>}Salary)

above expression will show top 10 employee (as Cal.dim)  by Sales.

Tks, Deva

[#3]

Hi Deva,

Thanks for the response but was the Employee an Calculated dimension?

This is what I'm trying to do.....

Create an Dimension called MedicineGroup 

if (ReportingGroup2Name like 'Cephalosporins*' , 'Cephalosporins'

,if (ReportingGroup2Name like 'Co-trimoxazole*' , 'Co-trimoxazole'

,if (ReportingGroup2Name like 'Macrolide*' , 'Macrolide'

,if (ReportingGroup2Name like 'Other Antibiotic*' , 'Other Antibiotic'

,if (ReportingGroup2Name like 'Ciprofloxacin*' , 'Ciprofloxacin'

,if (ReportingGroup3Name like 'Co-amoxyclav*' , 'Augmentin'

,if (ReportingGroup3Name like 'Amoxicillin*' , 'Penicillin - Other'

,if (ReportingGroup3Name like 'Flucloxacillin*' , 'Penicillin - Other'

,if (ReportingGroup3Name like 'Penicillin*' , 'Penicillin - Other'

)))))))))

then I want to use the MedicineGroup in an Measure

Expression = SUM( {$ <MedicineGroup = {"Augmentin"}>} Record_Counter)

But the MedicineGroup does not appear when typing it in expression editor

Hope this will help.

Thx Erenst

[OmarBenSalem · Accepted solution]

create your dimension in the script and then you can use it

[#5]

Hi Omar,

Thanks very much.

Erenst