dbTalk Databases Forums  

calculated measure coming in as #value in local cube file

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss calculated measure coming in as #value in local cube file in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bhorwatt
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.