Greetings,

I have this in my View:

.....
CASE WHEN ..0 THEN 'Name1' WHEN ..1 THEN 'Name2' ELSE 'Other' END
.....

View works fine, returns strings as supposed.

But when I try to use this as a dimension in Cube, I get error
on it, with ERROR=CANTCONVERTDATA

What could be the cause of it?

Thanks

I'll check.

It's kinda strange though, since all the wizzards etc do manage
to get members correctly, it's just the processing which fails..

"Ramunas Balukonis" <ramblk1 (AT) hotmail (DOT) com> wrote in news:#PnhSOISEHA.3056
@TK2MSFTNGP11.phx.gbl:

review key data size and key data type properties in dimension editor

Ramunas Balukonis

VPMarket, UAB


"QQ" <qq-spam (AT) mail (DOT) lt> wrote

That fixed it, thanks.

"Ramunas Balukonis" <ramblk1 (AT) hotmail (DOT) com> wrote in news:#PnhSOISEHA.3056
@TK2MSFTNGP11.phx.gbl: