Hi,

Perhaps, this post is related with next entry: http://forums.pentaho.com/showthread...Column-ignored

I have installed Pentaho 4.1.0 and the data is in Oracle.

I have a schema defined and the problem appear in all dimensions. When I navigate on dimension through the Navigator the members aren't ordered. If I navigate on dimension in the data table, the members are ordered.

You can see the definition how example:

<Dimension type="StandardDimension" name="Datasource">
<Hierarchy name="Datasource" hasAll="true" allMemberName="All Datasources" primaryKey="ID_DATASOURCE">
<Table name="MS_DIM_DATASOURCE" schema="PENTA"/>
<Level name="Datasource" column="ID_DATASOURCE" nameColumn="DESC_DATASOURCE" ordinalColumn="DESC_DATASOURCE" type="Numeric" uniqueMembers="false">
</Level>
</Hierarchy>
</Dimension>


The sentence SQL generated is:

select "MS_DIM_DATASOURCE"."ID_DATASOURCE" as "c0", "MS_DIM_DATASOURCE"."DESC_DATASOURCE" as "c1", "MS_DIM_DATASOURCE"."DESC_DATASOURCE" as "c2"
from "DIMF_PENTA"."MS_DIM_DATASOURCE" "MS_DIM_DATASOURCE"
group by "MS_DIM_DATASOURCE"."ID_DATASOURCE", "MS_DIM_DATASOURCE"."DESC_DATASOURCE"
order by "MS_DIM_DATASOURCE"."DESC_DATASOURCE" ASC NULLS LAST


How can I resolve this problem?

Thank you,
Regards