variable creation which one is better

[#1]

Hi all,

Have a nice day.

performance wise which method is better for creating Variable

Method 1: By going into menu -> settings/variable overview

Method 2: By using SET and LET statements.

Method 1 and method 2 both are same result

Thank,

ramu

[sasikanth]

Hi,

case comes only when a  variable evaluates complex expression

in that case

In front end for every selection expressions need to be evaluated

if you are able to calculate this exp from backed then declare at script level

[avinashelite]

As per my knowledge LET method does not evaluate and hence it will have better performance but you cannot do the dynamic changes. Other than this both the ways of the setting the variables are same does not have much of the difference in the performance

[jonathandienst]

The main advantage of creating the variables in the load script is that the variables are preserved in the case of a no-data load. You may need a no-data load for recovering a corrupt qvd or rolling back to an older version when you are using version control. In these cases, the variables exist in the empty document, but are all set to null.

If they are defined in the load script, then they will be recreated when the empty document is reloaded. Which is why I recommend that the variables be defined in the load script.

[jagan]

Hi,

Creating in script will help in easily maintenance if you want to change many variables you can change it easily in script, instead of searching in variables tab.

If you require the same in another Dashboard you can just copy the script and use it in the new one.

Regards,

Jagan.

[kashaboinaraj]

Hi

creating variable in script is better because for searching for variable it is easy to go direcrtly to the script location for changes.

Regards

vishnu