Sales facts vs sales goals & calls

Daniel at 17h55
29
Jun
2010
Sales facts vs sales goals & calls

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 a few wrinkles but they are not pertinent to my question.

I also have a sales goals table for all reps that is grained at the month, i.e. each sales rep has monthly go
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
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
Announcement No.(1569) The 1569 daily currency auction was held in the Central Bank of Iraq day Wednesday13-1-2010 so the results were as follows : Details Notes Number of banks 19 Auction price selling dinar / US $ 1170 Auction price
Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint
Rohan Naravane, Feb 25, 2011 1707 hrs IST A total of 4.5 million tablets were sold in the quarter ShareIn the third quarter of 2010, there were a total of 4.5 million tablets sold. From that, a humongous 93 percent share was captured by th
Forums from same category
See also
more_less
Informations

9 Replies For the topic :
"Sales facts vs sales goals & calls"

This topic has been viewed 1501 times.

Last message :
29/06/2010 at 17h55 by "Daniel"