how to declare a configurable constant that I can use across all script , or in configuration ?

Question

For example , I can use the

query = query.replace ('p_client_id',parameters.get('client_id'));

in Dataset scripting

or

I am use

select * from my_table where id =  $P{client_id}

or

in cockpic dataset config , I can use  $P{client_id}  for input parameter

so I want to ask if it is possible for me to declare the global constant setting , that best to have configrable in db

Answer 1

Dear kstang,

I'm not sure about this question (please explain me better if I didn't understand), if you want to use a parameter and you want to fill it only in a single place, you can use Profile Attributes

If you want to declare a variable using $P{} as name in order to use it everywhere it is not possible.

Regards

Matteo

Comments

I want to have something syntax like $P{} that value is the same for which I can use across all the data set , value may be some global constant for all dateset