Change Accounting_Month to Activity_Month544 -- **ONLY** IN bi.analytics, NOT in bi.accounting

(done?) ADD MONTH NAME

Create new tables - with just red


Send an intro email 


Analytics_no_RED
Accounting_no_RED

Analytics
Accounting



----------
## RETHINK  'accounting_month' in bi.analytics

accounting_month is simply activity_month, but shifted for itunes. 
argg...  accounting_month should be called activity_month544

iTunesUSA ::   accounting_month :=  activity_month544
else      ::   accounting_month :=  activity_month544 + 1

--------------------


----------

make sure mgmt report is getting exported (GL_pt 6)

----------

## TODO:  Every two weeks, take a snapshot
## TODO:  Verify Validate for accounting

----------


(itunes_forecast) Revo> DT.missing_date
    download_accounting_month                   store_name accounting_days_present transac_typeid     units royaltydollar
 1:                2014-01-01 Cricket Communications, Inc.                      NA             NA       720         0.000
 2:                2014-01-01                       iTunes                      NA             NA        65       842.144
 3:                2014-02-01                       iTunes                      NA             30        -1        10.490
 4:                2014-02-01 Cricket Communications, Inc.                      NA             NA       756         0.000
 5:                2014-02-01              Microsoft X-Box                      NA             NA        NA         0.000
 6:                2014-03-01              Microsoft X-Box                      NA             NA        NA         0.000
 7:                2014-03-01 Cricket Communications, Inc.                      NA             NA       612         0.000
 8:                2014-04-01 Cricket Communications, Inc.                      NA             NA       609         0.000
 9:                2014-05-01 Cricket Communications, Inc.                      NA             NA       588         0.000
10:                2014-06-01 Amazon Digital Services Inc.                      NA             NA        NA         0.000
11:                2014-06-01 Cricket Communications, Inc.                      NA             NA       596         0.000
12:                2014-07-01 Cricket Communications, Inc.                      NA             NA       589         0.000
13:                2014-08-01 Cricket Communications, Inc.                      NA             NA       585         0.000
14:                2014-09-01 Cricket Communications, Inc.                      NA             NA       587         0.000
15:                2014-09-01                      YouTube                      NA             NA 863061033         0.000
16:                2014-10-01                      YouTube                      NA             NA 353370062         0.000
17:                2014-10-01 Cricket Communications, Inc.                      NA             NA       587         0.000
18:                2014-11-01                      YouTube                      NA             NA 652016921         0.000
19:                2014-11-01 Cricket Communications, Inc.                      NA             NA         1         0.000
(itunes_forecast) Revo> get_dim_
get_dim_.REFRESH_ALL_AND_SAVE  get_dim_country                get_dim_store                  get_dim_transac                get_dim_transacs               get_dim_x