Hi all,

I have created a master file with a filter, that is using a variable for passing user defined value at run time, as below:

FILENAME=asmpl_five, SUFFIX=SQLMSS  , $
 VARIABLE NAME=&&DEPID,  USAGE=I11, $
  SEGMENT=DEPARTURE, SEGTYPE=S0, $
    FIELDNAME=DEPARTURE_ID, ALIAS=Departure_Id, USAGE=I11, ACTUAL=I4, FIELDTYPE=R, $
    FIELDNAME=DEPARTURE_ORIGINALDATE, ALIAS=Departure_OriginalDate, USAGE=HYYMDs, ACTUAL=HYYMDs, $
    FIELDNAME=DEPARTURE_ORIGINALTIME, ALIAS=Departure_OriginalTime, USAGE=A4, ACTUAL=A4, $
    DEFINE YEAR/YY=HDATE(DEPARTURE_ORIGINALDATE,'YYMD');
      TITLE='Year', DESCRIPTION='Year',
      WITHIN='*Time Dimension', $
    DEFINE QUARTER/Q=HDATE(DEPARTURE_ORIGINALDATE,'YYMD');
      TITLE='Quarter', DESCRIPTION='Quarter',
      WITHIN=YEAR, $
    DEFINE MONTH/M=HDATE(DEPARTURE_ORIGINALDATE,'YYMD');
      TITLE='Month', DESCRIPTION='Month',
      WITHIN=QUARTER, $
    FILTER FILTER1=DEPARTURE_ID EQ &&DEPID; $
  SEGMENT=DEPARTURE_DETAILS, SEGTYPE=S0, PARENT=DEPARTURE,
    JOIN_WHERE=DEPARTURE_ID EQ DEPARTURE_DETAIL_DEPARTURE_ID_FK;, $
    FIELDNAME=DEPARTURE_DETAIL_ID, ALIAS=Departure_Detail_Id, USAGE=I11, ACTUAL=I4, FIELDTYPE=R, ACCESS_PROPERTY=(INTERNAL), $
    FIELDNAME=DEPARTURE_DETAIL_LEG_SEG_TYPE, ALIAS=Departure_Detail_Leg_Seg_Type, USAGE=A50V, ACTUAL=A50V,
      MISSING=ON, $
    FIELDNAME=DEPARTURE_DETAIL_DEPARTURE_ID_FK, ALIAS=Departure_Detail_Departure_Id_fk, USAGE=I11, ACTUAL=I4, ACCESS_PROPERTY=(INTERNAL), $
    FIELDNAME=DEPARTURE_DETAIL_ROUTE_LEG_SEGMENT_ID_FK, ALIAS=Departure_Detail_Route_Leg_Segment_Id_fk, USAGE=I11, ACTUAL=I4, ACCESS_PROPERTY=(INTERNAL), $
  SEGMENT=DEPARTURE_DETAIL_CAPTURES, SEGTYPE=S0, PARENT=DEPARTURE_DETAILS,
    JOIN_WHERE=DEPARTURE_DETAIL_ID EQ DEPARTURE_DETAIL_CAPTURE_DEPATURE_DETAILS_ID_FK;, $
    FIELDNAME=DEPARTURE_DETAIL_CAPTURE_DEPATURE_DETAILS_ID_FK, ALIAS=Departure_Detail_Capture_Depature_Details_Id_fk, USAGE=I11, ACTUAL=I4, ACCESS_PROPERTY=(INTERNAL), $
    FIELDNAME=DEPARTURE_DETAIL_CAPTURE_DATE, ALIAS=Departure_Detail_Capture_Date, USAGE=HYYMDs, ACTUAL=HYYMDs, $
 DIMENSION=Time Dimension, CAPTION='Time Dimension', $
  HIERARCHY=Time Dimension, CAPTION='Time Dimension', HRY_DIMENSION=Time Dimension, HRY_STRUCTURE=STANDARD, $
  FOLDER=FOLDER1, $
    FIELDNAME=FILTER1, ALIAS=FILTER1, $
    FIELDNAME=DEPARTURE_ID, ALIAS=DEPARTURE_ID, $
    FIELDNAME=DEPARTURE_ORIGINALDATE, ALIAS=DEPARTURE_ORIGINALDATE, $

but I am getting no prompting for the variable value when I call the same master file in InfoAssist.

Please suggest me the possible solution

Hi Kumud,

If you have not done so, you may want to open a case with Customer Support Services so that we have someone assigned to review your file and work with you to resolve the issue. The phone number is 1-800-736-6130, or you can access online at InfoResponse.

Cheers,

Kerry