dbTalk Databases Forums  

varcharfield in measure

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


Discuss varcharfield in measure in the microsoft.public.sqlserver.olap forum.



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

Default varcharfield in measure - 11-26-2003 , 08:56 AM






The situation is like this
I have a product-table where I have the name of the vendor in one column. I was wondering if I could build cube with this product-table where I put this vendorcolumn into measure. Then I could blend this productcube with salescube and have the name of the wender standing beside the salesnumbers when I'm on lowest level

I have tried this and always get "cant convert data....

Any comments on this

regards Halli.

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: varcharfield in measure - 11-26-2003 , 10:00 AM






Measures must be numeric. But there may be a way out.
See Russ Whitney's excellent "Member Properties Bootcamp" for a way to add
member properties to -look- like measures.
The article is at:
http://www.sqlmag.com/Articles/Index...rticleID=39384

Hope that helps.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Halli" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
The situation is like this:
I have a product-table where I have the name of the vendor in one column.
I was wondering if I could build cube with this product-table where I put
this vendorcolumn into measure. Then I could blend this productcube with
salescube and have the name of the wender standing beside the salesnumbers
when I'm on lowest level.
Quote:
I have tried this and always get "cant convert data...."

Any comments on this?

regards Halli.



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.