web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) OLAP Cubes Time Dimens...

Microsoft Dynamics AX (Archived)

OLAP Cubes Time Dimensions

(0) Share

Report

Report

Posted on by Alberto de la Cruz

25

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 Img

All responses (1)

Answers Img

Answers (0)

MohammedRasheed 1,405 on at

Like (0)

Report
Copy link

Link copied!

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

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans