February 27, 2013 at 8:26 pm
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
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
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