excluding certain sales data by default

VHF at 00h19
18
Aug
2010
excluding certain sales data by default

We have a fairly straightfoward Kimball-method star-schema DW for reporting sales data. Mixed in with the regular sales data are facts for intercompany sales (from one wholly owned business entity to another.) Most of the time, users do not want to see intercompany data in their reports—only regular sales.

There is a CustomerType attribute in the customer dimension that indicates that a given customer is an intercompany customer
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi, I was wondering if there is anything wrong with having a factless sales table? Basically all I am required to do is to count up the total number of sales that occurred each month grouped by product type. So basically all I have in my fact table
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract,
Hi, We have the following case: For the product code in the source data, lookup the product natural key in the product dimension and assign the surrogate key returned by the lookup to the fact. If the lookup fails, assign the unknown product whose
I did a quick search of the forums and did not see this, but it seems a rather common scenario so I apologize if I am being redundant. I have a primary sales fact table that lists sales as line items from an order, pretty common arrangement. There are
I installed swype but there is no place to switch default keyboard in the settings using the custom roms. Has anyone been able to do that?
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"excluding certain sales data by default"

This topic has been viewed 2056 times.

Last message :
18/08/2010 at 00h19 by "VHF"