I created a case statement in the FACT table DSV that checked for "-1"

CASE CUST_ID WHEN '-1' THEN 1 ELSE 0 END AS Count_Other,

 CASE CUST_ID WHEN '-1' THEN 0...

I did set up the NULL processing on the Geo and Cust relation too.

I did alot of research last night and indeed your suggestion appears to be the one.

I also...

I take that back....i see dussledorf germany has 2 postal codes.

hmmmmmm

browse the geography dimension in adventure works datawarehouse.

wouldnt you expect to see multiple zip codes per city?

There is only one.

Hi Steve.....I am using SQL 2005.

Currently I can get a count of customers with the total number of lines (address lines)

IE:

1 - 5,000  (so there are 5,000 customers with...

If by level one you mean the top most level in the heirarcy then yes that is how it is set up.

Level 1 custid

Level 2 Line#

When i browse the heirarchy...

Thanks for your relpy.

No I am only using the customer address table as the dimension and the customer table as the fact table (measure count customer id)

The customer address table...