obama's Economic Recovery.....Historical Reenactment Of The 1930s
The record of President Obama’s first three years in office is in, and nothing that happens now can go back and change that. What that record shows is that President Obama, with his throwback, old-fashioned, 1970s Keynesian economics, has put America

SET1/Q.2 a. Differentiate between sales quotas and sales territories.
Q.2 a. Differentiate between sales quotas and sales territories. b. Briefly explain the functions of logistics management.

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

Modeling Invoice Level Sales With a Volatile Sales Org
So I'm trying to model invoice level sales, and I'm struggling with the Rep/Territory portion of it. So here's some of the knowns - 1. Sales territories change from time to time 2. We have multiple businesses in our corporation who have different

Factless Sales table
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

Dimensional modelling for Sales and Marketing (opportunity, quotes, sales orders)
Hi all, My first post on this forum. I am in the process of designing a data mart for sales and marketing to analyse sales activity, opportunities, quotes and sales orders. Each sales activity is a record of a state transition e.g. Opportunity

BI solution for Sales data consolidation
Hi All Need help from DW/BI experts on this forum... I'm an IT Project Leader at a big organization based out of Singapore. We have multiple businesses and P&Ls across diverse industries like consumer goods, construction and healthcare. All of these

iPad 2 Sales Surpass the Ones of the First Apple Tablet, Major Sellout Occurs
As predicted by most analysts, the iPad 2 is becoming a hit real fast, selling out on the first days of availability. Piper Jaffray analysts have a report out, saying that Apple’s first weekend of sales improved the iPad performance from a year ago. To pu

Trying to design Sales to Promos to Sales Relationship help Please.
Hi, I'm struggling to solve seemingly simple thing. The tables we're getting now from outside Provider are 3 large tables: DimCustomers: CustomerID, CustonerName, etc. SalesFacts: CustomerID, PromoCode, SaleAmt, SaleDate, etc. DimPromos:

AccessPass Files Sales
Our AccessPass files sales forum has been created. This forum is invisible for now and will be visible only to AP users. To have access to this forum you must send a pm to our official imvu account (FilesSalesForum). Also make sure your AP badge is

Actual Vs Budget Amount in Sales DW
Hello All, I have DW for Sales. Currency the design is as follow: Dim Tables: 1. DimCustomer 2. DimProduct 3. DimDate Fact Table: 1. FactSales - Sales QTY Sales Amout etc. The granularity of this table is per product, per customer,

Adding forecasting to existing sales DW
I am adding forecasting to an existing sales DW: Existing Dimensions: Dim Date (typical date dimension attributes) Dim Customer (customer #, forecasting group, sales territory ) Dim Product (SKU, description, various product attributes) Existing

Designing a Fact for Sales DW
I'm designing a Sales Data Mart. I have SCD Type2 dimensions, and the main fact as Forecasted Revenue. My basic business requirement is as below: Considering 'Winning Probability%' in Opportunity Dimension as SCD Type 2, I will have to report

Stores With Zero Sales
hello, Item table: Item_key item_desc brand_code category _code category_desc item_number vendor_key -------------------------------------------- Date date_key cal_date month

What is the differences between sales promotion and advertising? What are their relative advantages and disadvantages?
What is the differences between sales promotion and advertising? What are their relative advantages and disadvantages?