sap bo efashion
Post on 04-Feb-2018
233 Views
Preview:
TRANSCRIPT
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 1/29
iverse:eFashion 4/3/2015
Page 1/29
Universe Parameters
Definition Name: eFashion
Description: eFashion retail Data Ware house dated 14 Oct 2007.
89,000+ row fact table. V
ersion 13
Connection: efashion-webi
General information Created: 6/25/1998 by
Modified: 4/3/2015 by Administrator
Comments: eFashion Data Warehouse D
emo created by G.BowmanOctober 1998. Copyright B
usiness Objects 1998.
DB details: 89,00
0 line fact table, 10 line
promotions 2nd fact table,
dual article lookup table
s for performance, 2 isola
ted aggregate tables for d
emo purposes
Updated by Glynn Naughton
March 2002 to reflect upd
ates to the database (som
e columns added, others r
enamed).
Statistics: 6 Classes
41 Objects
10 Tables
0 Aliases
9 Joins
2 Contexts
3 Hierarchies
12 Conditions
Strategies Join strategy: Edit Manually (none)
Table strategy: (Built-in) Standard
Object strategy: (Built-in) Standard Renaming
Controls Limit size of result set to: 90000 rows
Limit size of long text objects to: unchecked
Limit execution time to: 5 minutes
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 2/29
verse:eFashion 4/3/2015
Page 2/29
Warn if cost estimate exceeds: unchecked
SQL parametersQuery
Allow use of subqueries: yes
Allow use of union, intersect and minus operators: yes
Allow complex conditions in Query Panel: yes
Cartesian products: warn
Multiple paths
Generate several SQL statements for each context: yes
Generate several SQL statements for each measure: yes
Allow selection of multiple contexts: no
LinksNo links for this universe
Object ListTime period Year
Fiscal Period
Quarter
Month
Month Name
Week
Year/week
Holiday (y/n)
StoreState
City
Store name
Zip Code
Address
Store detailsLong opening hours
Name of manager
Opening date
Owned (y/n)
Sales floor size group
Sales floor size sqFt
Extended sales floor size
ProductLines
Category
SKU number
Label
SKU descColor
Color number
Unit Price MSRP
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 3/29
verse:eFashion 4/3/2015
Page 3/29
Extended price
Sold at (unit price)
PromotionsPromotion (y/n)
Radio
Television
Direct mail
Duration
Promotion Cost USD
MeasuresSales revenue
Quantity sold
Margin
Discount
Object Properties
Class: Time periodDescription: Time hierarchy
Object: YearType: Character
Description: Year 2003 - 2006.
Select equivalent: @aggregate_aware( Agg_yr_qt_rn_st_ln_ca_sr.Yr,
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Yr,
Calendar_year_lookup.Yr)
Where equivalent:
Qualification: dimension
List of values: year05d, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: showFormat Number
Category = Standard
Alignment
Horizontal = Right
Object: Fiscal PeriodType: Character
Description: Year FY99 - FY01
Select equivalent: Calendar_year_lookup.Fiscal_period
Where equivalent:
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 4/29
verse:eFashion 4/3/2015
Page 4/29
Qualification: detail
Associated dimension name: Year
List of values: fisca05c, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: showFormat Number
Category = Standard
Object: QuarterType: Character
Description: Quarter number: Q1, Q2, Q3, Q4.
Select equivalent: @aggregate_aware(
Agg_yr_qt_rn_st_ln_ca_sr.Qtr, Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Qtr,
{fn concat('Q',Calendar_year_lookup.Qtr)})
Where equivalent:
Qualification: dimension
List of values: quart05b, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
0
Object: MonthType: Number
Description: Month number in year, 1-12.
Select equivalent: @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Mth,
Calendar_year_lookup.Mth)
Where equivalent:
Qualification: dimension
List of values: month05a, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
0
Object: Month NameType: Character
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 5/29
verse:eFashion 4/3/2015
Page 5/29
Description: Month name, January-December.
Select equivalent: @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Month_name,
Calendar_year_lookup.Month_Name)
Where equivalent:
Qualification: detail
Associated dimension name: Month
List of values: month05l, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Week
Type: NumberDescription: Week1-53. Week 53 may o
verlap with week 1 of th
e following year.
Select equivalent: @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Wk,
Calendar_year_lookup.Week_in_year)
Where equivalent:
Qualification: dimension
List of values: week07f, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Year/week Type: Character
Description: Week 2003/1 to 2006/53 -
Unique year and week de
scribing date. Use this t
o create conditions acro
ss year boundaries. i.e.
Christmas period = 2003/
52 to 2006/1.
Select equivalent: Calendar_year_lookup.Year_Week
Where equivalent:
Qualification: detail
Associated dimension name: Week
List of values: year_0ec, editable, manual refresh, exportable
Security access level: 0Can be used: in result, in condition, in sort
Object status: show
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 6/29
verse:eFashion 4/3/2015
Page 6/29
Object: Holiday (y/n)Type: Character
Description: Holiday flag in week. Y=
US public holiday during
the time period, N=No holiday. Can be mixed wit
h any time period dimens
ion.
Select equivalent: ucase(Calendar_year_lookup.Holiday_Flag)
Where equivalent:
Qualification: dimension
List of values: holid08a, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sortObject status: show
Class: StoreDescription: Geography and store hierarchy.
Object: StateType: Character
Description: State located.
Select equivalent: @aggregate_aware(
Agg_yr_qt_rn_st_ln_ca_sr.State,
Outlet_Lookup.State)
Where equivalent:
Qualification: dimension
List of values: state068, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: CityType: Character
Description: City located.
Select equivalent: @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City,
Outlet_Lookup.City)
Where equivalent:
Qualification: dimension
List of values: ville01v, editable, manual refresh, exportable
Security access level: 0Can be used: in result, in condition, in sort
Object status: show
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 7/29
verse:eFashion 4/3/2015
Page 7/29
Object: Store nameType: Character
Description: Name of store.
Select equivalent: @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Store_name,Outlet_Lookup.Shop_name)
Where equivalent:
Qualification: dimension
List of values: nom_m01k, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Zip CodeType: Number
Description: Zip code
Select equivalent: Outlet_Lookup.Zip_code
Where equivalent:
Qualification: detail
Associated dimension name: Store name
List of values: zip_c069, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
0
Object: AddressType: Character
Description: Address of store
Select equivalent: Outlet_Lookup.Address_1
Where equivalent:
Qualification: detail
Associated dimension name: Store name
List of values: adres01o, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Class: Store detailsDescription: Store details referring to Store name.
Object: Long opening hours
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 8/29
verse:eFashion 4/3/2015
Page 8/29
Type: Character
Description: Y=Late night opening, N=Normal store hours.
Select equivalent: Outlet_Lookup.Long_opening_hours_flag
Where equivalent:
Qualification: dimensionList of values: ouver01r, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
0
Object: Name of managerType: Character
Description: Manager's name.
Select equivalent: Outlet_Lookup.Manager
Where equivalent:
Qualification: dimension
List of values: respo01p, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Opening dateType: Character
Description: Date store opened.
Select equivalent: Outlet_Lookup.Date_open
Where equivalent:
Qualification: dimension
List of values: date_01q, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Owned (y/n)Type: Character
Description: Y=Wholly owned by e-Fashion, N=Franchise
Select equivalent: Outlet_Lookup.Owned_outright_flag
Where equivalent:
Qualification: dimension
List of values: propr01s, editable, manual refresh, not exportable
Security access level: 0
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 9/29
verse:eFashion 4/3/2015
Page 9/29
Can be used: in result, in condition, in sort
Object status: show
Object: Sales floor size group
Type: CharacterDescription: Sales floor size group: 0
-999, 1000-1999, 2000-29
99, 3000-3999, 4000-4999
, 5000+.
Select equivalent: IIf(Outlet_Lookup.Floor_
space>=1000, IIf(Outlet_
Lookup.Floor_space>=200
0, IIf(Outlet_Lookup.Flo
or_space>=3000, IIf(Outl
et_Lookup.Floor_space>=4000, IIf(Outlet_Lookup.
Floor_space>=5000, '500
0 +','4000-4999'),'3000-
3999'), '2000-2999'),'10
00-1999') ,'0-999')
Where equivalent:
Qualification: dimension
List of values: surfa01t, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
#,##000 Sqft
Object: Sales floor size sqFtType: Number
Description: Actual sales floor size in sqFt
Select equivalent: Outlet_Lookup.Floor_space
Where equivalent:
Qualification: detail
Associated dimension name: Sales floor size group
List of values: surfa01t, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number#,##000 Sqft
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 10/29
verse:eFashion 4/3/2015
Page 10/29
Object: Extended sales floor sizeType: Number
Description: Summed sales floor size.
Can only be mixed with
geography information re
lating to a store or group of stores. It cannot be
used to show the SqFt o
f a store over time for i
nstance.
Select equivalent: sum (Outlet_Lookup.Floor_space)
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: surfa01t, editable, manual refresh, not exportableSecurity access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
#,##000 Sqft
Class: ProductDescription: Product Hierarchy
Object: LinesType: Character
Description: Product line. Each line contains a set of categories.
Select equivalent: @aggregate_aware(
Agg_yr_qt_rn_st_ln_ca_sr.Line,
Article_lookup.Family_name,
Article_Color_Lookup.Family_name)
Where equivalent:
Qualification: dimension
List of values: libel04p, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: CategoryType: Character
Description: Each category contains t
he individual SKU codes
(and product descriptions).
Select equivalent: @aggregate_aware(
Agg_yr_qt_rn_st_ln_ca_sr.Category,
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 11/29
verse:eFashion 4/3/2015
Page 11/29
Article_lookup.Category,
Article_Color_Lookup.Category)
Where equivalent:
Qualification: dimension
List of values: categ0ei, editable, manual refresh, exportableSecurity access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: SKU numberType: Number
Description: Stock Keeping Unit numbe
r (SKU).The lowest level
of product description.Select equivalent: @aggregate_aware(
Article_lookup.Article_id,
Article_Color_Lookup.Article_id)
Where equivalent:
Qualification: dimension
List of values: artic066, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
#,##0
Object: LabelType: Character
Description: Detailed information about each product
Select equivalent: {fn concat(Article_Looku
p_Criteria.Criteria_Type
_Label,{fn concat(': ',Ar
ticle_Lookup_Criteria.Cri
teria_label)})}
Where equivalent:
Qualification: detail
Associated dimension name: SKU number
List of values: objec0dd, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sortObject status: show
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 12/29
verse:eFashion 4/3/2015
Page 12/29
Object: SKU descType: Character
Description: Stock Keeping Unit descr
iption (SKU). Lowest lev
el of product description
. Each product comes inseveral different colors.
Select equivalent: @aggregate_aware(
Article_lookup.Article_label,
Article_Color_Lookup.Article_label)
Where equivalent:
Qualification: dimension
List of values: libel04c, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sortObject status: show
Object: ColorType: Character
Description: Color of an article. Each
SKU number has many co
lor variations (there is
not a unique SKU for eac
h color). Color is not co
mpatible with Product Pr
omotions, only SKU.
Select equivalent: Article_Color_Lookup.Color_label
Where equivalent:
Qualification: dimension
List of values: libel04d, editable, manual refresh, exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Color numberType: Number
Description: Official color number. O
bject incompatible with
Product Promotions.
Select equivalent: Article_Color_Lookup.Color_code
Where equivalent:
Qualification: detail Associated dimension name: Color
List of values: color0ck, editable, manual refresh, not exportable
Security access level: 0
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 13/29
verse:eFashion 4/3/2015
Page 13/29
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Number
0
Object: Unit Price MSRPType: Number
Description: This is the manufacturer
s suggested retail price
per SKU and color.
Select equivalent: @aggregate_aware(
Article_lookup.Sale_price,
Article_Color_Lookup.Sale_price)
Where equivalent:
Qualification: dimension
List of values: prix_04e, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Currency
$#,##0.00
Object: Extended priceType: Number
Description: The extended price let's
you display the sum of
prices over another dime
nsion (such as outlet).
When used with SKU numb
er all the color variatio
ns (of each SKU) are add
ed together.
Select equivalent: @aggregate_aware(
sum(Article_lookup.Sale_price),
sum(Article_Color_Lookup.Sale_price))
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: prix_04e, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sortObject status: show
Format Number
Category = Currency
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 14/29
verse:eFashion 4/3/2015
Page 14/29
$#,##0.00
Object: Sold at (unit price)Type: Number
Description: This is the actual unit price per SKU obtained at
sale time (i.e. Revenue/
Quantity)
Select equivalent: IIf(@Select(Measures\Sales revenue)>0,
IIf(@Select(Measures\Quantity sold)>=0,
@Select(Measures\
Sales revenue)/@Select(M
easures\Quantity sold)))
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: objec098, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Currency
$#,##0.00
Class: PromotionsDescription: Promotions by SKU number over time.
Object: Promotion (y/n)Type: Character
Description: Promotion flag (yes or no) by SKU unit.
Select equivalent: promotion_lookup.Promotion_flag
Where equivalent:
Qualification: dimension
List of values: promo07l, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: PrintType: Character
Description: Appear in print (yes or no)?
Select equivalent: promotion_lookup.print_flag
Where equivalent:
Qualification: detail
Associated dimension name: Promotion (y/n)
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 15/29
verse:eFashion 4/3/2015
Page 15/29
List of values: print07m, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: RadioType: Character
Description: Appear in radio (yes or no)?
Select equivalent: promotion_lookup.radio_flag
Where equivalent:
Qualification: detail
Associated dimension name: Promotion (y/n)
List of values: radio07n, editable, manual refresh, not exportable
Security access level: 0Can be used: in result, in condition, in sort
Object status: show
Object: TelevisionType: Character
Description: Appear on television (yes or no)?
Select equivalent: promotion_lookup.television_flag
Where equivalent:
Qualification: detail
Associated dimension name: Promotion (y/n)
List of values: telev07o, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Direct mailType: Character
Description: Appear in direct mail (yes or no)?
Select equivalent: promotion_lookup.direct_mail_flag
Where equivalent:
Qualification: detail
Associated dimension name: Promotion (y/n)
List of values: direc07p, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: DurationType: Number
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 16/29
verse:eFashion 4/3/2015
Page 16/29
Description: Duration in weeks of promotion.
Select equivalent: product_promotion_facts.Duration
Where equivalent:
Qualification: dimension
List of values: durat07g, editable, manual refresh, not exportableSecurity access level: 0
Can be used: in result, in condition, in sort
Object status: show
Object: Promotion Cost USDType: Number
Description: Cost of promoting the SKU (in US dollars).
Select equivalent: sum(product_promotion_facts.promotion_cost)
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: promo07h, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Currency
$#,##0;$-#,##0[Red]
Class: MeasuresDescription: 3 years historical view showing measures in both USD and Euros.
Object: Sales revenueType: Number
Description: Sales revenue $ - $ revenue of SKU sold
Select equivalent: @aggregate_aware(
sum(Agg_yr_qt_rn_st_ln_ca_sr.Sales_revenue),
sum(Agg_yr_qt_mt_mn_wk_
rg_cy_sn_sr_qt_ma.Sales_
revenue),
sum(Shop_facts.Amount_sold))
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: monta047, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: showFormat Number
Category = Currency
$#,##0;$-#,##0[Red];;Discontinued[Dark Red]
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 17/29
verse:eFashion 4/3/2015
Page 17/29
Object: Quantity soldType: Number
Description: Quantity sold - number of SKU sold
Select equivalent: @aggregate_aware(sum(Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Quantity_sold),
sum(Shop_facts.Quantity_sold))
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: quant048, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: showFormat Number
Category = Number
#,##0;;;Discontinued[Dark Red]
Object: MarginType: Number
Description: Margin $ = Revenue - Cost of sales
Select equivalent: @aggregate_aware(
sum(Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Margin),
sum(Shop_facts.Margin))
Where equivalent:
Qualification: measure
Aggregate function: Sum
List of values: marge046, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sort
Object status: show
Format Number
Category = Currency
$#,##0;$-#,##0[Red];;Discontinued[Dark Red]
Object: DiscountType: Number
Description: Total discount of a SKU.
Discount= Qty * Unit Pr
ice - Revenue. Negative
sums indicate the produ
ct was marked up (increased margin). Note discou
nt is a calculated object
(it does not exist in th
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 18/29
verse:eFashion 4/3/2015
Page 18/29
e fact table).
Select equivalent: @aggregate_aware(
sum(Shop_facts.Quantity_
sold * Article_lookup.Sal
e_price - Shop_facts.Amo
unt_sold),sum(Shop_facts.Quantity_
sold * Article_Color_Loo
kup.Sale_price - Shop_fa
cts.Amount_sold))
Where equivalent: Shop_facts.week_id=Calendar_year_lookup.Week_id
Qualification: measure
Aggregate function: Sum
List of values: objec05g, editable, manual refresh, not exportable
Security access level: 0
Can be used: in result, in condition, in sortObject status: show
Format Number
Category = Currency
$#,##0;$-#,##0[Red];;Discontinued[Dark Red]
Condition List
Time period
Last yearThis year
Christmas period
Holiday period
StoreSales floor size?
Owned stores
Stores with long opening hours
Store details
Product
Prompt for a line item?Which category?
Which product?
Promotions
MeasuresSales present
Sales not present
Conditions
Class: Time periodDescription: Time hierarchy
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 19/29
verse:eFashion 4/3/2015
Page 19/29
Last year
Description:Show last year results only - year 2005
Where Equivalent:Calendar_year_lookup.Yr = '2005'
This year
Description:Show this year results only - year 2006
Where Equivalent:Calendar_year_lookup.Yr= '2006'
Christmas period
Description:Filter for Christmas rush period - Weeks 46 to 52 (incl. occasional week 53)
Where Equivalent:Calendar_year_lookup.Week_In_Year BETWEEN 46 AND 53
Holiday period
Description:Filter for weeks that contain holiday periodsWhere Equivalent:ucase(Calendar_year_lookup.Holiday_Flag) = 'Y'
Class: StoreDescription: Geography and store hierarchy.
Sales floor size?
Description:Prompt for sales floor group - '0-99','100-199','200-299','300-399','400-499','500+
Where Equivalent:IIf(Outlet_Lookup.Flo
or_space>=100, IIf(Outlet_Lookup.Floo
r_space>=200, IIf(Outlet_Lookup.Floor
_space>=300, IIf(Outlet_Lookup.Floor_
space>=400, IIf(Outlet_Lookup.Floor_s
pace>=500, '500 +','400-499'),'300-39
9'), '200-299'),'100-199') ,'0-99') IN
@Prompt ('Sales flloor size sqFt?','A',
{'0-99','100-199','200-299','300-399','
400-499','500+'},MULTI,CONSTRAINED)
Owned stores
Description:Filter for wholly owned stores, rather than franchises
Where Equivalent:@select(Store details\Owned (y/n)) = 'Y'
Stores with long opening hours
Description:Filter for stores with long opening hours
Where Equivalent:@select(Store details\Long opening hours) = 'Y'
Class: ProductDescription: Product Hierarchy
Prompt for a line item?
Description:Where Equivalent:Article_Color_Lookup
.Family_name IN @Prompt ('Choose a li
ne to analyze?','A',{'Accessories','Cit
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 20/29
verse:eFashion 4/3/2015
Page 20/29
y Skirts','City Trousers','Dresses','Ja
ckets','Leather','Outerwear','Overcoat
s','Shirt waist','Sweaters','Sweat-T-Sh
irts','Trousers'},MULTI,CONSTRAINED)
Which category?Description:Prompt for the product category
Where Equivalent:Article_Color_Lookup
.Category IN @Prompt ('Choose a categ
ory to analyze?','A',{'2 Pocket shirts'
,'Belts,bags,wallets','Bermudas','Boat
wear','Cardigan','Casual dresses','Day
wear','Dry wear','Evening wear','Fanc
y fabric','Full length','Hair accessori
es','Hats,gloves,scarfs','Jackets','Jea
ns','Jewelry','Long lounge pants','Long sleeve','Lounge wear','Mini city','Ni
ght wear','Outdoor','Pants','Party pan
ts','Samples','Shirts','Short sleeve','
Skirts','Soft fabric','Sweater dresses'
,'Sweats','T-Shirts','Turtleneck','Wet
wear'},MULTI,CONSTRAINED)
Which product?
Description:Prompt for the product description name.
Where Equivalent:Article_Color_Lookup
.Article_label IN @Prompt('Choose the
product descriptions to analyze:','A','
Product\SKU desc',MULTI,CONSTRAINED)
Class: MeasuresDescription: 3 years historical view showing measures in both USD and Euros.
Sales present
Description:Sales were present. Must b
e combined with a detailed object to m
ake any sense. Example Year + 'Sales
Present' AND 'SKU desc=E-Watches' to
see which years revenue was generated
for E- Watches.
Where Equivalent:Shop_facts.Amount_sold IS NOT NULL
Sales not present
Description:Sales were not present. Mu
st be combined with a detailed object
to make any sense. Example Year + 'S
ales not Present' AND 'SKU desc=E-Watches' to see which years no revenue wa
s generated for E- Watches.
Where Equivalent:Shop_facts.Amount_sold IS NULL
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 21/29
verse:eFashion 4/3/2015
Page 21/29
Hierarchies List
Time period
Store
Store details
Product
Promotions
Hierarchies
Time period
Time period/Year
Time period/Quarter
Time period/Month
Time period/Week
Time period/Holiday (y/n)
Store
Store/State
Store/City
Store/Store name
Store details
Store details/Long opening hours
Store details/Name of manager
Store details/Opening dateStore details/Owned (y/n)
Store details/Sales floor size group
Product
Product/Lines
Product/Category
Product/SKU number
Product/SKU desc
Product/Color
Product/Unit Price MSRP
PromotionsPromotions/Promotion (y/n)
Promotions/Duration
Tables List
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma
Agg_yr_qt_rn_st_ln_ca_sr
Article_Color_Lookup
Article_Lookup_Criteria
Article_lookupCalendar_year_lookup
Outlet_Lookup
Shop_facts
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 22/29
verse:eFashion 4/3/2015
Page 22/29
product_promotion_facts
promotion_lookup
Tables
Table Name:Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma
Columns
agg1_id Numeric
Yr Character
Qtr Character
Mth Numeric
Month_name Character
Wk Numeric
City Character
Store_name Character
Sales_revenue Numeric
Quantity_sold Numeric
Margin Numeric
Table Name:Agg_yr_qt_rn_st_ln_ca_sr
Columns
agg2_id Numeric
Yr Character
Qtr Character
State Character
Line Character
Category Character
Sales_revenue Numeric
Table Name:Article_Color_Lookup
Columns
Article_color_lookup_id Numeric
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 23/29
verse:eFashion 4/3/2015
Page 23/29
Article_id Numeric
Color_code Numeric
Article_label Character
Color_label Character
Category Character
Sale_price Numeric
Family_name Character
Family_code Character
Table Name:Article_Lookup_Criteria
Columns
Article_lookup_criteria_id Numeric
Article_id Numeric
Criteria Character
Criteria_type Character
Criteria_type_label Character
Criteria_label Character
Table Name:Article_lookup
Columns
Article_id Numeric
Article_label Character
Category Character
Sale_price Numeric
Family_name Character
Family_code Character
Table Name:Calendar_year_lookup
Columns
Week_id Numeric
Week_In_Year Numeric
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 24/29
verse:eFashion 4/3/2015
Page 24/29
Yr Character
Fiscal_Period Character
Year_Week Character
Qtr Character
Month_Name Character
Mth Numeric
Holiday_Flag Character
Table Name:Outlet_Lookup
ColumnsShop_id Numeric
Shop_name Character
Address_1 Character
Manager Character
Date_open Character
Long_opening_hours_flag Character
Owned_outright_flag Character
Floor_space Numeric
Zip_code Numeric
City Character
State Character
Table Name:Shop_facts
Columns
Shop_facts_id Numeric
Article_id Numeric
Color_code Numeric
Week_id Numeric
Shop_id Numeric
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 25/29
verse:eFashion 4/3/2015
Page 25/29
Margin Numeric
Amount_sold Numeric
Quantity_sold Numeric
Table Name:product_promotion_facts
Columns
Product_promotion_facts_id Numeric
Article_id Numeric
Week_id Numeric
Duration Numeric
Promotion_id Numeric
Promotion_cost Numeric
Table Name:promotion_lookup
Columns
Promotion_id Numeric
Promotion_flag Character
Print_flag Character
Radio_flag Character
Television_flag Character
Direct_mail_flag Character
Join List
Join0: promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id
Join1: product_promotion_facts.Week_id=Calendar_year_lookup.Week_id
Join2: Outlet_Lookup.Shop_id=Shop_facts.Shop_id
Join3: Article_Lookup_Criteria.Article_id=Article_lookup.Article_id
Join4: Article_lookup.Article_id=Shop_facts.Article_id
Join5: Article_lookup.Article_id=product_promotion_facts.Article_id
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 26/29
verse:eFashion 4/3/2015
Page 26/29
Join6: Article_Color_Lookup.Article_id=Sh
op_facts.Article_id and Article_Co
lor_Lookup.Color_code=Shop_facts.
Color_code
Join7: Shop_facts.Week_id=Calendar_year_lookup.Week_id
Join8: product_promotion_facts.Article_id=Shop_facts.Article_id
Joins
Join0: promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id
Qualification: one to many
Outer: No
Join1: product_promotion_facts.Week_id=Calendar_year_lookup.Week_id
Qualification: many to one
Outer: No
Join2: Outlet_Lookup.Shop_id=Shop_facts.Shop_id
Qualification: one to many
Outer: No
Join3: Article_Lookup_Criteria.Article_id=Article_lookup.Article_id
Qualification: many to oneOuter: No
Join4: Article_lookup.Article_id=Shop_facts.Article_id
Qualification: one to many
Outer: No
Join5: Article_lookup.Article_id=product_promotion_facts.Article_id
Qualification: one to many
Outer: No
Join6: Article_Color_Lookup.Article_id=Sh
op_facts.Article_id and Article_Co
lor_Lookup.Color_code=Shop_facts.
Color_code
Qualification: one to many
Outer: No
Join7: Shop_facts.Week_id=Calendar_year_lookup.Week_id
Qualification: many to one
Outer: No
Join8: product_promotion_facts.Article_id=Shop_facts.Article_id
Qualification: one to many
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 27/29
verse:eFashion 4/3/2015
Page 27/29
Outer: No
Context List
Shop facts
Promotions
Context
Context Name:Shop facts
Outlet_Lookup.Shop_id=Shop_facts.Shop_id
Article_lookup.Article_id=Shop_facts.Article_id
Article_Color_Lookup.Article_id=Shop
_facts.Article_id and Article_Color_L
ookup.Color_code=Shop_facts.Color_co
de
Shop_facts.Week_id=Calendar_year_lookup.Week_id
product_promotion_facts.Article_id=Shop_facts.Article_id
Context Name:Promotions
promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id
product_promotion_facts.Week_id=Calendar_year_lookup.Week_id
Article_Lookup_Criteria.Article_id=Article_lookup.Article_id
Article_lookup.Article_id=product_promotion_facts.Article_id
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 28/29
verse:eFashion 4/3/2015
Page 28/29
Promotion_id
Promotion_id
Week_idWeek_id
Shop_id
Shop_id
Article_id
Article_id Article_id Article_id Article_id
Article_id
Article_id
Color_code
Article_id
Color_code
Week_id
Week_id
Article_id
Article_id
Calendar_year_lookup
Week_id
Week_In_Year
Yr
Fiscal_Period
Year_Week
Qtr
Month_Name
Mth
Holiday_Flag
promotion_lookup
Promotion_id
Promotion_flag
Print_flag
Radio_flag
Television_flag
Direct_mail_flag
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_q
agg1_id
Yr
Qtr
Mth
Month_name
Wk
City
Store_name
Sales_revenue
Quantity_sold
Margin
Article_lookup
Article_id
Article_label
Category
Sale_price
Family_name
Family_code
product_promotion_facts
Product_promotion_facts_id
Article_id
Week_id
Duration
Promotion_id
Promotion_cost
Outlet_Lookup
Shop_id
Shop_name
Address_1
Manager
Date_open
Long_opening_hours_flag
Owned_outright_flag
Floor_spaceZip_code
City
State
Shop_facts
Shop_facts_id
Article_id
Color_code
Week_id
Shop_id
Margin
Amount_sold
Quantity_sold
Article_Color_Lookup
Article_color_lookup_id
Article_id
Color_code
Article_labelColor_label
Category
Sale_price
Family_name
Family_code
Agg_yr_qt_rn_st_ln_ca_sr
agg2_id
Yr
Qtr
State
Line
Category
Sales_revenue
Article_Lookup_Criteria
Article_lookup_criteria_id
Article_id
Criteria
Criteria_typeCriteria_type_label
Criteria_label
7/21/2019 SAP BO EFashion
http://slidepdf.com/reader/full/sap-bo-efashion 29/29
verse:eFashion 4/3/2015
_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma
name
ame
venue
y_sold
top related