UD Table - How do you link to system tables in BAQ?

Karen



Try linking it in Crystal first to check that the data is identical and
that it is a BAQ issue rather than a data/join issue



We have never found issues linking UD tables like you are trying to do



Gary





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karen Schoenung
Sent: 05 February 2010 4:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?





Hi Gary,

Yes, I thought about that too this morning, but did not get to try it
until now...Still nothing returns.

Any other ideas?

Thanks,

Karen Schoenung

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

Karen

Try an outerjoin link and see if anything returns?

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Karen Schoenung
Sent: 04 February 2010 10:42 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

I tried. I have a UD table with Company and Key 1 that should match
with a system table company and character01 as links. Although,
character01 is sometimes empty - is that the issue? Or should it then
link only those that have a key1 that matches character01?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

Karen

You have to manually enter the UD table, then create the link and joins
when in the BAQ phrase builder.

Regards

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of karen_schoenung
Sent: 04 February 2010 10:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] UD Table - How do you link to system tables in BAQ?

Hi,

I have a UD table that has the company and Key 1 in a system table, but
I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Hi,

I have a UD table that has the company and Key 1 in a system table, but I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen
Karen



You have to manually enter the UD table, then create the link and joins
when in the BAQ phrase builder.



Regards



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of karen_schoenung
Sent: 04 February 2010 10:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table - How do you link to system tables in BAQ?





Hi,

I have a UD table that has the company and Key 1 in a system table, but
I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen





[Non-text portions of this message have been removed]
I tried. I have a UD table with Company and Key 1 that should match
with a system table company and character01 as links. Although,
character01 is sometimes empty - is that the issue? Or should it then
link only those that have a key1 that matches character01?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?





Karen

You have to manually enter the UD table, then create the link and joins
when in the BAQ phrase builder.

Regards

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of karen_schoenung
Sent: 04 February 2010 10:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] UD Table - How do you link to system tables in BAQ?

Hi,

I have a UD table that has the company and Key 1 in a system table, but
I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Karen



Try an outerjoin link and see if anything returns?



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karen Schoenung
Sent: 04 February 2010 10:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?





I tried. I have a UD table with Company and Key 1 that should match
with a system table company and character01 as links. Although,
character01 is sometimes empty - is that the issue? Or should it then
link only those that have a key1 that matches character01?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

Karen

You have to manually enter the UD table, then create the link and joins
when in the BAQ phrase builder.

Regards

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of karen_schoenung
Sent: 04 February 2010 10:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] UD Table - How do you link to system tables in BAQ?

Hi,

I have a UD table that has the company and Key 1 in a system table, but
I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Hi Gary,


Yes, I thought about that too this morning, but did not get to try it
until now...Still nothing returns.



Any other ideas?

Thanks,

Karen Schoenung



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?





Karen

Try an outerjoin link and see if anything returns?

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Karen Schoenung
Sent: 04 February 2010 10:42 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

I tried. I have a UD table with Company and Key 1 that should match
with a system table company and character01 as links. Although,
character01 is sometimes empty - is that the issue? Or should it then
link only those that have a key1 that matches character01?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, February 04, 2010 4:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] UD Table - How do you link to system tables in
BAQ?

Karen

You have to manually enter the UD table, then create the link and joins
when in the BAQ phrase builder.

Regards

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of karen_schoenung
Sent: 04 February 2010 10:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] UD Table - How do you link to system tables in BAQ?

Hi,

I have a UD table that has the company and Key 1 in a system table, but
I cannot find how to link it in a BAQ...

Any help is appreciated.

Thank you,
Karen

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]