Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-06-15 : 00:38:42
|
| 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. 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.I'll be gratefull for your help. Many thanks.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) ,) Thanks & Regards.-J |
|
|
|
|
|
|
|
Urgent - Problem due to Virtual Dimesions or??