Create other variables
One of the features in OfficeReports which makes this process smooth is ‘Create other variables like this one’. This feature relates to derived categorical variables, so to find the feature we must first have produced at least one derived categorical variable.
Mark a derived categorical variable and this feature emerges:
A few examples explain how this feature works:
10 numeric variables contain numbers from 1 – 99 which we need organized as derived category variables containing the two categories ‘1 – 49’, and ’50 – 99’.

Mark one of the numeric variables and use the feature ‘Create Interval Variable’ to produce a derived categorical variable containing two categories ‘1 – 49’, and ’50 – 99’

Mark the newly derived categorical variable and press the button ‘Create other variables like this one’

A window pops up showing all numeric variables, which potentially could be turned into similar, derived categorical variables.

Select the 9 similar numeric variables, and OfficeReports will start producing the 9 derived categorical variables each containing the two categories ‘1 – 49’, and ’50 – 99’.
15 categorical variables contain the same categories:
 ‘Strongly Agree’
 ‘Agree’
 ‘Disagree’
 ‘Strongly Disagree’
We need to organize these as derived category variables each containing the two categories:
 ‘Strongly Agree’ or ‘Agree’
 ‘Disagree’ or ‘Strongly Disagree’

Mark one of the categorical variables and use the feature ‘Copy Selected Variable’.

Press the button ‘Categories’à’Merge Categories and produce the two categories:

‘Strongly Agree’ or ‘Agree’

‘Disagree’ or ‘Strongly Disagree’


Mark the newly derived categorical variable and press the button ‘Create other variables like this one’.

A window pops up showing all numeric variables, which potentially could be turned into similar, derived categorical variables.

Select the 14 similar categorical variables, and OfficeReports will start producing the 14 derived categorical variables each containing the two categories.
Observe
The derived categorical variable is always based on a ‘parent’ variable. This means that the categories relate to a parent variable. Now what if some categories relate to one parent variable and other to other variables? How can OfficeReports then ‘Create other variables like this one’? The answer is this: OfficeReports will detect only one variable as parent. This means that only formulas and formula elements related to the parent will change dynamically when we ‘Create other variables like this one.