OLAP Cubes Time Dimensions

(0) Share

Report

Posted on by Alberto de la Cruz

Hi,

I cant find why in different cubes, the time dimension has different formatting, i.e. in one cube month are in text like January, February, etc. and in another the months are in digits 1, 2, 3, etc.

I checked something about the extended data type of the date field used as source, but it doesnt seem to be any influence on it.

Is there any class that I could modify to set a standard in the formatting of the Time Dimension, or something else I could do?

Any help will be really appreciated.

Thanks,

Alberto de la Cruz

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

MohammedRasheed 1,405 on at

Like (0)

Report

Hi Alberto,

this is really a limitation from SSAS... there are no format properties on dimension on sql 2005..

(well there are, but you need to write code for it)..

i noticed that this usually happen if at the time the cube is created, the table is blank (or has blank dateTime fields).

try deleting your cube, populate your table with data and re create the cube..

this link could also be of use to you:

http://dynamic-ax.co.uk/articles.aspx

..

if nothing then you will have to resolve the issue using ssms/vs

refer to this blog, if you need assistance :

http://wills-blog.com/?p=102

hope this helps.. let us know if you have any more questions.

regards,

Mohammed Rasheed

www.dynamic-ax.co.uk

Was this reply helpful? Yes No