Document Name - EFASHION

Contents

Document Properties

Document Reports


Data Providers

Actual

Budget


DocumentVariables

Variables


Document Properties 
Document PathD:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\EFASHION.REP
Document AuthorBusiness Objects
Document Keywords
Document Comments
Document Title
Document Subject
Document Last Saved Date09/09/1999 18:14:42
Document Last Print Date
Document Contains Partial Results?False
Auto Refresh on Opening?False
Document is an Add-in?False

Document Reports  
Report NameNumber of Pages Is Drillable?
Revenue Year 20012False
Revenue by Region1False
Margin Analysis2False
Quarterly Variance2False
Product Analysis1False
Actual v Budget1False

Data Providers 2


Actual

Data Provider

Actual

Last Refresh Date23/02/1999 12:53:11
Data Provider TypeQuery Technique (Universe)
Data Provider IsEditable?True
Data Provider IsRefreshable?True
Data Provider Number of Cubes1
Number of rows in the dataprovider482
Data Provider Universe NameeFashion
Duplicate Rows?True
DeleteTrailingBlanks?False


Data Provider SQL
SELECT
  
Outlet_Lookup.City,
  
sum(Shop_facts.Amount_sold),
  
sum(Shop_facts.Quantity_sold),
  
{fn concat('Q',Calendar_year_lookup.Quarter)},
  
Article_lookup.Family_name,
  
sum(Shop_facts.Margin)
FROM
  Shop_facts,
  Outlet_Lookup,
  Calendar_year_lookup,
  Article_lookup
WHERE
  ( Shop_facts.Shop_code=Outlet_Lookup.Shop_code  )
  AND  ( Article_lookup.Article_code=Shop_facts.Article_code  )
  AND  ( Shop_facts.Week_key=Calendar_year_lookup.Week_Key  )
  AND  (
  ( Calendar_year_lookup.Year= '2001'  )
  )
GROUP BY
  
Outlet_Lookup.City, 
  
{fn concat('Q',Calendar_year_lookup.Quarter)}, 
  
Article_lookup.Family_name

Queries



Query NameActual
Query operatorNone
  
Result Objects
Store/City
Measures/Sales revenue
Measures/Quantity sold
Time period/Quarter
Product/Lines
Measures/Margin
 
Condition Objects
Conditions Format (#1)
Condition #1 Time period/This year

Budget

Data Provider

Budget

Last Refresh Date12/02/1999 14:52:36
Data Provider TypePersonal Text File
Data Provider IsEditable?True
Data Provider IsRefreshable?True
Data Provider Number of Cubes1
Number of rows in the dataprovider12
Data Provider Universe NameNot Applicable
Duplicate Rows?Not Applicable
DeleteTrailingBlanks?Not Applicable<


Data Provider SQL


 Only available with universe dataproviders








DocumentVariables




Document Document Variables

Variable NameObjectFormulaType of object


Average marginMeasure=Average(<Margin as % rev> In  Body) In ReportUser object


CityDimension=<City>Data Provider Object


LinesDimension=<Lines>Data Provider Object


MarginMeasure=<Margin>Data Provider Object


Margin as % revMeasure=(<Margin>/<Sales revenue>)*100%User object


Month Dimension=<Month >Data Provider Object


Projected Sales RevenueMeasure=<Projected Sales Revenue>Data Provider Object


Quantity soldMeasure=<Quantity sold>Data Provider Object


Quarter(Actual)Dimension=<Quarter(Actual)>Data Provider Object


Quarter(Budget)Dimension=<Quarter(Budget)>Data Provider Object


RegionDimension= If (<City> InList( "Chicago" , "Colorado Springs") ) Then("Midwest") Else If (<City> InList( "Austin" , "Dallas" , "Houston" , "Miami") ) Then("South") Else If (<City> InList( "Boston" , "New York" , "Washington") ) Then("East") Else If (<City> InList( "Los Angeles" , "San Francisco") ) Then("West") Else " " User object


Sales revenueMeasure=<Sales revenue>Data Provider Object


Formula Measure=(<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q1") - (<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q2")User object


Formula Measure=(<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q2") - (<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q1")User object


Formula Measure=(<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q4") - (<Margin>/<Quantity sold>) Where (<Quarter(Actual)>="Q3")User object


Formula Measure=(<Margin>/<Sales revenue>)*100%User object


Formula Measure=<Margin as % rev> Where (<Quarter(Actual)>="Q1") - <Margin as % rev> Where (<Quarter(Actual)>="Q2")User object


Formula Measure=<Margin as % rev> Where (<Quarter(Actual)>="Q2") - <Margin as % rev> Where (<Quarter(Actual)>="Q1")User object


Formula Measure=<Margin as % rev> Where (<Quarter(Actual)>="Q4") - <Margin as % rev> Where (<Quarter(Actual)>="Q3")User object


Formula Measure=<Margin> Where (<Quarter(Actual)>="Q1") - <Margin> Where (<Quarter(Actual)>="Q2")User object


Formula Measure=<Margin> Where (<Quarter(Actual)>="Q2") - <Margin> Where (<Quarter(Actual)>="Q1")User object


Formula Measure=<Margin> Where (<Quarter(Actual)>="Q4") - <Margin> Where (<Quarter(Actual)>="Q3")User object


Formula Measure=<Margin>/<Quantity sold>User object


Formula Measure=<Quantity sold> Where (<Quarter(Actual)>="Q1") - <Quantity sold> Where (<Quarter(Actual)>="Q2")User object


Formula Measure=<Quantity sold> Where (<Quarter(Actual)>="Q2") - <Quantity sold> Where (<Quarter(Actual)>="Q1")User object


Formula Measure=<Quantity sold> Where (<Quarter(Actual)>="Q4") - <Quantity sold> Where (<Quarter(Actual)>="Q3")User object


Formula Measure=<Quantity sold>/Sum(<Quantity sold>)User object


Formula Measure=<Quantity sold>/Sum(<Quantity sold>) ForAll <Lines>User object


Formula Measure=<Quantity sold>/Sum(<Quantity sold>) ForAll <Quarter(Actual)>User object


Formula Measure=<Sales revenue> Where (<Quarter(Actual)>="Q1") - <Sales revenue> Where (<Quarter(Actual)>="Q2")User object


Formula Measure=<Sales revenue> Where (<Quarter(Actual)>="Q2") - <Sales revenue> Where (<Quarter(Actual)>="Q1")User object


Formula Measure=<Sales revenue> Where (<Quarter(Actual)>="Q4") - <Sales revenue> Where (<Quarter(Actual)>="Q3")User object


Formula Measure=Average(<Margin as % rev>)User object


Formula Detail=CurrentDate()User object


Formula Detail=GlobalFilters("")User object


Formula Detail=NameOf(<City>)User object


Formula Detail=NameOf(<Lines>)User object


Formula Detail=NameOf(<Margin as % rev>)User object


Formula Detail=NameOf(<Margin>)User object


Formula Detail=NameOf(<Projected Sales Revenue>)User object


Formula Detail=NameOf(<Quantity sold>)User object


Formula Detail=NameOf(<Quarter(Actual)>)User object


Formula Detail=NameOf(<Quarter(Budget)>)User object


Formula Detail=NameOf(<Sales revenue>)User object


Formula Detail=Page()User object


Formula Measure=Sum(<Margin>)User object


Formula Measure=Sum(<Projected Sales Revenue>)User object


Formula Measure=Sum(<Quantity sold>)User object


Formula Measure=Sum(<Sales revenue>)User object


Constant Detail<add comment>User object


Constant Detail<Title>User object


Constant DetailActual - BudgetUser object


Constant DetailAverage:User object


Constant DetailC:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\Efashion.bmpUser object


Constant DetailC:\WINDOWS\DESKTOP\efash demo\e-fashion logo.bmpUser object


Constant Detailfor  year  2001User object


Constant Detailfor year 2001User object


Constant DetailMagin as % revenueUser object


Constant DetailMarginUser object


Constant DetailmarginUser object


Constant DetailMargin per CityUser object


Constant DetailMargin per unitUser object


Constant DetailPercent:User object


Constant DetailPercentageUser object


Constant DetailProduct Sales by CityUser object


Constant DetailQ1-Q2User object


Constant DetailQ2-Q1User object


Constant DetailQ4-Q3User object


Constant DetailQuarterly VarianceUser object


Constant DetailReport TitleUser object


Constant DetailRevenue for Year 2001User object


Constant Detailsales revenueUser object


Constant DetailSales revenueUser object


Constant DetailSum:User object


Constant DetailTop three product linesUser object


Constant DetailTop Three Product LinesUser object








Variables

There are no Document Variables in this document.