I was wondering if there is a quick and easy way to ignore any member name that has a blank name? Currently I have a cube where I get (Blank) as the member name which has a value associated to it and I need to hide/delete these.
I didnt design the underlying fact and dimension tables so wanted to know if there is a quick way within SSAS/MDX to say something like "If member name is (Blank) then ignore.
Thanks in advance for you help.
View Complete Post