Hi,

I use Excel XP Pivot tables. I have a dimension which as
a date field. How do one support different date formats
(british, usa etc) in the front end?

Thanks,
Tom

you can create 1 property by country in your cube for the "date" level.
Set each property to the "caption" type and set the target language.

now your dimension is will display the name of the data members depending of
the language set on the client computer.

But for a easy way to implement this, put all the languages date value in
the source table of your dimension. Because the DateName or any other date
related SQL function will return the name of the month (for example) on ly
in the language of the connection between AS and your database server.
Putting all of these labels in the source table allow you to control exactly
what you'll push to the users.

"Tom Walker" <twalker (AT) tom (DOT) net> a écrit dans le message de
news:25d0201c38df3$06b413a0$a601280a (AT) phx (DOT) gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003-09-30