I need to hide fields from a JOINed file in the field list of a Reporting Object at my user's request. I'm not sure how to do this and am pressed for time. Hoping someone can help.
Thanks!

This message has been edited. Last edited by: Tamra,

PhillyPat,
You can create a Business View of the file(s) where you want to hide some fields. Then delete, don't include, or assign them as INTERNAL, the fields you want to hide from the user.
Review 'Business View' for more detail.
This technique has worked very well for me.
Good luck.

do you want an example?
here's a master file for a joined entity
then below it is a master file (that's all you need, just the master) for the business_view of that joined entity.
You'll see how you comment out the fields you don't want to show.
works like a charm

FILENAME=FDW_LEDGER_AGG_MV_2017, SUFFIX=SQLORA  , $
SEGMENT=FDW_LEDGER_AGG_MV_2017, SEGTYPE=S0, $
FIELDNAME=FISCAL_MONTH_KEY, ALIAS=FISCAL_MONTH_KEY, USAGE=P4, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=FUND_KEY, ALIAS=FUND_KEY, USAGE=P4, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=ORG_KEY, ALIAS=ORG_KEY, USAGE=P7, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=PROGRAM_KEY, ALIAS=PROGRAM_KEY, USAGE=P6, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=PROJECT_KEY, ALIAS=PROJECT_KEY, USAGE=P7, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=ACCOUNT_KEY, ALIAS=ACCOUNT_KEY, USAGE=P7, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P8,      MISSING=ON, $
FIELDNAME=OP_UNIT, ALIAS=OP_UNIT, USAGE=A5, ACTUAL=A5, $
FIELDNAME=DEPTID, ALIAS=DEPTID, USAGE=A10, ACTUAL=A10, $
FIELDNAME=ACTUAL, ALIAS=ACTUAL, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=BUDGET, ALIAS=BUDGET, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=VARIANCE, ALIAS=VARIANCE, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=BALANCE_BEG, ALIAS=BALANCE_BEG, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=ANNUAL_BUDGET, ALIAS=ANNUAL_BUDGET, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=ENCUMBRANCE, ALIAS=ENCUMBRANCE, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_ACTUAL, ALIAS=YTD_ACTUAL, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_BUDGET, ALIAS=YTD_BUDGET, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_VARIANCE, ALIAS=YTD_VARIANCE, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_BALANCE_BEG, ALIAS=YTD_BALANCE_BEG, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_BALANCE_END, ALIAS=YTD_BALANCE_END, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=YTD_ENCUMBRANCE, ALIAS=YTD_ENCUMBRANCE, USAGE=D20.2, ACTUAL=D8,      MISSING=ON, $
FIELDNAME=REFRESH_DATE_TIME, ALIAS=REFRESH_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS,      MISSING=ON, $
$$ FILENAME=FDW_BUSINESS_UNIT, SUFFIX=SQLORA  , $
SEGMENT=FDW_BUSINESS_UNIT, SEGTYPE=KLU,PARENT=FDW_LEDGER_AGG_MV_2017,CRFILE=FDW_BUSINESS_UNIT, $
FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P2, $
FIELDNAME=BUSINESS_UNIT, ALIAS=BUSINESS_UNIT, USAGE=A10, ACTUAL=A10,      MISSING=ON, $
FIELDNAME=BUSINESS_UNIT_DESC, ALIAS=BUSINESS_UNIT_DESC, USAGE=A50, ACTUAL=A50,      MISSING=ON, $
FIELDNAME=MEDICAL_CENTER, ALIAS=MEDICAL_CENTER, USAGE=A10, ACTUAL=A10,      MISSING=ON, $
FIELDNAME=MEDICAL_CENTER_DESC, ALIAS=MEDICAL_CENTER_DESC, USAGE=A50, ACTUAL=A50,      MISSING=ON, $
FIELDNAME=CREATE_DATE_TIME, ALIAS=CREATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_DATE_TIME, ALIAS=UPDATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A20, ACTUAL=A20,      MISSING=ON, $

and now the business view of that master (no acx needed)

FILENAME=FDW_LEDGER_2017_BV, VIEW_OF=FDW_LEDGER_JOINED_2017,$
SEGMENT=measures,   $
$$     FIELDNAME=FISCAL_MONTH_KEY, ALIAS=FISCAL_MONTH_KEY, USAGE=P4, ACTUAL=P8,MISSING=ON, $
$$     FIELDNAME=FUND_KEY, ALIAS=FUND_KEY, USAGE=P4, ACTUAL=P8,MISSING=ON, $
$$     FIELDNAME=ORG_KEY, ALIAS=ORG_KEY, USAGE=P7, ACTUAL=P8,  MISSING=ON, $
$$     FIELDNAME=PROGRAM_KEY, ALIAS=PROGRAM_KEY, USAGE=P6, ACTUAL=P8,MISSING=ON, $
$$    FIELDNAME=PROJECT_KEY, ALIAS=PROJECT_KEY, USAGE=P7, ACTUAL=P8,MISSING=ON, $
$$    FIELDNAME=ACCOUNT_KEY, ALIAS=ACCOUNT_KEY, USAGE=P7, ACTUAL=P8,MISSING=ON, $
$$    FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P8,      MISSING=ON, $
$$     FIELDNAME=OP_UNIT, ALIAS=OP_UNIT, USAGE=A5, ACTUAL=A5, $
FIELDNAME=ACTUAL,       ALIAS=ACTUAL,       BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=ENCUMBRANCE,  ALIAS=ENCUMBRANCE,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=BUDGET,       ALIAS=BUDGET,       BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=VARIANCE,     ALIAS=VARIANCE,     BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_ACTUAL,   ALIAS=YTD_ACTUAL,   BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_ENCUMBRANCE, ALIAS=YTD_ENCUMBRANCE,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_BUDGET,   ALIAS=YTD_BUDGET,   BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_VARIANCE, ALIAS=YTD_VARIANCE,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_BALANCE_BEG, ALIAS=YTD_BALANCE_BEG,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=YTD_BALANCE_END, ALIAS=YTD_BALANCE_END,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
FIELDNAME=BALANCE_BEG,  ALIAS=BALANCE_BEG,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017,$
FIELDNAME=ANNUAL_BUDGET, ALIAS=ANNUAL_BUDGET,  BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $
$$     FIELDNAME=REFRESH_DATE_TIME, ALIAS=REFRESH_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS,      MISSING=ON, $
$$ FILENAME=FDW_BUSINESS_UNIT, SUFFIX=SQLORA  , $
SEGMENT=businessunit,   $
$$     FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P2, $
FIELDNAME=BUSINESS_UNIT,      ALIAS=BUSINESS_UNIT,     BELONGS_TO_SEGMENT=FDW_BUSINESS_UNIT,  $
FIELDNAME=BUSINESS_UNIT_DESC, ALIAS=BUSINESS_UNIT_DESC,BELONGS_TO_SEGMENT=FDW_BUSINESS_UNIT,$
$$    FIELDNAME=MEDICAL_CENTER, ALIAS=MEDICAL_CENTER, USAGE=A10, ACTUAL=A10,      MISSING=ON, $
$$    FIELDNAME=MEDICAL_CENTER_DESC, ALIAS=MEDICAL_CENTER_DESC, USAGE=A50, ACTUAL=A50,      MISSING=ON, $
$$    FIELDNAME=CREATE_DATE_TIME, ALIAS=CREATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $
$$    FIELDNAME=UPDATE_DATE_TIME, ALIAS=UPDATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $
$$    FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A20, ACTUAL=A20,      MISSING=ON, $

Hi

Additional 2 methods:

1. At least with WF8 you can specify in the master file that a field is for "internal" use and will not show in IA GUI
for example:

FIELDNAME=DURATION, ALIAS=DAYS, USAGE=I3, ACCESS_PROPERTY=(INTERNAL), $

2. Older technique is to use the &&IBI_IF_FLDS technique, you can give a unique prefix to the fields names in the master file you wish to hide and then specify a fex which will exclude them:

documentation