Universe Name - Sample Universe

Universe Name - Sample Universe

Universe Long Name - Sample Universe

Universe Details

Name / Sample Universe
Long Name / Sample Universe
Path / C:\Documents and Settings\Administrator\Application Data\Business Objects\Business Objects 11.5\Universes
Full Name / C:\Documents and Settings\Administrator\Application Data\Business Objects\Business Objects 11.5\Universes\Sample Universe.unv
Description / Sample universe for documenter demo
Version 6.0
Connection / efashion
Author / dba
Creation Date / 11/20/2008
Modifier / dba
Modification Date / 11/20/2008
Revision Number / 125
Comments / Sample data for documenter demo
Updated by Glynn Naughton March 2002 to reflect updates to the database (some columns added, others renamed).
Current Qualifier / C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Samples\en\Databases\efashion
Current Owner
Current Join Strategy / Edit Manually (none)
Current Object Strategy / (Built-in) Standard Renaming
Current Table Strategy / (Built-in) Standard
Use Custom Hierarchies / False
Owner Supported / False
Qualifier Supported / True
Language / English

Classes and Objects Listing

Object / Description
Store / Geography and store hierarchy.
State / State located.
City / City located.
Store name / Name of store.
Zip Code / Zip code
Address / Address of store
Sales floor size? / Prompt for sales floor group - '0-99','100-199','200-299','300-399','400-499','500+
Owned stores / Filter for wholly owned stores, rather than franchises
Stores with long opening hours / Filter for stores with long opening hours
Store details / Store details referring to Store name.
Long opening hours / Y=Late night opening, N=Normal store hours.
Name of manager / Manager's name.
Opening date / Date store opened.
Owned (y/n) / Y=Wholly owned by e-Fashion, N=Franchise
Sales floor size group / Sales floor size group: 0-999, 1000-1999, 2000-2999, 3000-3999, 4000-4999, 5000+.
Sales floor size sqFt / Actual sales floor size in sqFt
Extended sales floor size / Summed sales floor size. Can only be mixed with geography information relating to a store or group of stores. It cannot be used to show the SqFt of a store over time for instance.
Measures / 3 years historical view showing measures in both USD and Euros.
Sales revenue / Sales revenue $ - $ revenue of SKU sold
Quantity sold / Quantity sold - number of SKU sold
Sales present / Sales were present. Must be combined with a detailed object to make any sense. Example Year + 'Sales Present' AND 'SKU desc=E-Watches' to see which years revenue was generated for E- Watches.
Sales not present / Sales were not present. Must be combined with a detailed object to make any sense. Example Year + 'Sales not Present' AND 'SKU desc=E-Watches' to see which years no revenue was generated for E- Watches.

Detailed Objects Listing

Store

Class Description - Geography and store hierarchy.

Name / State
Description / State located.
Select Clause / @aggregate_aware(
Agg_yr_qt_rn_st_ln_ca_sr.State,
Outlet_Lookup.State)
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / state068
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / True
Root Class / Store
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Name / City
Description / City located.
Select Clause / @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City,
Outlet_Lookup.City)
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / ville01v
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / True
Root Class / Store
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Name / Store name
Description / Name of store.
Select Clause / @aggregate_aware(
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Store_name,
Outlet_Lookup.Shop_name)
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / nom_m01k
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / True
Root Class / Store
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Name / Zip Code
Description / Zip code
Select Clause / Outlet_Lookup.Zip_code
Where Clause
Type / Numeric
Qualification / Detail
Object is visible? / True
Has List of Values? / True
LOV Name / zip_c069
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Associated Dimension / Store name
Root Class / Store
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / 0
Tables Associated with Object / Outlet_Lookup
Name / Address
Description / Address of store
Select Clause / Outlet_Lookup.Address_1
Where Clause
Type / Character
Qualification / Detail
Object is visible? / True
Has List of Values? / True
LOV Name / adres01o
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Associated Dimension / Store name
Root Class / Store
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Tables Associated with Object / Outlet_Lookup
Condition Name / Sales floor size?
Description / Prompt for sales floor group - '0-99','100-199','200-299','300-399','400-499','500+
Where Clause / IIf(Outlet_Lookup.Floor_space>=100, IIf(Outlet_Lookup.Floor_space>=200, IIf(Outlet_Lookup.Floor_space>=300, IIf(Outlet_Lookup.Floor_space>=400, IIf(Outlet_Lookup.Floor_space>=500, '500 +','400-499'),'300-399'), '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)
Condition is visible? / True
Tables Associated with Condition / Outlet_Lookup
Condition Name / Owned stores
Description / Filter for wholly owned stores, rather than franchises
Where Clause / @select(Store details\Owned (y/n)) = 'Y'
Condition is visible? / True
Condition Name / Stores with long opening hours
Description / Filter for stores with long opening hours
Where Clause / @select(Store details\Long opening hours) = 'Y'
Condition is visible? / True

Store details

Class Description - Store details referring to Store name.

Name / Long opening hours
Description / Y=Late night opening, N=Normal store hours.
Select Clause / Outlet_Lookup.Long_opening_hours_flag
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / ouver01r
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / 0
Tables Associated with Object / Outlet_Lookup
Name / Name of manager
Description / Manager's name.
Select Clause / Outlet_Lookup.Manager
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / respo01p
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Tables Associated with Object / Outlet_Lookup
Name / Opening date
Description / Date store opened.
Select Clause / Outlet_Lookup.Date_open
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / date_01q
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Tables Associated with Object / Outlet_Lookup
Name / Owned (y/n)
Description / Y=Wholly owned by e-Fashion, N=Franchise
Select Clause / Outlet_Lookup.Owned_outright_flag
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / propr01s
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Tables Associated with Object / Outlet_Lookup
Name / Sales floor size group
Description / Sales floor size group: 0-999, 1000-1999, 2000-2999, 3000-3999, 4000-4999, 5000+.
Select Clause / IIf(Outlet_Lookup.Floor_space>=1000, IIf(Outlet_Lookup.Floor_space>=2000, IIf(Outlet_Lookup.Floor_space>=3000, IIf(Outlet_Lookup.Floor_space>=4000, IIf(Outlet_Lookup.Floor_space>=5000, '5000 +','4000-4999'),'3000-3999'), '2000-2999'),'1000-1999') ,'0-999')
Where Clause
Type / Character
Qualification / Dimension
Object is visible? / True
Has List of Values? / True
LOV Name / surfa01t
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / True
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / #,##000 Sqft
Tables Associated with Object / Outlet_Lookup
Name / Sales floor size sqFt
Description / Actual sales floor size in sqFt
Select Clause / Outlet_Lookup.Floor_space
Where Clause
Type / Numeric
Qualification / Detail
Object is visible? / True
Has List of Values? / True
LOV Name / surfa01t
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Associated Dimension / Sales floor size group
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / #,##000 Sqft
Tables Associated with Object / Outlet_Lookup
Name / Extended sales floor size
Description / Summed sales floor size. Can only be mixed with geography information relating to a store or group of stores. It cannot be used to show the SqFt of a store over time for instance.
Select Clause / sum (Outlet_Lookup.Floor_space)
Where Clause
Type / Numeric
Qualification / Measure
Object is visible? / True
Has List of Values? / True
LOV Name / surfa01t
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Aggregate Function / Sum
Root Class / Store details
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / #,##000 Sqft
Tables Associated with Object / Outlet_Lookup

Measures

Class Description - 3 years historical view showing measures in both USD and Euros.

Name / Sales revenue
Description / Sales revenue $ - $ revenue of SKU sold
Select Clause / @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 Clause
Type / Numeric
Qualification / Measure
Object is visible? / True
Has List of Values? / True
LOV Name / monta047
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Aggregate Function / Sum
Root Class / Measures
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / $#,##0;$-#,##0[Red];;Discontinued[Dark Red]
Name / Quantity sold
Description / Quantity sold - number of SKU sold
Select Clause / @aggregate_aware(
sum(Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Quantity_sold),
sum(Shop_facts.Quantity_sold))
Where Clause
Type / Numeric
Qualification / Measure
Object is visible? / True
Has List of Values? / True
LOV Name / quant048
Allow User to Edit LOV? / True
Automatic LOV Refresh Before Use? / False
Export LOV with Universe? / False
Aggregate Function / Sum
Root Class / Measures
Security Level / Public
Can be used as Result? / True
Can be used as Condition? / True
Can be used as Sort? / True
Hierarchical Display? / False
Format Number / #,##0;;;Discontinued[Dark Red]
Condition Name / Sales present
Description / Sales were present. Must be combined with a detailed object to make any sense. Example Year + 'Sales Present' AND 'SKU desc=E-Watches' to see which years revenue was generated for E- Watches.
Where Clause / Shop_facts.Amount_sold IS NOT NULL
Condition is visible? / False
Tables Associated with Condition / Shop_facts
Condition Name / Sales not present
Description / Sales were not present. Must be combined with a detailed object to make any sense. Example Year + 'Sales not Present' AND 'SKU desc=E-Watches' to see which years no revenue was generated for E- Watches.
Where Clause / Shop_facts.Amount_sold IS NULL
Condition is visible? / False
Tables Associated with Condition / Shop_facts

Control Options

Limit Size of Result Set? / True
Limit Size of Result Set to rows: / 90000
Limit Execution Time? / True
Limit Execution time to minutes: / 300
Warn if cost estimate is exceeded? / False
Cost Estimate Exceeded Value: / 300
Limit Size of Long Text Objects? / False
Long Text Objects Limited to: / 1000

SQL Options

Allow use of sub queries? / True
Allow use of union, intersect and minus operators ? / True
Allow complex operands in query panel? / True
Multiple SQL statements for each context? / True
Multiple SQL statements for each measure? / True
Allow selection of multiple contexts? / False
Prevent cartesian products? / False

Joins

Expression / Cardinality / Outer Join / Short Cut
Article_Color_Lookup.Article_id=Shop_facts.Article_id and Article_Color_Lookup.Color_code=Shop_facts.Color_code / One to Many / No outer join / False
Article_lookup.Article_id=product_promotion_facts.Article_id / One to Many / No outer join / False
Article_lookup.Article_id=Shop_facts.Article_id / One to Many / No outer join / False
Article_Lookup_Criteria.Article_id=Article_lookup.Article_id / Many to One / No outer join / False
Outlet_Lookup.Shop_id=Shop_facts.Shop_id / One to Many / No outer join / False
product_promotion_facts.Article_id=Shop_facts.Article_id / One to Many / No outer join / True
product_promotion_facts.Week_id=Calendar_year_lookup.Week_id / Many to One / No outer join / False
promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id / One to Many / No outer join / False
Shop_facts.Week_id=Calendar_year_lookup.Week_id / Many to One / No outer join / False

Contexts