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