Skip to Content
avatar image
Former Member

Business View Manager Data Foundation- Join Tables

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2010 at 11:38 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded