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

Classes and Objects Listing
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	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	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	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