| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Hello ;
Can we report with different RDB databases uisng FOCUS ?
Is there some retriction about this ?
Regards
Philippe
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 330.1 | Yes you can join multiple Rdb databases | BOXTOP::ESTES | Tue May 01 1990 13:55 | 188 | |
Yes you can report/join multiple Rdb databases using Focus.
Each segment can address one database relation or view. A Focus Master/ACX
can report/join many segments thus you can join many databases.
You use the database name in the ACX segment TABLE= clause. The syntax is
TABLE="DBNAME.REL_OR_VIEW_NAME"
If the database name (or its logical name) is longer than 8 characters, or is
not in the default VMS directory you can create a Focus Filedef name to
point to it. A Filedef name is a max of 8 characters long and works like
a VMS Logical. The Filedef must be executed in a Fex prior to using it
in a ACX file.
Attached is a working example of a Fex, ACX and Master file. The Fex creates
Filedef's for two databases. note that the Filedef's point to the database
logical names rather than the physical name. Following the Fex are two segments
from the ACX and Master files. The segments are joined and the each segment
refences data in different databases.
* FOCUS FEX TO FILEDEF THE MSB8QVP FOCUS MASTER AND ALL
* DATABASES REQUIRED FOR IT
*
FILEDEF MSB8QVP DISK MSB8QVP
*
* NOW FILEDEF THE TMP NAME OF THE DATABASES TO THEIR LOGICAL NAMES
*
FILEDEF MBU_VOL DISK VOLUMES:
FILEDEF MBU_SUBJ DISK MBUSUBJS:
*
* END OF DATABASE FILEDEFS
*
$ Focus ACX (Cross Reference) for MSB8QVP
$ Generated by the Encyclopedia on
$ 30-Apr-1990 11:58:55.01
$
SEGNAME=FRCSTPRD ,
TABLENAME="MBU_VOL.MBU_8QVP_FORECASTED_PRODUCT" ,
KEYS=,WRITE=NO,
$
FIELD=CPU_FDOL , ALIAS=CPU_FRCST_SHIP_AMT ,TYPE=G, $
FIELD=CPU_FQTY , ALIAS=CPU_FRCST_SHIP_QTY , $
FIELD=FCST_QTR , ALIAS=FRCSTD_SHIP_FQTR , $
FIELD=PLN_REV_CD , ALIAS=FRCST_PLN_RVSN_CD , $
FIELD=FCST_YR , ALIAS=FRCST_SHIP_YR , $
FIELD=FAMLY_CD , ALIAS=PRODT_FAMLY_CD , $
FIELD=PASS_DT , ALIAS=PRODT_FRCST_PLN_SUBMTL_DT , $
FIELD=MODEL_CD , ALIAS=PRODT_MODEL_CD , $
$
$
SEGNAME=NOR ,
TABLENAME="MBU_VOL.MBU_8QVP_NOR_MLP_INFO" ,
KEYS=,WRITE=NO,
KEYFLD=PLN_REV_CD/FCST_YR/PASS_DT/MODEL_CD,
IXFLD=PLN_REV_CD03/FCST_YR03/PASS_DT03/MODEL_CD03,
$
FIELD=PLN_REV_CD03, ALIAS=FRCST_PLN_RVSN_CD , $
FIELD=FCST_YR03 , ALIAS=FRCST_SHIP_YR , $
FIELD=NOR_PCT , ALIAS=NOR_PERCT , $
FIELD=PASS_DT03 , ALIAS=PRODT_FRCST_PLN_SUBMTL_DT , $
FIELD=MODEL_CD03 , ALIAS=PRODT_MODEL_CD , $
$
FILE=MSB8QVP , SUFFIX=RDB
$ Focus Master for MSB8QVP
$ Generated by the Encyclopedia on
$ 30-Apr-1990 11:58:55.01
$
$Focus Master for all 8 Quarter Volume plan canned reports
$
$
SEGNAME=FRCSTPRD,SEGTYPE=S0,
$
FIELD=CPU_FDOL , ALIAS= ,
USAGE =D15.2 ,
ACTUAL=D8 ,
TITLE='CPU Unit,Forecast Ship,Dollars',$
$
$ BASED ON: CPU_FRCST_SHIP_AMT
$ DESC: CPU dollar values forecasted to ship off the dock for a specif
$
FIELD=CPU_FQTY , ALIAS= ,
USAGE =I8 ,
ACTUAL=I4 ,
TITLE='CPU,Forecast,QTY',$
$
$ BASED ON: CPU_FRCST_SHIP_QTY
$ DESC: The number of cpu's that are forecasted to ship off the dock
$
FIELD=FCST_QTR , ALIAS= ,
USAGE =I6 ,
ACTUAL=I2 ,
TITLE='FRCST,SHIP,FQ',$
$
$ BASED ON: FQTR
$ DESC: FORCASTED SHIP 3 CONS MOS PER DEC FISCAL CALENDAR
$
FIELD=PLN_REV_CD , ALIAS= ,
USAGE =A2 ,
ACTUAL=A2 ,
TITLE='Plan,Revsion,Number',$
$
$ BASED ON: FRCST_PLN_RVSN_CD
$ DESC: New, Current or revision Product Forecast Plan
$
FIELD=FCST_YR , ALIAS= ,
USAGE =I6 ,
ACTUAL=I2 ,
TITLE='FRCST,SHIP,FY',$
$
$ BASED ON: FYR
$ DESC: FORCASTED SHIP FISCAL YEAR, PER DEC CORP FISCAL CALENDAR
$
FIELD=FAMLY_CD , ALIAS= ,
USAGE =A7 ,
ACTUAL=A7 ,
TITLE='Product,Family,Code',$
$
$ BASED ON: PRODT_FAMLY_CD
$ DESC: Code Identifying a group of product models that form a higher
$
FIELD=PASS_DT , ALIAS= ,
USAGE =I6 ,
ACTUAL=I2 ,
TITLE='Plan,Pass,Date',$
$
$ BASED ON: PRODT_FRCST_PLN_SUBMTL_DT
$ DESC: Fiscal Year and Qtr (892) which a product Forecast plan is sub
$
FIELD=MODEL_CD , ALIAS= ,
USAGE =A7 ,
ACTUAL=A7 ,
TITLE='Product,Model,Code,Cpu,Name',$
$
$ BASED ON: PRODT_MODEL_CD
$ DESC: Code which identifies a specific model belonging to a family o
$
$
$
SEGNAME=NOR,SEGTYPE=U ,
PARENT=FRCSTPRD,
$
FIELD=PLN_REV_CD03, ALIAS= ,
USAGE =A2 ,
ACTUAL=A2 ,
TITLE='Plan,Revsion,Number',$
$
$ BASED ON: FRCST_PLN_RVSN_CD
$ DESC: New, Current or revision Product Forecast Plan
$
FIELD=FCST_YR03 , ALIAS= ,
USAGE =I6 ,
ACTUAL=I2 ,
TITLE='FRCST,SHIP,FY',$
$
$ BASED ON: FYR
$ DESC: FORCASTED SHIP FISCAL YEAR, PER DEC CORP FISCAL CALENDAR
$
FIELD=NOR_PCT , ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='NOR,Rates',$
$
$ BASED ON: NOR_PERCT
$ DESC: Portion of gross MLP that belongs to NOR (Net Operating Revenu
$
FIELD=PASS_DT03 , ALIAS= ,
USAGE =I6 ,
ACTUAL=I2 ,
TITLE='Plan,Pass,Date',$
$
$ BASED ON: PRODT_FRCST_PLN_SUBMTL_DT
$ DESC: Fiscal Year and Qtr (892) which a product Forecast plan is sub
$
FIELD=MODEL_CD03 , ALIAS= ,
USAGE =A7 ,
ACTUAL=A7 ,
TITLE='Product,Model,Code,Cpu,Name',$
$
$ BASED ON: PRODT_MODEL_CD
$ DESC: Code which identifies a specific model belonging to a family o
$
$
| |||||