Hello,

I have build a time dimension through the wizard of analysis services.
I then am able to analyse my cube by day.
But the day is displayed like this : 1 2 3 4 5 6 7 8 --> 31
And I would like to get that : Monday 1 Tuesday 2 ---->

Does someone has an idea ?
My idea would be to modify the member name column syntax.

Best Regards
T

thierry wrote:


Because

select datename(month, getdate()) returns August
I tried datename(day, getdate()) + ' ' + convert(CHAR,
DateName(day,"dbo"."DIM_TEMPS"."JOUR"))

but select datename(day, getdate()) does not return Friday but 6

Best Regards
T

Try

select datename(weekday, getdate())

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"thierry" wrote: