Drill down on null/missing dimension

[#1]

     Hi

I have a bar chart which shows one dimension member with a - which is where the data has not linked to the dimension table as it is missing in the dimension table.  Is there a way to:

1. Change the name of this to Unknown say - you can do this in a straight table using the presenation tab.

2. drill down on the - member.

Thanks

[#2]

Try using an IF statement in the LOAD statement in the script, e.g.:

LOAD

     ...,

     ...,

     if(IsNull(Dimension) OR Trim(Dimension)='', 'Unknown', Dimension) as Dimension,

     ...

FROM

     ....;