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.
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.". :(
Cube Date issue
Posted - 04/03/2012 : 09:41:36
