Business View Manager Data Foundation- Join Tables

[Former Member]

I need to join two tables in Business View Manager Data Foundation

Table1

Transaction Date = 05/11/2010

Count = 7

Table2

Period Start Date = 05/01/2010

Period End Date = 05/15/2010

and end up with

Transaction Date = 05/11/2010

Count = 7

Period Start Date = 05/01/2010

Period End Date = 05/15/2010

I can do this with a sql expression, i.e.

SELECT PA_Daily_Unit_Hist.Census_Date, PA_Daily_Unit_Hist.Facility_Type, PA_Daily_Unit_Hist.Count___of_Units, PR_Period_End_Dates.Period_End_Date, PR_Period_End_Dates.Check_Date

FROM PA_Daily_Unit_Hist, PR_Period_End_Dates

WHERE PA_Daily_Unit_Hist.Census_Date BETWEEN (PR_Period_End_Dates.Period_End_Date - 13) AND PR_Period_End_Dates.Period_End_Date;

but how do I do this in Business View Manager?

[Former Member · Accepted solution]

Hi,

Try these steps.

1. In the Data Foundation window, select Insert -> Insert Data Tables

2. You will find Add Command option under your Data Connection name in Insert Data Tables dialog box

3. Paste your query into the Add Command

The Command will appear along with other tables under the Tables in Objects Explorer window.

Hope this helps.