datatype changes from DATE to INT in DRILLTHROUGH

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » datatype changes from DATE to INT in...

datatype changes from DATE to INT in DRILLTHROUGH

Rate Topic

Display Mode

Topic Options

Author

Message

michaeleusebio721

Posted Wednesday, February 27, 2013 8:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:06 PM
Points: 3, Visits: 63

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!

Post #1424856

michaeleusebio721

Posted Wednesday, February 27, 2013 8:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:06 PM
Points: 3, Visits: 63

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.

Post #1424858

Mackers

Posted Friday, March 01, 2013 9:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:16 AM
Points: 117, Visits: 459

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

Post #1425603

« Prev Topic | Next Topic »

Permissions