It´s Possible Translate the months ?

[RicardoPereira]

Hi,

It´s possible translate automatically the months?
Example: May -> Maio

Thanks

 

[canhe]

Hi,

Yes! I have a time dimension table and added another column month_text, something like this:
Year Month Day Month_text
1990 05 01 Mai

I created a new column "Month_label" in my report contain Year and Month_text -> 1990/Mai



I read the new label "Month_label" into transformer and set the label of the time dimension properties on the level month to this new column "Month_label". You could also create it with sql by getting the month from you date and doing 12 if statements and passing it in as a label in the month level, like above.
if (month (20020501)) = 05 then Mai etc


canhe