Universe Name - Sample Universe


Contents

Universe Details

Classes and Objects Listing

Detailed Objects Listing

Control Options

SQL Options

Joins

Contexts

Custom Hierarchies

Default Hierarchies

Linked Universes

Tables and Columns

Incompatible Objects



Universe Details
NameSample Universe
Long NameSample Universe
PathC:\Documents and Settings\Administrator\Application Data\Business Objects\Business Objects 11.5\Universes
Full NameC:\Documents and Settings\Administrator\Application Data\Business Objects\Business Objects 11.5\Universes\Sample Universe.unv
DescriptionSample universe for documenter demo Version 6.0
Connectionefashion
Authordba
Creation Date11/20/2008
Modifierdba
Modification Date11/20/2008
Revision Number125
CommentsSample data for documenter demo Updated by Glynn Naughton March 2002 to reflect updates to the database (some columns added, others renamed).
Current QualifierC:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Samples\en\Databases\efashion
Current Owner
Current Join StrategyEdit Manually (none)
Current Object Strategy(Built-in) Standard Renaming
Current Table Strategy(Built-in) Standard
Use Custom HierarchiesFalse
Owner SupportedFalse
Qualifier SupportedTrue
LanguageEnglish

 

 

Classes and Objects Listing
 StoreGeography and store hierarchy.
    StateState located.
    CityCity located.
    Store nameName of store.
     Zip CodeZip code
     AddressAddress of store
     Sales floor size?Prompt for sales floor group - '0-99','100-199','200-299','300-399','400-499','500+
     Owned storesFilter for wholly owned stores, rather than franchises
     Stores with long opening hoursFilter for stores with long opening hours
   Store detailsStore details referring to Store name.
       Long opening hoursY=Late night opening, N=Normal store hours.
       Name of managerManager's name.
       Opening dateDate store opened.
       Owned (y/n)Y=Wholly owned by e-Fashion, N=Franchise
       Sales floor size groupSales floor size group: 0-999, 1000-1999, 2000-2999, 3000-3999, 4000-4999, 5000+.
        Sales floor size sqFtActual sales floor size in sqFt
       Extended sales floor sizeSummed 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.
 Measures3 years historical view showing measures in both USD and Euros.
    Sales revenueSales revenue $ - $ revenue of SKU sold
    Quantity soldQuantity sold - number of SKU sold
     Sales presentSales 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 presentSales 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
 StoreGeography and store hierarchy.
 
NameState
DescriptionState located.
Select Clause@aggregate_aware( Agg_yr_qt_rn_st_ln_ca_sr.State, Outlet_Lookup.State)
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namestate068
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?True
Root ClassStore
Security LevelPublic
Can be used as Result?True
Can be used as Condition?True
Can be used as Sort?True
Hierarchical Display?False
 
 
NameCity
DescriptionCity located.
Select Clause@aggregate_aware( Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City, Outlet_Lookup.City)
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Nameville01v
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?True
Root ClassStore
Security LevelPublic
Can be used as Result?True
Can be used as Condition?True
Can be used as Sort?True
Hierarchical Display?False
 
 
NameStore name
DescriptionName 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
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namenom_m01k
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?True
Root ClassStore
Security LevelPublic
Can be used as Result?True
Can be used as Condition?True
Can be used as Sort?True
Hierarchical Display?False
 
 
NameZip Code
DescriptionZip code
Select ClauseOutlet_Lookup.Zip_code
Where Clause
TypeNumeric
QualificationDetail
Object is visible?True
Has List of Values?True
LOV Namezip_c069
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Associated DimensionStore name
Root ClassStore
Security LevelPublic
Can be used as Result?True
Can be used as Condition?True
Can be used as Sort?True
Hierarchical Display?False
Format Number0
Tables Associated with Object
Outlet_Lookup
 
 
NameAddress
DescriptionAddress of store
Select ClauseOutlet_Lookup.Address_1
Where Clause
TypeCharacter
QualificationDetail
Object is visible?True
Has List of Values?True
LOV Nameadres01o
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Associated DimensionStore name
Root ClassStore
Security LevelPublic
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 NameSales floor size?
DescriptionPrompt for sales floor group - '0-99','100-199','200-299','300-399','400-499','500+
Where ClauseIIf(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 NameOwned stores
DescriptionFilter for wholly owned stores, rather than franchises
Where Clause@select(Store details\Owned (y/n)) = 'Y'
Condition is visible?True
 
Condition NameStores with long opening hours
DescriptionFilter for stores with long opening hours
Where Clause@select(Store details\Long opening hours) = 'Y'
Condition is visible?True
   Store detailsStore details referring to Store name.
 
NameLong opening hours
DescriptionY=Late night opening, N=Normal store hours.
Select ClauseOutlet_Lookup.Long_opening_hours_flag
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Nameouver01r
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Root ClassStore details
Security LevelPublic
Can be used as Result?True
Can be used as Condition?True
Can be used as Sort?True
Hierarchical Display?False
Format Number0
Tables Associated with Object
Outlet_Lookup
 
 
NameName of manager
DescriptionManager's name.
Select ClauseOutlet_Lookup.Manager
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namerespo01p
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Root ClassStore details
Security LevelPublic
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
 
 
NameOpening date
DescriptionDate store opened.
Select ClauseOutlet_Lookup.Date_open
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namedate_01q
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Root ClassStore details
Security LevelPublic
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
 
 
NameOwned (y/n)
DescriptionY=Wholly owned by e-Fashion, N=Franchise
Select ClauseOutlet_Lookup.Owned_outright_flag
Where Clause
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namepropr01s
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Root ClassStore details
Security LevelPublic
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
 
 
NameSales floor size group
DescriptionSales floor size group: 0-999, 1000-1999, 2000-2999, 3000-3999, 4000-4999, 5000+.
Select ClauseIIf(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
TypeCharacter
QualificationDimension
Object is visible?True
Has List of Values?True
LOV Namesurfa01t
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?True
Root ClassStore details
Security LevelPublic
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
 
 
NameSales floor size sqFt
DescriptionActual sales floor size in sqFt
Select ClauseOutlet_Lookup.Floor_space
Where Clause
TypeNumeric
QualificationDetail
Object is visible?True
Has List of Values?True
LOV Namesurfa01t
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Associated DimensionSales floor size group
Root ClassStore details
Security LevelPublic
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
 
 
NameExtended sales floor size
DescriptionSummed 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 Clausesum (Outlet_Lookup.Floor_space)
Where Clause
TypeNumeric
QualificationMeasure
Object is visible?True
Has List of Values?True
LOV Namesurfa01t
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Aggregate FunctionSum
Root ClassStore details
Security LevelPublic
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
 
 Measures3 years historical view showing measures in both USD and Euros.
 
NameSales revenue
DescriptionSales 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
TypeNumeric
QualificationMeasure
Object is visible?True
Has List of Values?True
LOV Namemonta047
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Aggregate FunctionSum
Root ClassMeasures
Security LevelPublic
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]
 
 
NameQuantity sold
DescriptionQuantity 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
TypeNumeric
QualificationMeasure
Object is visible?True
Has List of Values?True
LOV Namequant048
Allow User to Edit LOV?True
Automatic LOV Refresh Before UseFalse
Export LOV with Universe?False
Aggregate FunctionSum
Root ClassMeasures
Security LevelPublic
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 NameSales present
DescriptionSales 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 ClauseShop_facts.Amount_sold IS NOT NULL
Condition is visible?False
Tables Associated with Condition
Shop_facts
 
Condition NameSales not present
DescriptionSales 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 ClauseShop_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
ExpressionCardinalityOuter JoinShort Cut Join
Article_Color_Lookup.Article_id=Shop_facts.Article_id and Article_Color_Lookup.Color_code=Shop_facts.Color_code One to ManyNo outer joinFalse
Article_lookup.Article_id=product_promotion_facts.Article_id One to ManyNo outer joinFalse
Article_lookup.Article_id=Shop_facts.Article_id One to ManyNo outer joinFalse
Article_Lookup_Criteria.Article_id=Article_lookup.Article_id Many to OneNo outer joinFalse
Outlet_Lookup.Shop_id=Shop_facts.Shop_id One to ManyNo outer joinFalse
product_promotion_facts.Article_id=Shop_facts.Article_id One to ManyNo outer joinTrue
product_promotion_facts.Week_id=Calendar_year_lookup.Week_id Many to OneNo outer joinFalse
promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id One to ManyNo outer joinFalse
Shop_facts.Week_id=Calendar_year_lookup.Week_id Many to OneNo outer joinFalse

 

 

Contexts
Context NameDescription
 
Shop facts
Article_Color_Lookup.Article_id=Shop_facts.Article_id and Article_Color_Lookup.Color_code=Shop_facts.Color_code
Article_lookup.Article_id=Shop_facts.Article_id
Outlet_Lookup.Shop_id=Shop_facts.Shop_id
product_promotion_facts.Article_id=Shop_facts.Article_id
Shop_facts.Week_id=Calendar_year_lookup.Week_id
 
Promotions
Article_lookup.Article_id=product_promotion_facts.Article_id
Article_Lookup_Criteria.Article_id=Article_lookup.Article_id
product_promotion_facts.Week_id=Calendar_year_lookup.Week_id
promotion_lookup.Promotion_id=product_promotion_facts.Promotion_id

 

 

Custom Hierarchies
 
Time period
 
Store
State
City
Store name
 
Products

 

 

Default Hierarchies
 
Store
State
City
Store name
 
Store details
Long opening hours
Name of manager
Opening date
Owned (y/n)
Sales floor size group

 

 

Linked Universes
There are no linked universes

 

 

Tables and Columns
 
Table Name - Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma
Table is an alias? - False
Table weight - -1
Column NameTypeKey
agg1_idNumericUnknown
YrCharacterUnknown
QtrCharacterUnknown
MthNumericUnknown
Month_nameCharacterUnknown
WkNumericUnknown
CityCharacterUnknown
Store_nameCharacterUnknown
Sales_revenueNumericUnknown
Quantity_soldNumericUnknown
MarginNumericUnknown
 
Table Name - Agg_yr_qt_rn_st_ln_ca_sr
Table is an alias? - False
Table weight - -1
Column NameTypeKey
agg2_idNumericUnknown
YrCharacterUnknown
QtrCharacterUnknown
StateCharacterUnknown
LineCharacterUnknown
CategoryCharacterUnknown
Sales_revenueNumericUnknown
 
Table Name - Article_Color_Lookup
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Article_color_lookup_idNumericUnknown
Article_idNumericUnknown
Color_codeNumericUnknown
Article_labelCharacterUnknown
Color_labelCharacterUnknown
CategoryCharacterUnknown
Sale_priceNumericUnknown
Family_nameCharacterUnknown
Family_codeCharacterUnknown
 
Table Name - Article_lookup
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Article_idNumericUnknown
Article_labelCharacterUnknown
CategoryCharacterUnknown
Sale_priceNumericUnknown
Family_nameCharacterUnknown
Family_codeCharacterUnknown
 
Table Name - Article_Lookup_Criteria
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Article_lookup_criteria_idNumericUnknown
Article_idNumericUnknown
CriteriaCharacterUnknown
Criteria_typeCharacterUnknown
Criteria_type_labelCharacterUnknown
Criteria_labelCharacterUnknown
 
Table Name - Calendar_year_lookup
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Week_idNumericUnknown
Week_In_YearNumericUnknown
YrCharacterUnknown
Fiscal_PeriodCharacterUnknown
Year_WeekCharacterUnknown
QtrCharacterUnknown
Month_NameCharacterUnknown
MthNumericUnknown
Holiday_FlagCharacterUnknown
 
Table Name - Outlet_Lookup
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Shop_idNumericUnknown
Shop_nameCharacterUnknown
Address_1CharacterUnknown
ManagerCharacterUnknown
Date_openCharacterUnknown
Long_opening_hours_flagCharacterUnknown
Owned_outright_flagCharacterUnknown
Floor_spaceNumericUnknown
Zip_codeNumericUnknown
CityCharacterUnknown
StateCharacterUnknown
 
Table Name - product_promotion_facts
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Product_promotion_facts_idNumericUnknown
Article_idNumericUnknown
Week_idNumericUnknown
DurationNumericUnknown
Promotion_idNumericUnknown
Promotion_costNumericUnknown
 
Table Name - promotion_lookup
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Promotion_idNumericUnknown
Promotion_flagCharacterUnknown
Print_flagCharacterUnknown
Radio_flagCharacterUnknown
Television_flagCharacterUnknown
Direct_mail_flagCharacterUnknown
 
Table Name - Shop_facts
Table is an alias? - False
Table weight - -1
Column NameTypeKey
Shop_facts_idNumericUnknown
Article_idNumericUnknown
Color_codeNumericUnknown
Week_idNumericUnknown
Shop_idNumericUnknown
MarginNumericUnknown
Amount_soldNumericUnknown
Quantity_soldNumericUnknown

 

 

Incompatible Objects
 
Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma
Object - State
Object - Owned (y/n)
Object - Extended sales floor size
Object - Sales floor size sqFt
Object - Sales floor size group
Object - Opening date
Object - Long opening hours
Object - Address
Object - Zip Code
Object - Name of manager
Condition - Owned stores
Condition - Sales floor size?
Condition - Stores with long opening hours
Condition - Sales present
Condition - Sales not present
 
Agg_yr_qt_rn_st_ln_ca_sr
Object - Long opening hours
Object - Extended sales floor size
Object - Sales floor size sqFt
Object - Opening date
Object - Owned (y/n)
Object - Name of manager
Object - Sales floor size group
Object - Store name
Object - Address
Object - Zip Code
Object - Quantity sold
Object - City
Condition - Sales present
Condition - Sales floor size?
Condition - Owned stores
Condition - Stores with long opening hours
Condition - Sales not present
 
Article_Color_Lookup
Object - Extended sales floor size
 
Article_lookup
Object - Extended sales floor size
 
Article_Lookup_Criteria
Object - Extended sales floor size
 
Calendar_year_lookup
Object - Extended sales floor size
 
Outlet_Lookup
This table has no incompatible objects set
 
product_promotion_facts
Object - Sales floor size sqFt
Object - Extended sales floor size
Object - Address
Object - Sales floor size group
Object - Owned (y/n)
Object - Opening date
Object - Name of manager
Object - Long opening hours
Object - Zip Code
Object - City
Object - State
Object - Store name
 
promotion_lookup
Object - Zip Code
Object - State
Object - City
Object - Store name
Object - Address
Object - Long opening hours
Object - Name of manager
Object - Owned (y/n)
Object - Sales floor size group
Object - Sales floor size sqFt
Object - Extended sales floor size
Object - Opening date
 
Shop_facts
This table has no incompatible objects set