Date format

Hi,

I have a date format problem with the AS 2005.

I have a Data Mart dimension with a field of the type smalldatetime. I have created a AS2005 dimension with the hierachy "Fulldate" which is based on this field. Due to the language settings of the os and of the cube I would expect that the hierachy would display the date like dd.mm.yyyy

Unluckily it appears as mm/dd/yyyy

Under the DataItems there is a property format which I tried to use to get the correct displayed datetime ...but whatever I use i always display US datetime format.

What can I do to get the dateformat like dd.mm.yyyy?

Thanks,

StSt

You can create a named calculation in the table in the DSV that formats the date however you desire using the SQL syntax of the provider. Then use this column as the name column for the date attribute. If you are using a server based time dimension because you don't have a time table, you won't be able to do this. In this case you may want to consider generating a time table so that you can have better control over it's contents. This can be done in the Dimension Wizard by choosing the option to build a dimension without a source and not using a template. Then when you are done you will need to run "Generate Relational Schema..." from the database and the system will actually create and populate a time table in your data source.|||

Unluckily this doesn't help me. The data source is a SQL Server 2005 Data Mart which has all language settings for german date format which means

dd.mm.yyyy

Even in the DSV it display the date correctly but as soon as I use it in the dimension it will only be display like

mm/dd/yyyy

Independent from the DimensionAttribute Type or the DataItem Format.

What else can I do?

Regards,

StSt

Matt Carroll wrote:

You can create a named calculation in the table in the DSV that formats the date however you desire using the SQL syntax of the provider. Then use this column as the name column for the date attribute. If you are using a server based time dimension because you don't have a time table, you won't be able to do this. In this case you may want to consider generating a time table so that you can have better control over it's contents. This can be done in the Dimension Wizard by choosing the option to build a dimension without a source and not using a template. Then when you are done you will need to run "Generate Relational Schema..." from the database and the system will actually create and populate a time table in your data source.