Hi!!

I have a problem. The problem is that i need to build a time dimension
with for levels year, semester, quarter, month.
I had made the semester level manualy...but the month level returns
the name in english...and i want to change it!!!
How could i call a function defined in the database that i am using?

i.e.:
in the dimension editor from analysis manager
and in the basic tab proprerties in
Member name column: ??user_function??"dbo"."TB_SIG_PRODUCAO"."CTR_D_En reg_CNT"

It's possible?
In resume i want to translate the month name to another language in a
proper way!!Because i will need to translate to 3 or 4 languages...


Thanks in advance

Botinha

I suggest using views to source dimensions (and fact tables for that
matter).

public @ the domain below
www.tomchester.net

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote

Botinha
Better to build views inbetween your star schema and Analysis Services and build the values in there using either a CASE statement or a lookup to another table with all of the translations

Regard
Jami