Urgent - Problem Due To Virtual Dimesions Or??

Hi,

I am using dimensions: Product, Customer, Customer Geogrpahy (This is a virtual Dimension).The DDLs are posted below in case they might help....

The problem that I am running into is that when I see the "ALL" Sales or Zone Level sales, I get the correct results. However, when I go to State or County level, I get different results. This is driving me nutes and have already spend good 48 hours at least but am unable to solve this :(


1) Could this problem be caused due to use of Virtual Dimensions?

2) Is it better to use SnowFlake Schema based dimension instead? ( Though these are not shown in the DDLs but I also have the fields for ZoneCode, StateCode, CountyCode, & CityCode and can link them with my Geography table/dimesion --- If that's what it will take to solve the problem)

3) Some where in the Wizard steps, there is an option for "Uniqueness". Exactly what is this option and can this solve my problem.

DDLs:-------

CREATE TABLE [tblCustomers] (
[CustCode] [varchar] (20) ,
[CustName] [varchar] (64),
[CustZone] [char] (10),
[CustState] [varchar] (64),
[CustCounty] [varchar] (64),
[CustCity] [varchar] (64),
)


CREATE TABLE [tblSalesFACT] (
[SaleDate] datetime,
[CustCode] varchar (20),
[ProdCode] varchar (20),
[SaleAmount] DECIMAL (12,2),
[ProdQty] INTEGER
)


CREATE TABLE [tblProducts] (
[ProdCode] [varchar] (20),
[ProdName] [varchar] (50) ,
[ProdFamily] [varchar] (20) ,
)
I'll be gratefull for your help. Many thanks.