Fabien,<br> If you use hierarchy.getDefaultMember(), it will not solve your purpose. I have done in following ways. <br>Try this.<br> // Measures are always returned as zeroth dimension<br> Dimension dimension =
cube.getDimensions()[0];<br><br> mondrianSchema = connection.getSchemaReader()<br><br> // All Measure names belong to zeroth hierarchy <br> RolapMember[] measures = (RolapMember[]) mondrianSchema.getHierarchyRootMembers
(dimension.getHierarchies()[0]);<br><br> for(int i = 0 ; i < measures.length ; i++)<br> {<br> System.out.println((measures[i].getUniqueName()));<br> }<br><br>Feel free to come back to me.
<br><br>Thanks & Regards<br>Prakash<br><div><span class="gmail_quote">On 6/10/07, <b class="gmail_sendername">Fabien Carrion</b> <<a href="mailto:fabien.carrion@gmail.com">fabien.carrion@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br><br>I would like to explore the Dimension object when it is used as a measure.<br><br>
So I do this:<br><br>Schema schema = connection.getSchema();<br>Cube cubes[] = schema.getCubes();<br>for (int n = 0; n < cubes.length; n++) {<br> if (cubes[n].getName().equals(cubeDefaultName)) {<br> cube = cubes[n];
<br> break;<br> }<br>}<br>Dimension dimensions[] = cube.getDimensions();<br>for (int n = 0; n < dimensions.length; n++) {<br> Hierarchy hierarchy = dimensions[n].getHierarchy();<br> Member member = hierarchy.getDefaultMember
();<br> if (dimensions[n].isMeasures()) {<br> measuresMdx = "";<br> columnsMdx = " select NON EMPTY {" + member.getUniqueName() + "}<br>ON columns, ";<br> } else {<br> if (rowsMdx.length
() > 0) {<br> rowsMdx.append(", ");<br> }<br> rowsMdx.append(member.getUniqueName());<br> }<br>}<br>StringBuffer result = new StringBuffer(measuresMdx.length() +<br>columnsMdx.length() + rowsMdx.length
() + 50);<br><br>result.append(measuresMdx).append(columnsMdx).append("NON EMPTY<br>{(").append(rowsMdx).append(")} ON rows ").append("from [" +<br>cube.getName() + "]");<br><br><br>
This code just display me one measure. I don't find out where are the<br>other measures. How can I display them?<br><br>I am using mondrian 2.3.2.8944 in a java program.<br><br>Thanks<br><br>--<br>Fabien Carrion<br><br>
() Campagne du ruban ASCII -- Contre les mails en html<br>/\ contre les pieces-jointes Microsoft<br>Web: <a href="http://fabien.carrion.free.fr/">http://fabien.carrion.free.fr/</a><br>_______________________________________________
<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br></blockquote>
</div><br>