Hi,
I need help.


I have this part of my code with mondrian 3, I have very difficulties to rewrite the same Date dimension with modrian 4. I want to format my date
It is degenarate dimension


<Schema name="Commercial">
<Dimensions>...</Dimensions>
<Dimensions>...</Dimensions>
<Dimensions>...</Dimensions>
<Cube name="Commercial process" visible="true" cache="true" enabled="true">
<Table name="shipinvoice_v">
</Table>
<DimensionUsage source="invoice" > </DimensionUsage>
...
<Dimension type="TimeDimension" visible="true" highCardinality="false" name="ORDER DATE">
<Hierarchy name="Order Date" visible="true" hasAll="true">
<Level name="Year" visible="true" column="day_order_id" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
<CaptionExpression>
<SQL dialect="generic">
<![CDATA[to_char(c_order_dateordered::date, 'YYYY')]]>
</SQL>
</CaptionExpression>
</Level>
<Level name="Month" visible="true" column="day_order_id" type="String" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
<CaptionExpression>
<SQL dialect="generic">
<![CDATA[TO_CHAR((extract(month from c_order_dateordered)),'fm00') || '/' || extract(year from c_order_dateordered)]]>
</SQL>
</CaptionExpression>
</Level>
<Level name="Day" visible="true" column="day_order_id" type="String" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
<CaptionExpression>
<SQL dialect="generic">
<![CDATA[to_char(c_order_dateordered::date, 'DD/MM/YYYY')]]>
</SQL>
</CaptionExpression>
</Level>
</Hierarchy>
</Dimension>
</Cube>
</Schema>




Regards,
Lotenbol