i have a cube which i would like to extract data from. The cube includes a Date-dimension with a hierarchy (year-quarter-month-day), but the months are only represented as integers. I would like to "change" thoose to real month-names. Can i do that in the existing cube or do i have to create new a new time dimension?
EDIT: So i have created a new time dimension with the simple "create new dimension"-wizard, but the language is english, how can i change this by simplest means?
You can add that to an existing cube. In your data source view, a field containing the label will have to be added to the table or named query that acts as source to your time dimension. You'll have to investigate how your source data is provided, though. Easiest would be to create a view on top of your existing structure.
Once you have the label available, modify the month attribute of your time dimension and set the label as NameColumn.