Post reply

datatype changes from DATE to INT in DRILLTHROUGH

  • February 27, 2013 at 8:26 pm

    #147969

    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!

  • February 27, 2013 at 8:30 pm

    #1591826

    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.

  • March 1, 2013 at 9:56 am

    #1592456

    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