Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447>
in
/templates/blank_report.gif
ltr
1
orderId
string
2
orderItemSeqId
string
3
orderStatus
string
4
saleChannel
string
5
quantity
string
6
extGrossAmount
string
7
orderDateDayOfMonth
string
8
orderDateMonthOfYear
string
9
orderDateYearName
string
10
price
string
11
stock
string
12
productId
string
13
internalName
string
orderId
orderItemSeqId
orderStatus
saleChannel
quantity
extGrossAmount
orderDateDayOfMonth
orderDateMonthOfYear
orderDateYearName
price
stock
productId
internalName
1
orderId
string
2
orderItemSeqId
string
3
orderStatus
string
4
saleChannel
string
5
quantity
string
6
extGrossAmount
string
7
orderDateDayOfMonth
string
8
orderDateMonthOfYear
string
9
orderDateYearName
string
10
price
string
11
stock
string
12
productId
string
13
internalName
string
OFBIZ
NewTabularHierarchy
string
productId
string
internalName
string
price
string
stock
string
orderDateMonthOfYear
count
dataSetRow["orderItemSeqId"]
integer
sum
dataSetRow["quantity"]
float
sum
dataSetRow["extGrossAmount"]
float
SalesOrderItemStarSchema
html
new Date()]]>
larger
bold
center
auto
orderItemSeqId
Group/orderDateMonthOfYear
orderItemSeqId_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
orderItemSeqId_Group/productId
orderItemSeqId
0.32222222222222224in
quantity
Group/orderDateMonthOfYear
quantity_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
quantity_Group/productId
quantity
extGrossAmount
Group/orderDateMonthOfYear
extGrossAmount_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
extGrossAmount_Group/productId
extGrossAmount
Group
Group/productId
productId
0.8777777777777778in
bold
right
productId_TOTAL
Group/internalName
internalName
2.3222222222222224in
Group/price
price
0.5666666666666667in
Group/stock
stock
0.6in
Group/orderDateMonthOfYear
orderDateMonthOfYear
0.5666666666666667in
after
4.844444444444444in
0.8333333333333334in
2.2888888888888888in
0.6in
0.5888888888888889in
0.5444444444444444in
bold
auto
|
bold
auto
|
bold
auto
|
bold
auto
|
bold
auto
|
DataCube
productId
dimension["Group"]["productId"]
string
internalName
dimension["Group"]["internalName"]
string
price
dimension["Group"]["price"]
string
stock
dimension["Group"]["stock"]
string
orderDateMonthOfYear
dimension["Group"]["orderDateMonthOfYear"]
string
orderItemSeqId_Group/orderDateMonthOfYear
measure["orderItemSeqId"]
integer
Group/orderDateMonthOfYear
SUM
quantity_Group/orderDateMonthOfYear
measure["quantity"]
float
Group/orderDateMonthOfYear
SUM
extGrossAmount_Group/orderDateMonthOfYear
measure["extGrossAmount"]
float
Group/orderDateMonthOfYear
SUM
orderItemSeqId_Group/productId
measure["orderItemSeqId"]
integer
Group/productId
SUM
quantity_Group/productId
measure["quantity"]
float
Group/productId
SUM
extGrossAmount_Group/productId
measure["extGrossAmount"]
float
Group/productId
SUM
productId_TOTAL
dimension["Group"]["productId"]+" TOTAL"
string
orderItemSeqId
measure["orderItemSeqId"]
integer
SUM
quantity
measure["quantity"]
float
SUM
extGrossAmount
measure["extGrossAmount"]
float
SUM