BAQ linking tables multiple times

Yahoo Archive
1
No (at least not as BAQ capabilities are exposed via the phrase builder).

It is not like SQL. Only one instance of a table can appear per query.

--- On Mon, 8/4/08, Daniel Laidig <daniellaidig@...> wrote:

From: Daniel Laidig <daniellaidig@...>
Subject: [Vantage] BAQ linking tables multiple times
To: vantage@yahoogroups.com
Date: Monday, August 4, 2008, 10:31 AM






Is there a way using a BAQ to link a table multiple times? We are using
alternate billto customers for some of our sales orders. From Orderhed I
want to link to Customer from OrderHed.CustID and I also want to link to
another customer table from OrderHed.BillToCust Num. What I am really
looking for in my BAQ is the Customer ID and Name for the SoldTo Customer
and the BillTo Customer. Is this possible? When you select a table in the
phrase builder, it disappears from the list of available tables so I cant
select it again. Is there another way I can get this information?

Daniel

[Non-text portions of this message have been removed]
2
Is there a way using a BAQ to link a table multiple times? We are using
alternate billto customers for some of our sales orders. From Orderhed I
want to link to Customer from OrderHed.CustID and I also want to link to
another customer table from OrderHed.BillToCustNum. What I am really
looking for in my BAQ is the Customer ID and Name for the SoldTo Customer
and the BillTo Customer. Is this possible? When you select a table in the
phrase builder, it disappears from the list of available tables so I cant
select it again. Is there another way I can get this information?



Daniel





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

No there is no way to have multiple alias of the same
table in a BAQ .

If this is to be presented in a dashboard, you can use
the dashboard publish and subscribe

To get the information by utilizing two queries.



Regards,

Stephen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Daniel Laidig
Sent: 04 August 2008 15:31
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ linking tables multiple times



Is there a way using a BAQ to link a table multiple times? We are using
alternate billto customers for some of our sales orders. From Orderhed I
want to link to Customer from OrderHed.CustID and I also want to link to
another customer table from OrderHed.BillToCustNum. What I am really
looking for in my BAQ is the Customer ID and Name for the SoldTo
Customer
and the BillTo Customer. Is this possible? When you select a table in
the
phrase builder, it disappears from the list of available tables so I
cant
select it again. Is there another way I can get this information?

Daniel





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