NULL in dimensions

Hi,

I have designed a dimension with following properties

Member Key = PID

Member Name = PID+'--'+Description

Now, If PID=1 and Description = NULL then it gives me Member Name as NULL whereas actually I am expecting 1--

Please let me know if there is anyway through which I can acheive it.

Also, I am using AS2000

Thanks,

Hi,

I got the solution

set member name as pid + '--'+ isnull(pdescription,'')