variables in Essbase rule file query

Summary

variables in Essbase rule file query

Content

Hi Gurus,

How can I use variable/parameters in rule file

in my rule file sql query I need to use varibles .

select * from factdata where time='$yr'

will pass the parameters for $yr user can select whatever year he wants

passing the parameter from database /ksh script

how can I use it.

pls suggest