Work around for supressing null values in a pivot table view

Refer to the link below. You cant really suppress nulls in the pivot view but a work around is posted in the link below:

http://bischool.wordpress.com/2010/08/10/obiee-cross-tab-with-missing-cells-data-in-database-or-suppressing-null-values-in-obiee-pivot/

Until Next Post... :)