how to replace values in a dimension

[siddharthsoam]

i m using  if("SBU Head Name"='-' and CBU='-','others') as "SBU Head Name" condition in load editor, but it is giving me error as sbu head name already exists. I want my sbu head name's satisfying the condition to be relpaced by others

[jonathandienst]

Either
Change the name of the derived field so it does not conflict with the existing field

Or

Remove the other [SBU Head Name] from the load statement or alias as something else, like

[SBU Head Name] as [Orig SBU Head Name],

If the load statement uses a LOAD * structure, you will need to expand the * to explicitly control the actual field names returned by the LOAD

[arvind_patil]

Hi Sidhharth,

Please try below Code:

IF(Isnull([SBU Head Name]) and isnull(CBU)),'Others') as [New Field];

Thanks,

Arvind Patil