Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080226-1155>
in
Copyright (c) 2007 <<Your Company Name here>>
Creates a blank report with no predefined content.
NBO Cube.NBO.x
integer
false
NBO Cube.NBO.y
integer
false
NBO Cube.Account.NewTabularHierarchy1.x
integer
false
NBO Cube.Account.NewTabularHierarchy1.y
integer
false
NBO Cube.NBO.width
integer
false
NBO Cube.NBO.height
integer
false
NBO Data Cube.NBO.x
integer
false
NBO Data Cube.NBO.y
integer
false
NBO Date Data Cube.NBO.x
integer
false
NBO Date Data Cube.NBO.y
integer
false
NBO Mouthly Data Cube.NBO_Monthly.x
integer
false
NBO Mouthly Data Cube.NBO_Monthly.y
integer
false
261
35
10
172
150
200
135
80
135
80
135
80
Blank Report
/templates/blank_report.gif
static
string
simple
false
text-box
true
Unformatted
static
string
simple
false
text-box
true
Unformatted
static
integer
simple
false
text-box
true
Unformatted
static
integer
simple
false
text-box
true
Unformatted
static
integer
simple
false
text-box
true
Unformatted
1
SalesChannel
string
2
orderDateMonthName
string
3
orderDateDateValue
string
4
Parcel
integer
5
GS
decimal
6
GMS
decimal
7
GMP
decimal
8
GSP
decimal
9
GP
decimal
10
eBay
decimal
11
eBay%
decimal
12
RRC
decimal
13
RRC%
decimal
14
Others
decimal
15
GP%
decimal
16
GMP%
decimal
17
NBO
decimal
18
Monthly Projection
decimal
19
Monthly Forecast
decimal
20
Daily
integer
21
Pod
string
22
Account
string
23
Date
string
24
Month
string
25
MonthName
string
26
Today
string
SalesChannel
SalesChannel
orderDateMonthName
orderDateMonthName
orderDateDateValue
orderDateDateValue
Parcel
Parcel
GS
GS
GMS
GMS
GMP
GMP
GSP
GSP
GP
GP
eBay
eBay
eBay%
eBay%
RRC
RRC
RRC%
RRC%
Others
Others
GP%
GP%
GMP%
GMP%
NBO
NBO
Daily
Daily
Monthly Projection
Monthly Projection
Monthly Forecast
Monthly Forecast
Pod
Pod
Account
Account
Date
Date
Month
Month
MonthName
MonthName
Today
Today
1
SalesChannel
string
2
orderDateMonthName
string
3
orderDateDateValue
string
4
Parcel
integer
5
GS
decimal
6
GMS
decimal
7
GMP
decimal
8
GSP
decimal
9
GP
decimal
10
eBay
decimal
11
eBay%
decimal
12
RRC
decimal
13
RRC%
decimal
14
Others
decimal
15
GP%
decimal
16
GMP%
decimal
17
NBO
decimal
18
Monthly Projection
decimal
19
Monthly Forecast
decimal
20
Daily
integer
21
Pod
string
22
Account
string
23
Date
string
24
Month
string
25
MonthName
string
26
Today
string
OFbiz
= totalRows) return false;
{
starschema = starschemas.get(currentRow);
orderDateDateValue = starschema.getString("orderDateDateValue");
orderDateDayName = starschema.getString("orderDateDayName");
orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear");
orderDateDescription = starschema.getString("orderDateDescription");
quantity = starschema.getString("quantity");
GS = starschema.getString("GrossSales");
GMS = starschema.getString("GrossMerchandizeSales");
GMP = starschema.getString("GrossMerchandizeProfit");
GSP = starschema.getString("GrossShippingProfit");
GP = starschema.getString("GrossProfit");
eBay = starschema.getString("eBay");
RRC = starschema.getString("RRC");
Others = starschema.getString("OtherFree");
NBO = starschema.getString("NBO");
salesChannelEnumId = starschema.getString("salesChannelEnumId");
if (orderDateMonthOfYear == DateMonth)
{
row["Daily"] = 1;
}
else
{
row["Daily"] = 2;
}
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["Date"] = orderDateYearMonthDay;
row["Month"] = orderDateMonthOfYear;
row["MonthName"] = orderDateMonthName;
row["Today"] = DateDay;
}
currentRow ++;
}
return true;]]>
1
SalesChannel
string
2
orderDateDayOfMonth
string
3
orderDateMonthName
string
4
orderDateYearName
string
5
orderDateDateValue
string
6
Parcel
integer
7
GS
decimal
8
GMS
decimal
9
GMP
decimal
10
GSP
decimal
11
GP
decimal
12
eBay
decimal
13
eBay%
decimal
14
RRC
decimal
15
RRC%
decimal
16
Others
decimal
17
GP%
decimal
18
GMP%
decimal
19
NBO
decimal
20
Pod
string
21
Account
string
22
Date
string
SalesChannel
SalesChannel
orderDateDayOfMonth
orderDateDayOfMonth
orderDateMonthName
orderDateMonthName
orderDateYearName
orderDateYearName
orderDateDateValue
orderDateDateValue
Parcel
Parcel
GS
GS
GMS
GMS
GMP
GMP
GSP
GSP
eBay
eBay
RRC
RRC
Others
Others
Pod
Pod
Account
Account
Date
Date
NBO
NBO
eBay%
eBay%
RRC%
RRC%
GP%
GP%
GMP%
GMP%
GP
GP
1
SalesChannel
string
2
orderDateDayOfMonth
string
3
orderDateMonthName
string
4
orderDateYearName
string
5
orderDateDateValue
string
6
Parcel
integer
7
GS
decimal
8
GMS
decimal
9
GMP
decimal
10
GSP
decimal
11
GP
decimal
12
eBay
decimal
13
eBay%
decimal
14
RRC
decimal
15
RRC%
decimal
16
Others
decimal
17
GP%
decimal
18
GMP%
decimal
19
NBO
decimal
20
Pod
string
21
Account
string
22
Date
string
OFbiz
= totalRows) return false;
{
Date_starschema = Date_starschemas.get(currentRow);
orderDateDateValue = Date_starschema.getString("orderDateDateValue");
orderDateDayName = Date_starschema.getString("orderDateDayName");
orderDateDayOfMonth = Date_starschema.getString("orderDateDayOfMonth");
orderDateMonthName = Date_starschema.getString("orderDateMonthName");
orderDateYearName = Date_starschema.getString("orderDateYearName");
orderDateYearMonthDay = Date_starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = Date_starschema.getString("orderDateMonthOfYear");
orderDateDescription = Date_starschema.getString("orderDateDescription");
quantity = Date_starschema.getString("quantity");
GS = Date_starschema.getString("GrossSales");
GMS = Date_starschema.getString("GrossMerchandizeSales");
GMP = Date_starschema.getString("GrossMerchandizeProfit");
GSP = Date_starschema.getString("GrossShippingProfit");
GP = Date_starschema.getString("GrossProfit");
eBay = Date_starschema.getString("eBay");
RRC = Date_starschema.getString("RRC");
Others = Date_starschema.getString("OtherFree");
NBO = Date_starschema.getString("NBO");
salesChannelEnumId = Date_starschema.getString("salesChannelEnumId");
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["Date"] = orderDateYearMonthDay;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateDayOfMonth"] = orderDateDayOfMonth;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateYearName"] = orderDateYearName;
row["orderDateDateValue"] = orderDateDateValue;
row["Parcel"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
row["eBay"] = eBay;
row["RRC"] = RRC;
row["Others"] = Others;
row["NBO"] = NBO;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["Date"] = orderDateYearMonthDay;
}
currentRow ++;
}
return true;]]>
1
SalesChannel
string
2
orderDateMonthName
string
3
Pod
string
4
Account
string
5
NBO
decimal
6
CountDate
integer
7
Monthly Forecast
decimal
SalesChannel
SalesChannel
orderDateMonthName
orderDateMonthName
Pod
Pod
Account
Account
NBO
NBO
CountDate
CountDate
Monthly Forecast
Monthly Forecast
1
SalesChannel
string
2
orderDateMonthName
string
3
Pod
string
4
Account
string
5
NBO
decimal
6
CountDate
integer
7
Monthly Forecast
decimal
OFbiz
= totalRows) return false;
{
starschema = starschemas.get(currentRow);
salesChannelEnumId = starschema.getString("salesChannelEnumId");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
NBO = starschema.getString("NBO");
CountDate = starschema.getString("CountDate");
if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_AU;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_CA;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_IE;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_SG;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_UK;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_US_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod1;
row["Account"] = account_B2C_US;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_DE;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_ES;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_FR;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL")
{
row["SalesChannel"] = salesChannelEnumId;
row["orderDateMonthName"] = orderDateMonthName;
row["Pod"] = pod2;
row["Account"] = account_B2C_IT;
row["NBO"] = NBO;
row["CountDate"] = CountDate;
}
currentRow ++;
}
return true;]]>
NBO Summary Field
false
NewTabularHierarchy
string
Today
NewTabularHierarchy1
string
Pod
string
Account
integer
dynamic
orderDateMonthName
string
Daily
average
dataSetRow["Parcel"]
integer
average
dataSetRow["GS"]
decimal
average
dataSetRow["GMP"]
decimal
average
false
dataSetRow["GSP"]
decimal
average
dataSetRow["GP"]
decimal
average
dataSetRow["eBay"]
decimal
average
(dataSetRow["eBay"]/dataSetRow["GP"])
decimal
average
dataSetRow["RRC"]
decimal
average
false
(dataSetRow["RRC"]/dataSetRow["GP"])
decimal
average
false
dataSetRow["Others"]
decimal
average
(dataSetRow["GP"]/dataSetRow["GS"])
decimal
average
(dataSetRow["GMP"]/dataSetRow["GMS"])
decimal
average
dataSetRow["NBO"]
decimal
NBO_Month
NBO_Today Summary Field
NewTabularHierarchy2
string
orderDateDateValue
NewTabularHierarchy3
string
Pod
string
Account
string
Date
dataSetRow["Parcel"]
integer
dataSetRow["GS"]
decimal
dataSetRow["GMP"]
decimal
dataSetRow["GSP"]
decimal
dataSetRow["GP"]
decimal
dataSetRow["eBay"]
decimal
(dataSetRow["eBay"]/dataSetRow["GP"])
decimal
dataSetRow["RRC"]
decimal
(dataSetRow["RRC"]/dataSetRow["GP"])
decimal
dataSetRow["Others"]
decimal
(dataSetRow["GP"]/dataSetRow["GS"])
decimal
(dataSetRow["GMP"]/dataSetRow["GMS"])
decimal
dataSetRow["NBO"]
decimal
NBO_Date
NBO MonthlySummary Field
NewTabularHierarchy6
string
orderDateMonthName
NewTabularHierarchy7
string
Pod
string
Account
sum
dataSetRow["NBO"]
decimal
(dataSetRow["NBO"]/dataSetRow["CountDate"])*params["NunberDate"]
decimal
dataSetRow["Monthly Forecast"]
decimal
NBO_Monthly
landscape
0.25in
0.25in
0.25in
0.25in
html
new Date()]]>
0
Parcel1
Parcel1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Parcel1_Date_Today/orderDateDateValue
#FFFF00
GS1
Currency
$###0
GS1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
GS1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
GS1_Date_Today/orderDateDateValue
#FFFF00
GMP1
Currency
$###0
GMP1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
GMP1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
GMP1_Date_Today/orderDateDateValue
#FFFF00
GSP1
Currency
$###0
GSP1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
GSP1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
GSP1_Date_Today/orderDateDateValue
#FFFF00
GP1
Currency
$###0
GP1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
GP1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
GP1_Date_Today/orderDateDateValue
#FFFF00
eBay1
Currency
$###0
eBay1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
eBay1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
eBay1_Date_Today/orderDateDateValue
#FFFF00
eBay%1
Percent
###0%
eBay%1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Percent
###0%
eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Percent
###0%
eBay%1_Date_Today/orderDateDateValue
#FFFF00
RRC1
Currency
$###0
RRC1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
RRC1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
RRC1_Date_Today/orderDateDateValue
#FFFF00
RRC%1
Percent
###0.0%
RRC%1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Percent
###0.0%
RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Percent
###0.0%
RRC%1_Date_Today/orderDateDateValue
#FFFF00
Others1
Currency
$###0
Others1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
Others1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
Others1_Date_Today/orderDateDateValue
#FFFF00
GP%1
Percent
###0.0%
GP%1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Percent
###0.0%
GP%1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Percent
###0.0%
GP%1_Date_Today/orderDateDateValue
#FFFF00
GMP%1
Percent
###0.0%
GMP%1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Percent
###0.0%
GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Percent
###0.0%
GMP%1_Date_Today/orderDateDateValue
#FFFF00
NBO1
Currency
$###0
NBO1
Account_Today/Pod
Date_Today/orderDateDateValue
#E5E5E5
Currency
$###0
NBO1_Account_Today/Pod_Date_Today/orderDateDateValue
Date_Today/orderDateDateValue
#BFBFBF
Currency
$###0
NBO1_Date_Today/orderDateDateValue
#FFFF00
#BFBFBF
Account_Today
Account_Today/Pod
center
Pod
#FFFF00
middle
#E5E5E5
Account_Today/Account
center
Account
#FFFF00
middle
Account_Today/Date
center
Date
#FFFF00
middle
Date_Today
Date_Today/orderDateDateValue
center
orderDateDateValue
#FFFF00
NBO Date Data Cube
Pod
dimension["Account_Today"]["Pod"]
string
orderDateDateValue
dimension["Date_Today"]["orderDateDateValue"]
string
Parcel1
measure["Parcel1"]
integer
Account
dimension["Account_Today"]["Account"]
string
Date
"Today"
string
GS1
measure["GS1"]
decimal
GMP1
measure["GMP1"]
decimal
GSP1
measure["GSP1"]
decimal
GP1
measure["GP1"]
decimal
eBay1
measure["eBay1"]
decimal
eBay%1
measure["eBay%1"]
decimal
RRC1
measure["RRC1"]
decimal
RRC%1
measure["RRC%1"]
decimal
Others1
measure["Others1"]
decimal
GP%1
measure["GP%1"]
decimal
GMP%1
measure["GMP%1"]
decimal
NBO1
measure["NBO1"]
decimal
Parcel1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["Parcel1"]
integer
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GS1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GS1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GMP1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GMP1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GSP1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GSP1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GP1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GP1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
eBay1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["eBay1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
eBay%1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["eBay%1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
RRC1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["RRC1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
RRC%1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["RRC%1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
Others1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["Others1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GP%1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GP%1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
GMP%1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["GMP%1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
NBO1_Account_Today/Pod_Date_Today/orderDateDateValue
measure["NBO1"]
decimal
Account_Today/Pod
Date_Today/orderDateDateValue
sum
Parcel1_Date_Today/orderDateDateValue
measure["Parcel1"]
integer
Date_Today/orderDateDateValue
sum
GS1_Date_Today/orderDateDateValue
measure["GS1"]
decimal
Date_Today/orderDateDateValue
sum
GMP1_Date_Today/orderDateDateValue
measure["GMP1"]
decimal
Date_Today/orderDateDateValue
sum
GSP1_Date_Today/orderDateDateValue
measure["GSP1"]
decimal
Date_Today/orderDateDateValue
sum
GP1_Date_Today/orderDateDateValue
measure["GP1"]
decimal
Date_Today/orderDateDateValue
sum
eBay1_Date_Today/orderDateDateValue
measure["eBay1"]
decimal
Date_Today/orderDateDateValue
sum
eBay%1_Date_Today/orderDateDateValue
measure["eBay%1"]
decimal
Date_Today/orderDateDateValue
sum
RRC1_Date_Today/orderDateDateValue
measure["RRC1"]
decimal
Date_Today/orderDateDateValue
sum
RRC%1_Date_Today/orderDateDateValue
measure["RRC%1"]
decimal
Date_Today/orderDateDateValue
sum
Others1_Date_Today/orderDateDateValue
measure["Others1"]
decimal
Date_Today/orderDateDateValue
sum
GP%1_Date_Today/orderDateDateValue
measure["GP%1"]
decimal
Date_Today/orderDateDateValue
sum
GMP%1_Date_Today/orderDateDateValue
measure["GMP%1"]
decimal
Date_Today/orderDateDateValue
sum
NBO1_Date_Today/orderDateDateValue
measure["NBO1"]
decimal
Date_Today/orderDateDateValue
sum
0
Parcel
Parcel
Account/Pod
Date/Today
#E5E5E5
Parcel_Account/Pod_Date/Today_1
Parcel_lastmonth
Date/Today
#BFBFBF
Parcel_Date/Today
Parcel_total_lastmonth
#1E90FF
GS
Currency
$###0
GS
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
GS_Account/Pod_Date/Today
Currency
$###0
GS_lastmonth
Date/Today
#BFBFBF
Currency
$###0
GS_Date/Today
Currency
$###0
GS_total_lastmonth
#1E90FF
GMP
Currency
$###0
GMP
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
GMP_Account/Pod_Date/Today
Currency
$###0
GMP_lastmonth
Date/Today
#BFBFBF
Currency
$###0
GMP_Date/Today
Currency
$###0
GMO_total_lastmonth
#1E90FF
GSP
Currency
$###0
GSP
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
GSP_Account/Pod_Date/Today
Currency
$###0
GSP_lastmonth
Date/Today
#BFBFBF
Currency
$###0
GSP_Date/Today
Currency
$###0
GSP_taotal_lastmonth
#1E90FF
GP
Currency
$###0
GP
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
GP_Account/Pod_Date/Today
Currency
$###0
GP_lastmonth
Date/Today
#BFBFBF
Currency
$###0
GP_Date/Today
Currency
$###0
GP_total_lastmonth
#1E90FF
eBay
Currency
$###0
eBay
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
eBay_Account/Pod_Date/Today
Currency
$###0
eBay_lastmonth
Date/Today
#BFBFBF
Currency
$###0
eBay_Date/Today
Currency
$###0
ebay_total_lastmonth
#1E90FF
eBay%
Percent
###0%
eBay%
Account/Pod
Date/Today
#E5E5E5
Percent
###0%
eBay%_Account/Pod_Date/Today
Percent
###0%
eBay%_lastmonth
Date/Today
#BFBFBF
Percent
###0%
eBay%_Date/Today
Percent
###0%
eBay%_total_lastmonth
#1E90FF
RRC
Currency
$###0
RRC
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
RRC_Account/Pod_Date/Today
Currency
$###0
RRC_lastmonth
Date/Today
#BFBFBF
Currency
$###0
RRC_Date/Today
Currency
$###0
RRC_total_lastmonth
#1E90FF
RRC%
Percent
###0.0%
RRC%
Account/Pod
Date/Today
#E5E5E5
Percent
###0%
RRC%_Account/Pod_Date/Today
Percent
###0%
RRC%_lastmonth
Date/Today
#BFBFBF
Percent
###0%
RRC%_Date/Today
Percent
###0%
RRC%_total_lastmonth
#1E90FF
Others
Currency
$###0
Others
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
Others_Account/Pod_Date/Today
Currency
$###0
Others_lastmonth
Date/Today
#BFBFBF
Currency
$###0
Others_Date/Today
Currency
$###0
Others_total_lastmonth
#1E90FF
GP%
Percent
###0.0%
GP%
Account/Pod
Date/Today
#E5E5E5
Percent
###0%
GP%_Account/Pod_Date/Today
Percent
###0%
GP%_lastmonth
Date/Today
#BFBFBF
Percent
###0.0%
GP%_Date/Today
Percent
###0.0%
GP%_total_lastmonth
#1E90FF
GMP%
Percent
###0.0%
GMP%
Account/Pod
Date/Today
#E5E5E5
Percent
###0.0%
GMP%_Account/Pod_Date/Today
Percent
###0.0%
GMP%_lastmonth
Date/Today
#BFBFBF
Percent
###0.0%
GMP%_Date/Today
Percent
###0.0%
GMP%_total_lastmonth
#1E90FF
NBO
Currency
$###0
NBO
Account/Pod
Date/Today
#E5E5E5
Currency
$###0
NBO_Account/Pod_Date/Today
Currency
$###0
NBO_lastmonth
Date/Today
#BFBFBF
Currency
$###0
NBO_Date/Today
Currency
$###0
NBO_total_lastmonth
#1E90FF
#BFBFBF
Account
Account/Pod
0pt
1pt
center
auto
Pod
#1E90FF
middle
eq
data["Pod"]
English
#FFFF00
#E5E5E5
Account/Account
0pt
1pt
center
Account
#1E90FF
middle
Account/Daily
center
Show_Daily
#1E90FF
67px
Date
Date/Today
center
Today
#1E90FF
NBO Month Data Cube
Pod
dimension["Account"]["Pod"]
string
Parcel
measure["Parcel"]
integer
GS
measure["GS"]
decimal
GMP
measure["GMP"]
decimal
GSP
measure["GSP"]
decimal
GP
measure["GP"]
decimal
eBay
measure["eBay"]
decimal
eBay%
measure["eBay%"]
decimal
RRC
measure["RRC"]
decimal
RRC%
measure["RRC%"]
decimal
Others
measure["Others"]
decimal
GP%
measure["GP%"]
decimal
GMP%
measure["GMP%"]
decimal
NBO
measure["NBO"]
decimal
Account
dimension["Account"]["Account"]
string
Daily
dimension["Account"]["Daily"]
integer
Today
"Average this month and last month"
string
Show_Daily
if(dimension["Account"]["Daily"]==1)
{
"Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3)
}
else if(dimension["Account"]["Daily"]==2)
{
"Daily Avg in "+dimension["Account"]["Daily"]["orderDateMonthName"].substring(0,3)
}
string
Parcel_Account/Pod_Date/Today
measure["Parcel"]
integer
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
GS_Account/Pod_Date/Today
measure["GS"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
GMP_Account/Pod_Date/Today
measure["GMP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
GSP_Account/Pod_Date/Today
measure["GSP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
GP_Account/Pod_Date/Today
measure["GP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
eBay_Account/Pod_Date/Today
measure["eBay"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
eBay%_Account/Pod_Date/Today
measure["eBay%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==1
RRC_Account/Pod_Date/Today
measure["RRC"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
RRC%_Account/Pod_Date/Today
measure["RRC%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==1
Others_Account/Pod_Date/Today
measure["Others"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
GP%_Account/Pod_Date/Today
measure["GP%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==1
GMP%_Account/Pod_Date/Today
measure["GMP%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==1
NBO_Account/Pod_Date/Today
measure["NBO"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
Parcel_Date/Today
measure["Parcel"]
integer
Date/Today
SUM
dimension["Account"]["Daily"]==1
GS_Date/Today
measure["GS"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
GMP_Date/Today
measure["GMP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
GSP_Date/Today
measure["GSP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
GP_Date/Today
measure["GP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
eBay_Date/Today
measure["eBay"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
eBay%_Date/Today
measure["eBay%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==1
RRC_Date/Today
measure["RRC"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
RRC%_Date/Today
measure["RRC%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==1
Others_Date/Today
measure["Others"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
GP%_Date/Today
measure["GP%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==1
GMP%_Date/Today
measure["GMP%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==1
NBO_Date/Today
measure["NBO"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==1
Parcel_Account/Pod_Date/Today_1
measure["Parcel"]
integer
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==1
Parcel_lastmonth
measure["Parcel"]
integer
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
GS_lastmonth
measure["GS"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
GMP_lastmonth
measure["GMP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
GSP_lastmonth
measure["GSP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
GP_lastmonth
measure["GP"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
eBay_lastmonth
measure["eBay"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
eBay%_lastmonth
measure["eBay%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==2
RRC_lastmonth
measure["RRC"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
RRC%_lastmonth
measure["RRC%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==2
Others_lastmonth
measure["Others"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
GP%_lastmonth
measure["GP%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==2
GMP%_lastmonth
measure["GMP%"]
decimal
Account/Pod
Date/Today
AVE
dimension["Account"]["Daily"]==2
NBO_lastmonth
measure["NBO"]
decimal
Account/Pod
Date/Today
SUM
dimension["Account"]["Daily"]==2
Parcel_total_lastmonth
measure["Parcel"]
integer
Date/Today
SUM
dimension["Account"]["Daily"]==2
GS_total_lastmonth
measure["GS"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
GMO_total_lastmonth
measure["GMP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
GSP_taotal_lastmonth
measure["GSP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
GP_total_lastmonth
measure["GP"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
ebay_total_lastmonth
measure["eBay"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
eBay%_total_lastmonth
measure["eBay%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==2
RRC_total_lastmonth
measure["RRC"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
RRC%_total_lastmonth
measure["RRC%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==2
Others_total_lastmonth
measure["Others"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
GP%_total_lastmonth
measure["GP%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==2
GMP%_total_lastmonth
measure["GMP%"]
decimal
Date/Today
AVE
dimension["Account"]["Daily"]==2
NBO_total_lastmonth
measure["NBO"]
decimal
Date/Today
SUM
dimension["Account"]["Daily"]==2
0
NBO Monthly
Currency
$###0
NBO Monthly
Accounts/Pod
Monthly/orderDateMonthName
#E5E5E5
Currency
$###0
NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName
Monthly/orderDateMonthName
#BFBFBF
Currency
$###0
NBO Monthly_Monthly/orderDateMonthName
#A52A2A
Monthly Projection
Currency
$###0
Monthly Projection
Accounts/Pod
Monthly/orderDateMonthName
#E5E5E5
Currency
$###0
Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName
Monthly/orderDateMonthName
#BFBFBF
Currency
$###0
Monthly Projection_Monthly/orderDateMonthName
#A52A2A
Monthly Forecast
Currency
$###0
Monthly Forecast
Accounts/Pod
Monthly/orderDateMonthName
#E5E5E5
Currency
$###0
Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName
Monthly/orderDateMonthName
#BFBFBF
Currency
$###0
Monthly Forecast_Monthly/orderDateMonthName
#A52A2A
#BFBFBF
Accounts
Accounts/Pod
center
Pod
#A52A2A
#E5E5E5
Accounts/Account
center
Account
#A52A2A
Monthly
Monthly/orderDateMonthName
center
orderDateMonthName
#A52A2A
NBO Mouthly Data Cube
orderDateMonthName
dimension["Monthly"]["orderDateMonthName"]
string
Pod
dimension["Accounts"]["Pod"]
string
NBO Monthly
measure["NBO Monthly"]
decimal
Monthly Projection
measure["Monthly Projection"]
decimal
Monthly Forecast
measure["Monthly Forecast"]
integer
Account
dimension["Accounts"]["Account"]
string
NBO Monthly_Accounts/Pod_Monthly/orderDateMonthName
measure["NBO Monthly"]
decimal
Accounts/Pod
Monthly/orderDateMonthName
sum
Monthly Projection_Accounts/Pod_Monthly/orderDateMonthName
measure["Monthly Projection"]
integer
Accounts/Pod
Monthly/orderDateMonthName
sum
Monthly Forecast_Accounts/Pod_Monthly/orderDateMonthName
measure["Monthly Forecast"]
integer
Accounts/Pod
Monthly/orderDateMonthName
sum
NBO Monthly_Monthly/orderDateMonthName
measure["NBO Monthly"]
decimal
Monthly/orderDateMonthName
sum
Monthly Projection_Monthly/orderDateMonthName
measure["Monthly Projection"]
integer
Monthly/orderDateMonthName
sum
Monthly Forecast_Monthly/orderDateMonthName
measure["Monthly Forecast"]
integer
Monthly/orderDateMonthName
sum