Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447>
in
Copyright (c) 2007 <<Your Company Name here>>
Creates a blank report with no predefined content.
BIC_DataCube.BIC.x
integer
false
BIC_DataCube.BIC.y
integer
false
BIC_DataCube.Account.NewTabularHierarchy1.x
integer
false
BIC_DataCube.Account.NewTabularHierarchy1.y
integer
false
BIC_DataCube.BIC.width
integer
false
BIC_DataCube.BIC.height
integer
false
BIC_DataCube.Account.NewTabularHierarchy1.width
integer
false
BIC_DataCube.Account.NewTabularHierarchy1.height
integer
false
SaleOrder_DataCube.Account.x
integer
false
SaleOrder_DataCube.Account.y
integer
false
SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x
integer
false
SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y
integer
false
SaleOrder_DataCube.Account.width
integer
false
SaleOrder_DataCube.Account.height
integer
false
SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width
integer
false
SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height
integer
false
284
29
70
35
150
200
150
200
280
17
32
39
150
200
150
200
Blank Report
/templates/blank_report.gif
auto layout
static
string
true
simple
text-box
Unformatted
static
false
date
true
simple
text-box
Unformatted
static
false
date
true
simple
text-box
Unformatted
static
false
date
true
simple
text-box
Unformatted
static
false
integer
true
simple
text-box
Unformatted
static
false
integer
true
simple
text-box
Unformatted
static
false
integer
true
simple
text-box
Unformatted
1
Brand
string
2
Pod
string
3
Account
string
4
orderDateYearName
string
5
orderDateMonthOfYear
string
6
orderDateMonthName
string
7
orderDateWeekOfYear
string
8
countOrder
integer
9
quantity
integer
10
GS
integer
11
GMS
integer
12
GMP
integer
13
GSP
integer
14
GP
integer
Brand
Brand
Pod
Pod
Account
Account
orderDateYearName
orderDateYearName
orderDateMonthOfYear
orderDateMonthOfYear
orderDateMonthName
orderDateMonthName
orderDateWeekOfYear
orderDateWeekOfYear
countOrder
countOrder
quantity
quantity
GS
GS
GMS
GMS
GMP
GMP
GSP
GSP
GP
GP
1
Brand
string
2
Pod
string
3
Account
string
4
orderDateYearName
string
5
orderDateMonthOfYear
string
6
orderDateMonthName
string
7
orderDateWeekOfYear
string
8
countOrder
integer
9
quantity
integer
10
GS
integer
11
GMS
integer
12
GMP
integer
13
GSP
integer
14
GP
integer
OFbiz
= totalRows - 1) return false;
{
starschema = starschemas.get(currentRow);
orderDateDescription = starschema.getString("orderDateDescription");
orderDateDayName = starschema.getString("orderDateDayName");
orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
orderDateWeekOfYear = starschema.getString("orderDateWeekOfYear");
orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear");
brand = starschema.getString("brand");
pod = starschema.getString("pod");
account = starschema.getString("account");
quantity = starschema.getString("quantity");
countOrder = starschema.getString("countOrder");
GS = starschema.getString("GS");
GMS = starschema.getString("GMS");
GMP = starschema.getString("GMP");
GSP = starschema.getString("GSP");
GP = starschema.getString("GP");
row["Brand"] = brand;
row["Pod"] = pod;
row["Account"] = account;
row["orderDateYearName"] = orderDateYearName;
row["orderDateMonthOfYear"] = orderDateMonthOfYear;
row["orderDateMonthName"] = orderDateMonthName;
row["orderDateWeekOfYear"] = orderDateWeekOfYear;
row["countOrder"] = countOrder;
row["quantity"] = quantity;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
currentRow ++;
}
return true;]]>
NewTabularHierarchy
string
orderDateYearName
string
orderDateMonthOfYear
string
orderDateMonthName
string
orderDateWeekOfYear
NewTabularHierarchy1
string
Brand
string
Pod
string
Account
dataSetRow["countOrder"]
integer
dataSetRow["quantity"]
integer
dataSetRow["GS"]
integer
dataSetRow["GMS"]
integer
dataSetRow["GMP"]
integer
dataSetRow["GSP"]
integer
dataSetRow["GP"]
integer
BIC
custom
10in
20in
landscape
0.5in
0.5in
0.5in
0.5in
sans-serif
html
new Date()]]>
countOrder
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0
countOrder_Account/Account_Date/orderDateWeekOfYear
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0
countOrder_Account/Brand_Date/orderDateWeekOfYear
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0
countOrder_Account/Pod_Date/orderDateWeekOfYear
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0
countOrder_Date/orderDateWeekOfYear
sans-serif
small
bold
#ECE9D8
center
quantity
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0
quantity_Account/Account_Date/orderDateWeekOfYear
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0
quantity_Account/Brand_Date/orderDateWeekOfYear
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0
quantity_Account/Pod_Date/orderDateWeekOfYear
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0
quantity_Date/orderDateWeekOfYear
sans-serif
small
bold
#ECE9D8
center
GMP
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0
GMP_Account/Account_Date/orderDateWeekOfYear
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0
GMP_Account/Brand_Date/orderDateWeekOfYear
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0
GMP_Account/Pod_Date/orderDateWeekOfYear
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0
GMP_Date/orderDateWeekOfYear
sans-serif
small
bold
#ECE9D8
center
GSP
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0
GSP_Account/Account_Date/orderDateWeekOfYear
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0
GSP_Account/Brand_Date/orderDateWeekOfYear
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0
GSP_Account/Pod_Date/orderDateWeekOfYear
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0
GSP_Date/orderDateWeekOfYear
sans-serif
small
bold
#ECE9D8
center
GP
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0
GP_Account/Account_Date/orderDateWeekOfYear
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0
Brand_GP
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0
Pod_GP
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0
Grand_GP
sans-serif
small
bold
#ECE9D8
center
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Percent
#,##0%
GMP%
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Percent
#,##0%
Brand_GMP%
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Percent
#,##0%
Pod_GMP%
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Percent
#,##0%
Grand_GMP%
sans-serif
small
bold
#ECE9D8
center
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Percent
#,##0%
GP%
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Percent
#,##0%
Brand_GP%
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Percent
#,##0%
Pod_GP%
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Percent
#,##0%
Grand_GP%
sans-serif
small
bold
#ECE9D8
center
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0.0
AMP
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0.0
Brand_AMP
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0.0
Pod_AMP
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0.0
Grand_AMP
sans-serif
small
bold
#ECE9D8
center
Account/Account
Date/orderDateWeekOfYear
sans-serif
#FFEBCD
center
Fixed
#,##0.0
AGP
Account/Brand
Date/orderDateWeekOfYear
sans-serif
#87CEFA
center
Fixed
#,##0.0
Brand_AGP
Account/Pod
Date/orderDateWeekOfYear
sans-serif
#B0C4DE
center
Fixed
#,##0.0
Pod_AGP
Date/orderDateWeekOfYear
sans-serif
#6495ED
center
Fixed
#,##0.0
Grand_AGP
sans-serif
small
bold
#ECE9D8
center
sans-serif
#ECE9D8
Account
Account/Brand
Brand
sans-serif
small
bold
#ECE9D8
sans-serif
#ECE9D8
Account/Pod
Pod
sans-serif
small
bold
#ECE9D8
sans-serif
#ECE9D8
Account/Account
Account
sans-serif
small
bold
#F5F5DC
after
Date
Date/orderDateYearName
orderDateYearName
sans-serif
#FFEBCD
center
Date/orderDateMonthOfYear
orderDateMonthOfYear
#FFEBCD
center
Date/orderDateMonthName
orderDateMonthName
sans-serif
#FFEBCD
center
Date/orderDateWeekOfYear
data["orderDateWeekOfYear"]
asc
orderDateWeekOfYear
sans-serif
#ECE9D8
center
after
sans-serif
#FFFFFF
BIC_DataCube
quantity
measure["quantity"]
integer
SUM
GS
measure["GS"]
integer
SUM
GMS
measure["GMS"]
integer
SUM
GMP
measure["GMP"]
integer
SUM
GSP
measure["GSP"]
integer
SUM
GP
measure["GP"]
integer
SUM
orderDateYearName
dimension["Date"]["orderDateYearName"]
string
quantity_Date/orderDateYearName
measure["quantity"]
integer
Date/orderDateYearName
SUM
GS_Date/orderDateYearName
measure["GS"]
integer
Date/orderDateYearName
SUM
GMS_Date/orderDateYearName
measure["GMS"]
integer
Date/orderDateYearName
SUM
GMP_Date/orderDateYearName
measure["GMP"]
integer
Date/orderDateYearName
SUM
GSP_Date/orderDateYearName
measure["GSP"]
integer
Date/orderDateYearName
SUM
GP_Date/orderDateYearName
measure["GP"]
integer
Date/orderDateYearName
SUM
orderDateMonthName
dimension["Date"]["orderDateMonthName"]
string
quantity_Date/orderDateMonthName
measure["quantity"]
integer
Date/orderDateMonthName
SUM
GS_Date/orderDateMonthName
measure["GS"]
integer
Date/orderDateMonthName
SUM
GMS_Date/orderDateMonthName
measure["GMS"]
integer
Date/orderDateMonthName
SUM
GMP_Date/orderDateMonthName
measure["GMP"]
integer
Date/orderDateMonthName
SUM
GSP_Date/orderDateMonthName
measure["GSP"]
integer
Date/orderDateMonthName
SUM
GP_Date/orderDateMonthName
measure["GP"]
integer
Date/orderDateMonthName
SUM
orderDateWeekOfYear
dimension["Date"]["orderDateWeekOfYear"]
string
quantity_Date/orderDateWeekOfYear
measure["quantity"]
integer
Date/orderDateWeekOfYear
SUM
GS_Date/orderDateWeekOfYear
measure["GS"]
integer
Date/orderDateWeekOfYear
SUM
GMS_Date/orderDateWeekOfYear
measure["GMS"]
integer
Date/orderDateWeekOfYear
SUM
GMP_Date/orderDateWeekOfYear
measure["GMP"]
integer
Date/orderDateWeekOfYear
SUM
GSP_Date/orderDateWeekOfYear
measure["GSP"]
integer
Date/orderDateWeekOfYear
SUM
GP_Date/orderDateWeekOfYear
measure["GP"]
integer
Date/orderDateWeekOfYear
SUM
Brand
dimension["Account"]["Brand"]
string
quantity_Account/Brand_Date/orderDateWeekOfYear
measure["quantity"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
GS_Account/Brand_Date/orderDateWeekOfYear
measure["GS"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
GMS_Account/Brand_Date/orderDateWeekOfYear
measure["GMS"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
GMP_Account/Brand_Date/orderDateWeekOfYear
measure["GMP"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
GSP_Account/Brand_Date/orderDateWeekOfYear
measure["GSP"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
GP_Account/Brand_Date/orderDateWeekOfYear
measure["GP"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
Pod
dimension["Account"]["Pod"]
string
quantity_Account/Pod_Date/orderDateWeekOfYear
measure["quantity"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
GS_Account/Pod_Date/orderDateWeekOfYear
measure["GS"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
GMS_Account/Pod_Date/orderDateWeekOfYear
measure["GMS"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
GMP_Account/Pod_Date/orderDateWeekOfYear
measure["GMP"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
GSP_Account/Pod_Date/orderDateWeekOfYear
measure["GSP"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
GP_Account/Pod_Date/orderDateWeekOfYear
measure["GP"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
Account
dimension["Account"]["Account"]
string
quantity_Account/Account_Date/orderDateWeekOfYear
measure["quantity"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GS_Account/Account_Date/orderDateWeekOfYear
measure["GS"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GMS_Account/Account_Date/orderDateWeekOfYear
measure["GMS"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GMP_Account/Account_Date/orderDateWeekOfYear
measure["GMP"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GSP_Account/Account_Date/orderDateWeekOfYear
measure["GSP"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GP_Account/Account_Date/orderDateWeekOfYear
measure["GP"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
GMP%
if ((data["GMP_Account/Account_Date/orderDateWeekOfYear"] != null) && (data["GMS_Account/Account_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Account_Date/orderDateWeekOfYear"]/data["GMS_Account/Account_Date/orderDateWeekOfYear"]
}
decimal
GP%
if ((data["GP_Account/Account_Date/orderDateWeekOfYear"] != null) && (data["GS_Account/Account_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Account_Date/orderDateWeekOfYear"]/data["GS_Account/Account_Date/orderDateWeekOfYear"]
}
decimal
AMP
if ((data["GMP_Account/Account_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Account_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Account_Date/orderDateWeekOfYear"]/data["quantity_Account/Account_Date/orderDateWeekOfYear"]
}
float
AGP
if ((data["GP_Account/Account_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Account_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Account_Date/orderDateWeekOfYear"]/data["quantity_Account/Account_Date/orderDateWeekOfYear"]
}
float
Brand_TOTAL
dimension["Account"]["Brand"]+" TOTAL"
string
Pod_TOTAL
dimension["Account"]["Pod"]+" TOTAL"
string
Pod_GMP%
if ((data["GMP_Account/Pod_Date/orderDateWeekOfYear"] != null) && (data["GMS_Account/Pod_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Pod_Date/orderDateWeekOfYear"]/data["GMS_Account/Pod_Date/orderDateWeekOfYear"]
}
decimal
Brand_GMP%
if ((data["GMP_Account/Brand_Date/orderDateWeekOfYear"] != null) && (data["GMS_Account/Brand_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Brand_Date/orderDateWeekOfYear"]/data["GMS_Account/Brand_Date/orderDateWeekOfYear"]
}
decimal
Pod_GP%
if ((data["GP_Account/Pod_Date/orderDateWeekOfYear"] != null) && (data["GS_Account/Pod_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Pod_Date/orderDateWeekOfYear"]/data["GS_Account/Pod_Date/orderDateWeekOfYear"]
}
decimal
Brand_GP%
if ((data["GP_Account/Brand_Date/orderDateWeekOfYear"] != null) && (data["GS_Account/Brand_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Brand_Date/orderDateWeekOfYear"]/data["GS_Account/Brand_Date/orderDateWeekOfYear"]
}
decimal
Grand_GMP%
if ((data["GMP_Date/orderDateWeekOfYear"] != null) && (data["GMS_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Date/orderDateWeekOfYear"]/data["GMS_Date/orderDateWeekOfYear"]
}
decimal
Grand_GP%
if ((data["GP_Date/orderDateWeekOfYear"] != null) && (data["GS_Date/orderDateWeekOfYear"] != null))
{
data["GP_Date/orderDateWeekOfYear"]/data["GS_Date/orderDateWeekOfYear"]
}
decimal
Pod_AMP
if ((data["GMP_Account/Pod_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Pod_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Pod_Date/orderDateWeekOfYear"]/data["quantity_Account/Pod_Date/orderDateWeekOfYear"]
}
float
Brand_AMP
if ((data["GMP_Account/Brand_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Brand_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Account/Brand_Date/orderDateWeekOfYear"]/data["quantity_Account/Brand_Date/orderDateWeekOfYear"]
}
float
Grand_AMP
if ((data["GMP_Date/orderDateWeekOfYear"] != null) && (data["quantity_Date/orderDateWeekOfYear"] != null))
{
data["GMP_Date/orderDateWeekOfYear"]/data["quantity_Date/orderDateWeekOfYear"]
}
float
Pod_AGP
if ((data["GP_Account/Pod_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Pod_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Pod_Date/orderDateWeekOfYear"]/data["quantity_Account/Pod_Date/orderDateWeekOfYear"]
}
float
Brand_AGP
if ((data["GP_Account/Brand_Date/orderDateWeekOfYear"] != null) && (data["quantity_Account/Brand_Date/orderDateWeekOfYear"] != null))
{
data["GP_Account/Brand_Date/orderDateWeekOfYear"]/data["quantity_Account/Brand_Date/orderDateWeekOfYear"]
}
float
Grand_AGP
if ((data["GP_Date/orderDateWeekOfYear"] != null) && (data["quantity_Date/orderDateWeekOfYear"] != null))
{
data["GP_Date/orderDateWeekOfYear"]/data["quantity_Date/orderDateWeekOfYear"]
}
float
Account_GP
data["GMP_Account/Account_Date/orderDateWeekOfYear"]+data["GSP_Account/Account_Date/orderDateWeekOfYear"]
integer
Pod_GP
data["GMP_Account/Pod_Date/orderDateWeekOfYear"]+data["GSP_Account/Pod_Date/orderDateWeekOfYear"]
integer
Brand_GP
data["GMP_Account/Brand_Date/orderDateWeekOfYear"]+data["GSP_Account/Brand_Date/orderDateWeekOfYear"]
integer
Grand_GP
data["GMP_Date/orderDateWeekOfYear"]+data["GSP_Date/orderDateWeekOfYear"]
integer
countOrder_Account/Brand_Date/orderDateWeekOfYear
measure["countOrder"]
integer
Account/Brand
Date/orderDateWeekOfYear
SUM
countOrder_Account/Pod_Date/orderDateWeekOfYear
measure["countOrder"]
integer
Account/Pod
Date/orderDateWeekOfYear
SUM
countOrder_Date/orderDateWeekOfYear
measure["countOrder"]
integer
Date/orderDateWeekOfYear
SUM
countOrder_Account/Account_Date/orderDateWeekOfYear
measure["countOrder"]
integer
Account/Account
Date/orderDateWeekOfYear
SUM
orderDateMonthOfYear
dimension["Date"]["orderDateMonthOfYear"]
string