Hello,

I am an OLAP newbie (about 6 hours now) and I created a simple sales cube.
The problem I am experiencing is with a ProductCategory dimension. I need
to be able to filter/sort based on the product category, however, some of
the products do not contain category codes (they are represented as null in
the product master table). This is causing my total sales aggregations to
be innaccurate (its not taking into account those products that were sold
but not in a category). Is there a way to have the dimension include NULL
joins or do I need to restructure the warehouse to handle NULLS as I am
pumping the data in. (for example, create a default category and any
product with a null would be assigned this default value).

Any help is greatly appreciated!

Brian

Creating "Unknown Category" is common technique to solve this kind of
problem. If your product dimension is snowflake, you can do it even without
change to the ETL process which populates data warehouse, by simply using
SQL expression over the column, which would test for NULL, and return
"Unknown Category" instead.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================