Hi.
I have created an Essbase dim build rule that, with one exception, updates the alias based on the value in the source file.
The exception is that when there is a prior value in the alias and a blank in the source file, the alias is not updated. In this case, the alias is not updated at all. The value remains in the alias instead of clearing it.
I have tried padding the field with a value and then doing a replace to remove it but I still am not able to clear the value in the alias.
Question 1 - Is this correct or expected behavior?
Question 2 - Can anyone suggest an approach to resolve this?
Thanks for your help.
Peter