I have a flat file datasource that I'm using to construct a Dimension. One of the columns is a DateTime in the format: yyyy.MM.dd HH:MM, which I specified as the 'Date Converter Pattern'.
However, when I connect to my cube using an Excel Pivot Table, the date format defaults to: yyyy-MM-DDTHH:MM:ss.SSS and when I try to create a Timeline on my PivotTable, excel does not recognize this as a valid DateTime format.
is there any way to change this in the config files
thanks
To create a TimeLine Excel is using several DISCOVER requests and is more or less assuming it is talking to SSAS to discover an " attribute " hierarchy. Support has been added into icCube (from 6.0.1) to flag a hierarchy as an Excel TimeLine (new field in the hierarchy definition): this hierarchy must have an ALL level and a single DATE (i.e., days) level below.