May 20, 2009 at 2:22 pm
Hello everyone:
The time dimensions in our cube shows a ".time" when viewed in Excel.
a few examples:
tran_date.time
sale_date.time
Does anyone know if there is a setting somewhere either in Excel or SSAS that will suppress the ".time' display?
Thanks in advance,
Michael
May 22, 2009 at 5:44 pm
I apologize if this is a stupid suggestion but you checked to make sure they are not named that why in BIDs when you design the dimension right?
May 26, 2009 at 8:27 am
Oh definitely not. Other cube browsers do not display it that way.
May 26, 2009 at 9:43 am
What version of Excel are you using? This would appear to be caused by the multiple hierarchies in your time dimension. In AS2000 you used to have to name the dimensions Time.A and Time.B to get the multiple hierarchies, and this is how they came across in excel.
Did you upgrade from AS2K to AS2K5 using the upgrade wizard? If so, did you end up with > 1 time dimension where you prob only want 1 with multiple hierarchies?
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply