datatype changes from DATE to INT in DRILLTHROUGH

  • Hi Guys,

    I'm adding a drillthrough action on my cube.

    The measure displays in DATE on the field. I then created a drillthrough and added the measure to the drillthrough columns and when I perform the drill through action on excel it converts to INT.

    2/14/2013 22:51 gets converted to 41319.95241

    Am I missing any setting or property in the drillthrough?

    Please help.

    Thanks!

  • Also, when I view the cube in management studio and perform the drillthrough there, the data type doesn't change. Only when it is in excel.

  • Pretty sure there isn't a setting to fix this in the cube - it sounds like Excel is auto-converting this not SSAS telling Excel that it's a number

    The only thing I can think that you could do is have an attribute of the date that is a number (yyyymmdd) and include that on the drilldown rather than the long date

    Mack

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply