Dimension Suppressing My Data

[Thejuan]

Example:

I have a sales fact table.
Some sales have a category such as "Discounted", "Staff Sale"

Some don't.

If i add a SalesCategory Dimension it removes the entries that don't?
How do I retain the uncategorized sales?

 

[johnherman]

Need to replace those nulls in the category with a value, such as "uncategorized".

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[Thejuan]

Surely there are other ways?
My main problem is the foreign key is stored in the dimension table.

So the fact table doesnt now that it is linked to.
I'd have to add unneccessary rows to the join table for all uncategorized rows in the fact table.

 

[johnherman]

You don't need to change it in the table, simply in a view or in a CASE state

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[Thejuan]

Ok Thanks.