narender

• Jul 23rd, 2007

 

By using parameter map

zecar

 Profile Answers by zecar Questions by zecar

• Sep 19th, 2007

 

The syntax is as follows:

LOOKUP (name) in (value1 --> value2) default (name)

Name: the name of your column

value1: value you would like to be replaced

value2: value you would like to replace it with

default is the name of your default column.

This is an example from our Go Sales database. Canada is being replaced by
Ottawa and France will be replaced by Paris.

Steps:

Select the gosales_goretailers namespace.

From the right click menu, select Create, Calculation.

Copy the following expression and paste it into the Expression Definition dialog
box

"lookup ([gosales_goretailers].[Countries].[Country])IN ('Canada'-->'Ottawa'
,'France'-->'Paris' )

default ([gosales_goretailers].[Countries].[Country])"

Click the Test button.

After this is run you will notice that the entry for Canada has a value of
Ottawa.