calculated measure coming in as #value in local cube file -
11-02-2006
, 04:13 PM
I have a calculated measure called last payment date which automatically gets
pulled into my local cube file when running the create global cube statement.
I cannot explicitly reference it in the create global cube statement, but it
seems to pull in all calculated members in anyway gratis.
My only issue with the last payment date is it shows up in Excel as #value
even though in the cube it has an actual date in it.
As a side note, I did not want to create this calculated member as a measure
since it isn't a number, but a date. I wanted it to be an attribute in my
customer dimension. However, I could never get it to work as anything but a
measure. |