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 |
|
kri
Starting Member
1 Post |
 Posted - 2004-10-11 : 21:18:22
|
| Say I have a fact table with two columns "MarketId" and "Sales" and a separate dimension table for "MarketId".Valid values for "MarketId" dimension are 1,2 and -255(unknown market).Fact table contains five rows 1 10002 20000 1000NULL 10001 1000.Is there a way during cube processing, the values 0 and NULL in fact table can be grouped under -255 (unknown market)?Thanks |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-10-11 : 21:38:20
|
You could build your input query to use the Case logic or IsNull function to replace values that are null with -255.I don't know that much about Cube process but it would be simple to base it on a Select statement that took care of that for you. |
 |
|
|
|
|
|
Cube Processing -- grouping NULL & Invalid values