BAQ Calc Field for Table Lookup

Yahoo Archive
1
Unless someone else smarter then me has figured it out, I'm going to say no.. I wanted to do the same thing and my workaround was to create a BPM that dumped the names of the reps into UD fields on the OrderHed table whenever the order is saved.

The problem with trying to do this in a 8.03 BAQ is two fold: one is that you can't link a table to a calculated field, and two you can't link a table more then once. And while it might be possible (I've never tried it) to run an external progress program from a calc field in a BAQ, I don't see any way it could pass a value back to that field..


________________________________
From: bonner.nathan <bonner.n@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 5, 2009 12:38:15 PM
Subject: [Vantage] BAQ Calc Field for Table Lookup

Â
We are on Vantage 8.03.406a SQL

I am working on a BAQ for a dashboard. I have taken OrderHed.SalesRepLi st (which is a '~' separated list) and broken out each SalesRepCode on a separate BAQ Calc Field. Now I want to use the results of these Calc Fields to look up the SalesRep.Name value.

Is there a way to use a BAQ Calc Field for a lookup to a table not specified in the Query?

For example:

For each OrderHed no-lock.

Find first SalesRep where (SalesRep.Company = OrderHed.Company and SalesRep.SalesRepCo de = Entry(1,OrderHed. SalesRepList, "~~") no-lock.

If available SalesRep then do:

Assign [BAQCalcField] = SalesRep.Name

End.

If not available SalesRep then return.

End.

Has anyone ever gotten anything like this to work?

Thanks,

NB







[Non-text portions of this message have been removed]
2
We are on Vantage 8.03.406a SQL

I am working on a BAQ for a dashboard. I have taken OrderHed.SalesRepList (which is a '~' separated list) and broken out each SalesRepCode on a separate BAQ Calc Field. Now I want to use the results of these Calc Fields to look up the SalesRep.Name value.

Is there a way to use a BAQ Calc Field for a lookup to a table not specified in the Query?

For example:

For each OrderHed no-lock.

Find first SalesRep where (SalesRep.Company = OrderHed.Company and SalesRep.SalesRepCode = Entry(1,OrderHed.SalesRepList,"~~") no-lock.

If available SalesRep then do:

Assign [BAQCalcField] = SalesRep.Name

End.

If not available SalesRep then return.

End.


Has anyone ever gotten anything like this to work?

Thanks,

NB