CODEWITHSUNDEEP
iccube
John
John

Reputation: 313

icCube dateTime format and Excel PivotTable TimeLine

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

Upvotes: 1

Views: 215

Answers (2)

Marc Polizzi
Marc Polizzi

Reputation: 9375

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.

Upvotes: 1

ic3
ic3

Reputation: 7680

I'm a bit lost, I understand you've converted to a DateTime the strings from the data source. Why do you see 'yyyy-MM-DDTHH:MM:ss.SSS' as the member names/labels ?

You can choose whatever you want to ?

My educated guess, Excel is taking for the timeline the key of the member not the label (that needs to be a DateTime object in the datasource).

Can you clarify ?

Upvotes: 0

Related Questions