Non Numeric Measures

[richmond88]

Hi All,

I have just entered the brave new world of MDX and OLAP.

Can a measure be a Letter or does it always have to be numeric.

I work in a school and I need to show grades in the cells/measures as opposed to numbers.

Thanks

for you help

Chris

 

[MDXer]

Measures must be built from int type values but using Calculated Cells or Calculated Members you can display what is needed. You could even create a dimension that lists grades, this would allow you to analyze your data by grade letter as well, and pull the grade name from a dimension members name.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[richmond88]

Thanks MDXer, that is exactly what I want to do. Can you point me in the right direction of how to do this.

Thanks Chris