Removing Empty Values From Cube Data

Last Post 10 Jun 2004 02:35 AM by mmoney. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mmoney
New Member
New Member

--
09 Jun 2004 02:04 AM
Hello, I'm trying to extract cube data into an ADO recordset using MDX but it always returns many empty rows. I've wrapped each axis in NON EMPTY but the result still contains empty records. Is there any way I can prevent these from coming through?

Cheers

MMoney
yongliyang
New Member
New Member

--
09 Jun 2004 06:03 AM
Non Empty function only suppress those records where whole rows or columns are empty.
If you have lots of empty cell in the middle of the reports, non empty can do nothing about it.
mmoney
New Member
New Member

--
10 Jun 2004 02:35 AM
Thanks for your reply
You are not authorized to post a reply.

Acceptable Use Policy