Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2012-04-03 : 09:41:36
|
| I have a cube with a Date dimension table; dDate. This table has a column called Day and is datetime. My issue is that the Day column shows as 'Character' in SAP Business Object. I used Excel and the Day is shown as text too; i.e. if I want to sort the column in Excel, it offers sort A to Z rather than say earliest to oldest. Why I get this behavior? Any suggestion to resolve the issue is greatly appreciated. Canada DBA |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-04-03 : 10:13:51
|
| On your dimensions in SSAS, what are the properties of this field? Is the datatype there a datetime? |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2012-04-03 : 10:22:19
|
| From the Day column properties:IsAggregateable: TrueOrderBy: KeyName: DayType: DateUsage: KeyOrderByAttribute: KeyColumns: DimDates.Day (Date)NameColumn: DimDates.Day (WChar)Let me know if you need anything else. Thanks!Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2012-04-03 : 14:57:51
|
| I read somewhere that says "SSAS uses the name column as a label to display to the user instead of displaying the key column". Is this related to my issue? I tried to change the type of NameColumn from WChar to Date but got an error saying "The 'Date' data type is not allowed for the 'NameColumn' property; 'WChar' should be used.". :(Canada DBA |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-04-04 : 03:54:12
|
| Hmm, I think it is related, not 100% sure ont he way around it though.When you view it in BIDS or EM, does it sort properly? |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2013-03-14 : 19:26:43
|
| I"m having the same problem, wish I knew what the OP did... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Cube Date issue