Hello Everyone,

Hoping you guys can help me with a little task I have. I want to create a filter in my synonym. Specifically a date filter. However I want to be able to select the value for this filter for those reports using this synonym at run time. Basically I am trying to create a parameter that normally is created in a report, and throw it back a level.

Has anyone done something like that before? I am aware of how to create a variable within a synonym (syntax in text below), however I have no clue how to make it into a parameter.
VARIABLE NAME=&&DATE_NAME, USAGE=I10, $

*EDIT* My reason for doing this is that I am working with a no-SQL Database that is indexed on a date field. Thus in every single report/chart we need to have this parameter in there. What I would like to do is allow those building these charts to simply drag a filter instead of having to set up a parameter every single time.

Appreciate any advice you all have!
Thanks

Zach

This message has been edited. Last edited by: FP Mod Chuck,

You can use a DBA rule to apply it:

 
FILENAME=CAR, SUFFIX=FOC     ,
 REMARKS='Legacy Metadata Sample: car', $
 VARIABLE NAME=&&COUNTRY,  $
  SEGMENT=ORIGIN, SEGTYPE=S1, $
    FIELDNAME=COUNTRY, ALIAS=COUNTRY, USAGE=A10, FIELDTYPE=I, $
  SEGMENT=COMP, SEGTYPE=S1, PARENT=ORIGIN, $
    FIELDNAME=CAR, ALIAS=CARS, USAGE=A16, $
  SEGMENT=CARREC, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=MODEL, ALIAS=MODEL, USAGE=A24, $
  SEGMENT=BODY, SEGTYPE=S1, PARENT=CARREC, $
    FIELDNAME=BODYTYPE, ALIAS=TYPE, USAGE=A12, $
    FIELDNAME=SEATS, ALIAS=SEAT, USAGE=I3, $
    FIELDNAME=DEALER_COST, ALIAS=DCOST, USAGE=D7, $
    FIELDNAME=RETAIL_COST, ALIAS=RCOST, USAGE=D7, $
    FIELDNAME=SALES, ALIAS=UNITS, USAGE=I6, $
  SEGMENT=SPECS, SEGTYPE=U, PARENT=BODY, $
    FIELDNAME=LENGTH, ALIAS=LEN, USAGE=D5, $
    FIELDNAME=WIDTH, ALIAS=WIDTH, USAGE=D5, $
    FIELDNAME=HEIGHT, ALIAS=HEIGHT, USAGE=D5, $
    FIELDNAME=WEIGHT, ALIAS=WEIGHT, USAGE=D6, $
    FIELDNAME=WHEELBASE, ALIAS=BASE, USAGE=D6.1, $
    FIELDNAME=FUEL_CAP, ALIAS=FUEL, USAGE=D6.1, $
    FIELDNAME=BHP, ALIAS=POWER, USAGE=D6, $
    FIELDNAME=RPM, ALIAS=RPM, USAGE=I5, $
    FIELDNAME=MPG, ALIAS=MILES, USAGE=D6, $
    FIELDNAME=ACCEL, ALIAS=SECONDS, USAGE=D6, $
  SEGMENT=WARANT, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=WARRANTY, ALIAS=WARR, USAGE=A40, $
  SEGMENT=EQUIP, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=STANDARD, ALIAS=EQUIP, USAGE=A40, $
END
DBA=TEST, $
USER=, ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=COUNTRY EQ '&&COUNTRY', $
 

How about using a "-PROMPT" in your fex along with the setting of the variable in the synonym?