Tm1 paratmeter question

[ravi]

Hi,

Need some advise-
I have modified and existing sql querry in TI process and difined all the variable.
for year variable I have 2011

when I save and run the TI process- it say provide Pararmeter.

infact pararmeter is already defined in Advance->paremeter (attached screensot)

My question - do we need define every time parameter while running the TI process manually.

Regards,
Ravi

[David Usherwood]

You've provided a _default_. Press Enter and that's what'll be used. Change it if you want to process another year.
If you don't want to change it, assign it in the TI - but I would have thought it will need to change as time moves on.

[lotsaram]

The whole point of providing a parameter is this is information that by definition needs to be provided at runtime.

If you just want the process to run without providing parameters but have some ability to configure "runtime options" then rather than a parameter you could create a variable on the prolog and populate it with a CellGetS from a control cube holding the year to load. As the entire prolog runs before executing any query you can still pass a variable from the prolog into a query just as you would a parameter.