Im very new to this!
I have a situation similar to this example
My Fact table is an OrderItem table
ItemId, OrderId, ItemSoldFor
I have a dimension that is OrderType
OrderId, Type
The dimension is obviously for a group of Items (ie an Order)
When i do this the aggregration of sales is...
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.
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?
Sorry if this is already covered.. search is down.
I want to create a Dimension that is Based on an emailaddress field.
But i want it to be a heirachy starting with the domain.
So all emailaddresses with the same name are grouped under their domain.
I can see any string functionality in the...
Hi,
I was wondering how easy or if its possible to forward all mail to a particular domain ie @domain.com to an external program?
I essentially want all user names to be accepted for this domain. Then let an external app process them.
how do i make a back up copy of my original win98 second edition to work as a bootable CD??
the last time a make a back up of the Cd it doesnt work as one, with out the selection of either from 1. with CD support 2. Install
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.