Focal Point
Business View.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9727032706

July 21, 2011, 05:19 PM
RaviD
Business View.
All,

I am trying to create a LEFT OUTER JOIN in a businees view, right after save, it is saving as a inner join. could any one help me on how to add left outer join to Busness View?

Thanks
Ver. 7.7.01


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
July 27, 2011, 05:27 AM
Ramkumar - Webfous
quote:
LEFT OUTER JOIN in a businees view


Are you going for a SQL query or Join command?

Could you please post down your code here ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
August 02, 2011, 01:46 PM
RaviD
Thanks Ram,
Here is the sample code, here i am trying to add left outer join instead of inner join(JOIN_WHERE) in of the following joins.

FILENAME=bv_starts_terms, SUFFIX=SQLMSS , $
SEGMENT=FACT_STARTS_TERMS, SEGTYPE=S0, $
FIELDNAME=OP_CO_GK, ALIAS=OP_CO_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=COMPANY_GK, ALIAS=COMPANY_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=BUSINESS_UNIT_GK, ALIAS=BUSINESS_UNIT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=PRODUCT_GK, ALIAS=PRODUCT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=SEGMENT_GK, ALIAS=SEGMENT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=OPR_UNT_GK, ALIAS=OPR_UNT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=CUST_GK, ALIAS=CUST_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=REQ_POS_GK, ALIAS=REQ_POS_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=CONTR_GK, ALIAS=CONTR_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=ACTUAL_START_DATE_GK, ALIAS=ACTUAL_START_DATE_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=START_TERM_IND_GK, ALIAS=START_TERM_IND_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=PROJ_END_DATE_GK, ALIAS=PROJ_END_DATE_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=REQ_ADJ_FLAG, ALIAS=REQ_ADJ_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Start is due to a requisition adjustment in PeopleSoft and should not be counted as a true Start', $
FIELDNAME=LATE_START_FLAG, ALIAS=LATE_START_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Start was entered into PeopleSoft late, after the contractor actually started working on the position', $
FIELDNAME=LATE_FINISH_FLAG, ALIAS=LATE_FINISH_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Fnish/Termination was entered into PeopleSoft late, after the contractor actually stopped working on the position', $
FIELDNAME=INSERT_DTTM, ALIAS=INSERT_DTTM, USAGE=HYYMDs, ACTUAL=HYYMDs,
TITLE='Date/Time ?', DESCRIPTION='The timestamp when this row was inserted into the table', $
FIELDNAME=INSERT_BY, ALIAS=INSERT_BY, USAGE=A30V, ACTUAL=A30V,
TITLE='Inserted By', DESCRIPTION='The identifier of the process or user who inserted this row into the table', $
FIELDNAME=LAST_MOD_DTTM, ALIAS=LAST_MOD_DTTM, USAGE=HYYMDs, ACTUAL=HYYMDs,
MISSING=ON,
TITLE='Last Modified Date/Time', DESCRIPTION='The timestamp when this row was modified', $
FIELDNAME=LAST_MOD_BY, ALIAS=LAST_MOD_BY, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
TITLE='Last Modified By', DESCRIPTION='The identifier of the process or user who last modified this row in the table', $
FIELDNAME=BURDEN_PCT_SUM, ALIAS=BURDEN_PCT_SUM, USAGE=P7.2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=ACTUAL_END_DATE_GK, ALIAS=ACTUAL_END_DATE_GK, USAGE=P13, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=START_TERM_LINK_GK, ALIAS=START_TERM_LINK_GK, USAGE=P13, ACTUAL=P8,
MISSING=ON, $
SEGMENT=DIM_COMPANY, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_COMPANY, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.OP_CO_GK EQ DIM_COMPANY.COMPANY_GK;, $
SEGMENT=DIM_BUSINESS_UNIT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_BUSINESS_UNIT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.BUSINESS_UNIT_GK EQ DIM_BUSINESS_UNIT.BUSINESS_UNIT_GK;, $
SEGMENT=DIM_PRODUCT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_PRODUCT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.PRODUCT_GK EQ DIM_PRODUCT.PRODUCT_GK;, $
SEGMENT=DIM_SEGMENT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_SEGMENT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.SEGMENT_GK EQ DIM_SEGMENT.SEGMENT_GK;, $
SEGMENT=DIM_OPERATING_UNIT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_OPERATING_UNIT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.OPR_UNT_GK EQ DIM_OPERATING_UNIT.OPR_UNT_GK;, $
SEGMENT=DIM_CUSTOMER, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CUSTOMER, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.CUST_GK EQ DIM_CUSTOMER.CUST_GK;, $
SEGMENT=DIM_REQUISITION_POS, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_REQUISITION_POS, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.REQ_POS_GK EQ DIM_REQUISITION_POS.REQ_POS_GK;, $
SEGMENT=DIM_CONTRACTOR, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CONTRACTOR, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.CONTR_GK EQ DIM_CONTRACTOR.CONTR_GK;, $
SEGMENT=FACT_STARTS_HISTORY, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/FACT_STARTS_HISTORY, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.REQ_POS_GK EQ FACT_STARTS_HISTORY.REQ_POS_GK;, $
SEGMENT=DIM_CALENDAR_ACTUAL_START, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=ACTUAL_START_DATE_GK EQ DIM_CALENDAR_ACTUAL_START.DATE_GK;, $
SEGMENT=DIM_CALENDAR_ACTUAL_END, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=ACTUAL_END_DATE_GK EQ DIM_CALENDAR_ACTUAL_END.DATE_GK;, $
SEGMENT=DIM_CALENDAR_PROJECTED_END, SEGTYPE=KU, PARENT=FACT_STARTS_HISTORY, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_HISTORY.PROJ_END_DATE_GK EQ DIM_CALENDAR_PROJECTED_END.DATE_GK;, $
SEGMENT=DIM_CALENDAR_EFF_END, SEGTYPE=KU, PARENT=FACT_STARTS_HISTORY, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=EFF_DATE_GK EQ DIM_CALENDAR_EFF_END.DATE_GK;, $
SEGMENT=DIM_STATUS_ST_IND, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_STATUS, CRSEGMENT=DIM_STATUS, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.START_TERM_IND_GK EQ STATUS_GK;, $


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports