Can We show the string value as a measure on mondrian olap <p>I want to show the string value as one of the measure value. When a fact table has a integer value and string value respectively and also has some foreign table's keys. Then I could show the integer value as a measure value, but I couldn't show the string value as a measure. Because <a href="http://mondrian.pentaho.com/documentation/xml_schema.php#Measure" rel="nofollow">Measure element</a> in schema of cube (written in XML) doesn't allow that a measure value doesn't have 'aggregator'(It specify the aggregate function of measure values). Of course I understood that we can't aggregate some string values. But I want to show the string value of the latest level in hierarchy.</p> <p>I read following article. <a href="http://type-exit.org/adventures-with-open-source-bi/wp-content/uploads/2010/07/display_props.png" rel="nofollow">A figure</a> (around middle of this page) shows a cube that contains string value as a measure value. But this is an example of Property value of Dimension table, so this string value isn't contain in fact table. I want to show the string value that contains in fact table.</p> <p><a href="http://type-exit.org/adventures-with-open-source-bi/2010/07/a-simple-date-dimension-for-mondrian-cubes/" rel="nofollow">A Simple Date Dimension for Mondrian Cubes</a></p> <p>Anyone have some idea that can be shown the string value as a measure value? Or I have to edit Mondrian's source code?</p>