won't join :(

#1

greetings,

i have this problem.. my fact table is a view, which returns a vendor
number. then i have two dimension tables, which have to be joined using
that vendor number. but the problem is, it won't create the join unless
field names are exactly the same..! and i can't change one of dimension
tables, so that leaves me in a bad situation

the strange thing is,
it will join other fields even though they have different names

i
casted the field to same type in view (varchar(20)), but that didn't help :
(

any ideas? thanks!

#2

What is the error message you get when you try to join the two columns in
the Cube Designer?

--
Jacco Schalkwijk
SQL Server MVP

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

Quote:

greetings,

i have this problem.. my fact table is a view, which returns a vendor
number. then i have two dimension tables, which have to be joined using
that vendor number. but the problem is, it won't create the join unless
field names are exactly the same..! and i can't change one of dimension
tables, so that leaves me in a bad situation

the strange thing is,
it will join other fields even though they have different names

i
casted the field to same type in view (varchar(20)), but that didn't help
:
(

any ideas? thanks!

#3

"Jacco Schalkwijk" <jacco.please.reply (AT) to (DOT) newsgroups.mvps.org.invalid>
wrote in news:u5ATWS4rEHA.3324 (AT) TK2MSFTNGP15 (DOT) phx.gbl:

Quote:

What is the error message you get when you try to join the two columns
in the Cube Designer?

there is no error.. just nothing happens - no link appears. no message
whatsoever..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

won't join :(

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

won't join :( - 10-11-2004 , 04:31 AM

Re: won't join :( - 10-11-2004 , 06:22 AM

Re: won't join :( - 10-26-2004 , 07:51 AM