NULL in Dimensions

[SP1709]

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,

 

[SP1709]

Hi,



I got the solution

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