Powered by InfoCaptor


Parameters
NoParameterValue
1Date/TimeReport generated on 05-APR-2007 02:32:18
2EUL OwnerALL Values
3EUL PrefixEUL5
4Workbook CreatorALL Values
5BA CreatorALL Values
Version
Version
5.1.1.0.0.0
Business Areas
Business AreaKeyCreatorCreated ByCreation DateUpdated ByLast Update DateNumber Of Times ModifiedBa Id
Video Store TutorialVIDEO_STORE_TUTORIALSYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100018
Discoverer V5 - OWB LineageOWB_EUL5_LINEAGESYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100568
The Discoverer V5 EULTHE_DISCOVERER_V5_EULSYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100570
Video Store Tutorial
Folders
FolderFolder HiddenFolder TypeDescriptionFolder KeyLast UpdatedFolder Id
Alternate Sort DaysHiddenCustomAlternate Sort DaysDC_ALTERNATE_SORT_DAYS25-Oct-2006100033
Alternate Sort Store SizeHiddenCustomAlternate Sort Store SizeDC_ALTERNATE_SORT_STORE_SIZE25-Oct-2006100035
Calendar DateVisibleSimpleCalendar DatesDC_CALENDAR_DATE25-Oct-2006100024
Fiscal DateVisibleSimpleFiscal DatesDC_FISCAL_DATE25-Oct-2006100025
Monthly Sales AnalysisVisibleComplexMonthly Sales AnalysisDC_MONTHLY_SALES_ANALYSIS25-Oct-2006100030
ProductsVisibleSimpleInformation about productsDC_PRODUCT25-Oct-2006100026
Sales FactsVisibleSimpleSales Fact Information DC_SALES_FACT25-Oct-2006100027
StoreVisibleSimpleInformation about storesDC_STORE25-Oct-2006100028
Stores and Sales DetailsVisibleComplexThis folder groups together store and sales detailsDC_STORE_AND_SALES_DETAILS25-Oct-2006100031
Target SalesVisibleSimpleTarget Sales InformationDC_TARGET_SALES25-Oct-2006100029
Video Analysis InformationVisibleComplexThis folder contains commonly used reporting itemsDC_VIDEO_ANALYSIS_INFORMATION25-Oct-2006100032
Alternate Sort Days
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Sort Alternate Sort Days.Alternate SortALTERNATE_SORTALTERNATE_SORT100086
Day Of Week Alternate Sort Days.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100094
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Alternate Sort Store Size
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Sort Alternate Sort Store Size.Alternate SortALTERNATE_SORTALTERNATE_SORT100087
Store Size Alternate Sort Store Size.Store SizeSTORE_SIZESTORE_SIZE100113
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Calendar Date
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.TIMES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Calendar DayDay in MonthCalendar Date.Transaction Date TRANSACTION_DATE_DAY100184
Calendar MonthMonth in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_MONTH100186
Calendar QuarterQuarter in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_QUARTER100194
Calendar YearYear transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_YEAR100200
Day Of Week Calendar Date.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100092
Holiday Flag Calendar Date.Holiday FlagHOLIDAY_FLAGHOLIDAY_FLAG100099
Time Key Calendar Date.Time KeyTIME_KEYTIME_KEY100115
Transaction DateDate transactions took placeCalendar Date.Transaction DateTRANSACTION_DATETRANSACTION_DATE100119
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Calendar Date.Time Key -> Sales Facts.Time KeyCalendar Date.Time Key = Sales Facts.Time KeyAlways exist in master folderNoneYes
Calendar Date.Time Key -> Target Sales.Time KeyCalendar Date.Time Key = Target Sales.Time KeyAlways exist in master folderNoneYes
Fiscal Date
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneVIDEO5.TIMES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Day Of Week Fiscal Date.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100093
Fiscal Date Fiscal Date.Transaction Date FISCAL_DATE100138
Fiscal MonthFiscal month in year that transactions took placeFiscal Date.Transaction Date FISCAL_MONTH100140
Fiscal QuarterFiscal quarter in year that transactions took placeFiscal Date.Transaction Date FISCAL_QUARTER100142
Fiscal YearFiscal year transactions took placeFiscal Date.Transaction Date FISCAL_YEAR100144
Holiday Flag Fiscal Date.Holiday FlagHOLIDAY_FLAGHOLIDAY_FLAG100100
Time Key Fiscal Date.Time KeyTIME_KEYTIME_KEY100116
Transaction DateDate transactions took placeFiscal Date.Transaction DateTRANSACTION_DATETRANSACTION_DATE100120
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Fiscal Date.Time Key -> Sales Facts.Time KeyFiscal Date.Time Key = Sales Facts.Time KeyAlways exist in master folderNoneYes
Fiscal Date.Time Key -> Target Sales.Time KeyFiscal Date.Time Key = Target Sales.Time KeyAlways exist in master folderNoneYes
Monthly Sales Analysis
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneVideo Analysis Information, Calendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMESection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100134
AUTO_GENERATED_NAME 1Sales region e.g. East, West, CentralStore.Region REGION100158
AUTO_GENERATED_NAME 2City location of storeStore.City CITY100126
AUTO_GENERATED_NAME 3Name of StoreStore.Store Name STORE_NAME100178
AUTO_GENERATED_NAME 4Year transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_YEAR100217
AUTO_GENERATED_NAME 5Quarter in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_QUARTER100198
AUTO_GENERATED_NAME 6Month in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_MONTH100192
Average Monthly Sales per Store Sales Facts.Sales AVERAGE_MONTHLY_SALES_PER_STORE100169
Monthly Sales per StoreTotal sales for one store, one product in one daySales Facts.Sales SALES100167
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Products
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.PRODUCT25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Age Category Products.Age CategoryAGE_CATEGORYAGE_CATEGORY100085
Brand Products.BrandBRANDBRAND100088
DepartmentSection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.DepartmentDEPARTMENTDEPARTMENT100095
Full DescriptionExample of Product e.g. Video ClipProducts.Full DescriptionFULL_DESCRIPTIONFULL_DESCRIPTION100098
Product CategoryTheme under product type e.g. Action, Drama, Thriller, Sci-FiProducts.Product CategoryPRODUCT_CATEGORYPRODUCT_CATEGORY100101
Product DescriptionDescriptions e.g. Titles of Movies, Video Game TitlesProducts.Product DescriptionDESCRIPTIONDESCRIPTION100096
Product Key Products.Product KeyPRODUCT_KEYPRODUCT_KEY100102
Product Type Products.Product TypePRODUCT_TYPEPRODUCT_TYPE100104
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Products.Product Key -> Sales Facts.Product KeyProducts.Product Key = Sales Facts.Product KeyAlways exist in master folderNoneYes
Sales Facts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.SALES_FACT25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CostTotal cost for one store, one product in one daySales Facts.CostCOSTCOST100090
Customer Count Sales Facts.Customer CountCUSTOMER_COUNTCUSTOMER_COUNT100091
Product Key Sales Facts.Product KeyPRODUCT_KEYPRODUCT_KEY100103
ProfitTotal profit for one store, one product in one daySales Facts.ProfitPROFITPROFIT100105
SalesTotal sales for one store, one product in one daySales Facts.SalesSALESSALES100108
Store Key Sales Facts.Store KeySTORE_KEYSTORE_KEY100109
Time Key Sales Facts.Time KeyTIME_KEYTIME_KEY100117
Unit SalesVolume of product moved for one store, one product in one daySales Facts.Unit SalesUNIT_SALESUNIT_SALES100121
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Store
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.STORE25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CityCity location of storeStore.CityCITYCITY100089
Floor Plan Typee.g. Modern, Compact, OriginalStore.Floor Plan TypeFLOOR_PLAN_TYPEFLOOR_PLAN_TYPE100097
RegionSales region e.g. East, West, CentralStore.RegionREGIONREGION100106
ReportsThree months goals for storesStore.ReportsREPORTSREPORTS100107
Store Key Store.Store KeySTORE_KEYSTORE_KEY100110
Store NameName of StoreStore.Store NameSTORE_NAMESTORE_NAME100111
Store SizeTotal square footage of storeStore.Store SizeSTORE_SIZESTORE_SIZE100112
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Store.Store Key -> Sales Facts.Store KeyStore.Store Key = Sales Facts.Store KeyAlways exist in master folderNoneYes
Stores and Sales Details
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneCalendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMEName of StoreStore.Store Name STORE_NAME100174
AUTO_GENERATED_NAME 1City location of storeStore.City CITY100122
AUTO_GENERATED_NAME 10Year transactions took placeCalendar Date.Transaction Date CALENDAR_YEAR100202
AUTO_GENERATED_NAME 11Month in year that transactions took placeCalendar Date.Transaction Date CALENDAR_MONTH100188
AUTO_GENERATED_NAME 12Total profit for one store, one product in one daySales Facts.Profit PROFIT100152
AUTO_GENERATED_NAME 2Three months goals for storesStore.Reports REPORTS100160
AUTO_GENERATED_NAME 3e.g. Modern, Compact, OriginalStore.Floor Plan Type FLOOR_PLAN_TYPE100146
AUTO_GENERATED_NAME 4Total square footage of storeStore.Store Size STORE_SIZE100180
AUTO_GENERATED_NAME 5Descriptions e.g. Titles of Movies, Video Game TitlesProducts.Product Description DESCRIPTION100136
AUTO_GENERATED_NAME 6Example of Product e.g. Video ClipProducts.Full Description FULL_DESCRIPTION100148
AUTO_GENERATED_NAME 7Section of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100130
AUTO_GENERATED_NAME 8Theme under product type e.g. Action, Drama, Thriller, Sci-FiProducts.Product Category PRODUCT_CATEGORY100150
AUTO_GENERATED_NAME 9Date transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE100182
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Target Sales
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneVIDEO5.TARGET_SALES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Target SalesTarget sales figuresTarget Sales.Target SalesTARGET_SALESTARGET_SALES100114
Time Key Target Sales.Time KeyTIME_KEYTIME_KEY100118
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Video Analysis Information
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Monthly Sales AnalysisCalendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMESection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100132
AUTO_GENERATED_NAME 1Sales region e.g. East, West, CentralStore.Region REGION100156
AUTO_GENERATED_NAME 10Total cost for one store, one product in one daySales Facts.Cost COST100128
AUTO_GENERATED_NAME 2City location of storeStore.City CITY100124
AUTO_GENERATED_NAME 3Name of StoreStore.Store Name STORE_NAME100176
AUTO_GENERATED_NAME 4Year transactions took placeCalendar Date.Transaction Date CALENDAR_YEAR100204
AUTO_GENERATED_NAME 5Quarter in year that transactions took placeCalendar Date.Transaction Date CALENDAR_QUARTER100196
AUTO_GENERATED_NAME 6Month in year that transactions took placeCalendar Date.Transaction Date CALENDAR_MONTH100190
AUTO_GENERATED_NAME 7Total profit for one store, one product in one daySales Facts.Profit PROFIT100154
AUTO_GENERATED_NAME 8Total sales for one store, one product in one daySales Facts.Sales SALES100162
AUTO_GENERATED_NAME 9Volume of product moved for one store, one product in one daySales Facts.Unit Sales UNIT_SALES100219
Margin Percentage Sales Facts.Profit Sales Facts.Sales MARGIN_PERCENTAGE100164
Rank Sales by Year, Dept, RegionThe rank of sales by year, department and regionCalendar Date.Transaction Date Products.Department Store.Region Sales Facts.Sales RANK_SALES_PARTITION_BY_YEAR__REGION100206
Sales BandA grouping of individual sales into rangesSales Facts.Sales SALES_BAND100171
Sales Last YearThe sales for last year based on department, region and city.Sales Facts.Sales Products.Department Store.Region Store.City Calendar Date.Transaction Date SALES_LAST_YR100211
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
DepartmentVideo Store TutorialVIDEO5.PRODUCT.DEPARTMENTDepartment is Video Rental or Video SaleOptionalVideo Analysis Information
Calendar YearVideo Store TutorialVIDEO5.TIMES.TRANSACTION_DATEYear is 1998 or 1999OptionalVideo Analysis Information
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
Calendar Date HierarchySystem1Calendar Date.Calendar Year
Calendar Date HierarchySystem2 ^------Calendar Date.Calendar Quarter
Calendar Date HierarchySystem3 ^------Calendar Date.Calendar Month
Calendar Date HierarchySystem4 ^------Calendar Date.Calendar Day
Calendar Date HierarchySystem5 ^------Calendar Date.Transaction Date
Fiscal Calendar HierarchyUser1Fiscal Date.Fiscal Year
Fiscal Calendar HierarchyUser2 ^------Fiscal Date.Fiscal Quarter
Fiscal Calendar HierarchyUser3 ^------Fiscal Date.Fiscal Month
Fiscal Calendar HierarchyUser4 ^------Fiscal Date.Transaction Date
Monthly Sales Analysis Calendar Time HierarchyUser1Monthly Sales Analysis.Calendar Year
Monthly Sales Analysis Calendar Time HierarchyUser2 ^------Monthly Sales Analysis.Calendar Quarter
Monthly Sales Analysis Calendar Time HierarchyUser3 ^------Monthly Sales Analysis.Calendar Month
Monthly Sales Analysis Store HierarchyUser1Monthly Sales Analysis.Region
Monthly Sales Analysis Store HierarchyUser2 ^------Monthly Sales Analysis.City
Monthly Sales Analysis Store HierarchyUser3 ^------Monthly Sales Analysis.Store Name
Product HierarchyUser1Products.Product Type
Product HierarchyUser2 ^------Products.Department
Product HierarchyUser3 ^------Products.Product Category
Product HierarchyUser4 ^------Products.Product Description
Store HierarchyUser1Store.Region
Store HierarchyUser2 ^------Store.City
Store HierarchyUser3 ^------Store.Store Name
Video Analysis Calendar Time HierarchyUser1Video Analysis Information.Calendar Year
Video Analysis Calendar Time HierarchyUser2 ^------Video Analysis Information.Calendar Quarter
Video Analysis Calendar Time HierarchyUser3 ^------Video Analysis Information.Calendar Month
Video Analysis Store HierarchyUser1Video Analysis Information.Region
Video Analysis Store HierarchyUser2 ^------Video Analysis Information.City
Video Analysis Store HierarchyUser3 ^------Video Analysis Information.Store Name
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
Alternate Sort Days.Day Of WeekAlternate Sort Days . Day Of WeekCalendar Date . Day Of WeekAlternate Sort Days.Alternate Sort
Alternate Sort Days.Day Of WeekAlternate Sort Days . Day Of WeekFiscal Date . Day Of WeekAlternate Sort Days.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeAlternate Sort Store Size . Store SizeAlternate Sort Store Size.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeStore . Store SizeAlternate Sort Store Size.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeStores and Sales Details . Store SizeAlternate Sort Store Size.Alternate Sort
Calendar Date.Calendar DayCalendar Date . Calendar DayCalendar Date . Calendar Day.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthCalendar Date . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthMonthly Sales Analysis . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthStores and Sales Details . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthVideo Analysis Information . Calendar Month.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterCalendar Date . Calendar Quarter.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterMonthly Sales Analysis . Calendar Quarter.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterVideo Analysis Information . Calendar Quarter.
Calendar Date.Calendar YearCalendar Date . Calendar YearCalendar Date . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearMonthly Sales Analysis . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearStores and Sales Details . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearVideo Analysis Information . Calendar Year.
Calendar Date.Holiday FlagCalendar Date . Holiday FlagCalendar Date . Holiday Flag.
Calendar Date.Transaction DateCalendar Date . Transaction DateCalendar Date . Transaction Date.
Calendar Date.Transaction DateCalendar Date . Transaction DateStores and Sales Details . Transaction Date.
Fiscal Date.Fiscal DateFiscal Date . Fiscal DateFiscal Date . Fiscal Date.
Fiscal Date.Fiscal MonthFiscal Date . Fiscal MonthFiscal Date . Fiscal Month.
Fiscal Date.Fiscal QuarterFiscal Date . Fiscal QuarterFiscal Date . Fiscal Quarter.
Fiscal Date.Fiscal YearFiscal Date . Fiscal YearFiscal Date . Fiscal Year.
Fiscal Date.Holiday FlagFiscal Date . Holiday FlagFiscal Date . Holiday Flag.
Fiscal Date.Transaction DateFiscal Date . Transaction DateFiscal Date . Transaction Date.
Products.Age CategoryProducts . Age CategoryProducts . Age Category.
Products.BrandProducts . BrandProducts . Brand.
Products.DepartmentProducts . DepartmentMonthly Sales Analysis . Department.
Products.DepartmentProducts . DepartmentProducts . Department.
Products.DepartmentProducts . DepartmentStores and Sales Details . Department.
Products.DepartmentProducts . DepartmentVideo Analysis Information . Department.
Products.Full DescriptionProducts . Full DescriptionProducts . Full Description.
Products.Full DescriptionProducts . Full DescriptionStores and Sales Details . Full Description.
Products.Product CategoryProducts . Product CategoryProducts . Product Category.
Products.Product CategoryProducts . Product CategoryStores and Sales Details . Product Category.
Products.Product DescriptionProducts . Product DescriptionProducts . Product Description.
Products.Product DescriptionProducts . Product DescriptionStores and Sales Details . Product Description.
Products.Product TypeProducts . Product TypeProducts . Product Type.
Store.CityStore . CityMonthly Sales Analysis . City.
Store.CityStore . CityStore . City.
Store.CityStore . CityStores and Sales Details . City.
Store.CityStore . CityVideo Analysis Information . City.
Store.Floor Plan TypeStore . Floor Plan TypeStore . Floor Plan Type.
Store.Floor Plan TypeStore . Floor Plan TypeStores and Sales Details . Floor Plan Type.
Store.RegionStore . RegionMonthly Sales Analysis . Region.
Store.RegionStore . RegionStore . Region.
Store.RegionStore . RegionVideo Analysis Information . Region.
Store.ReportsStore . ReportsStore . Reports.
Store.ReportsStore . ReportsStores and Sales Details . Reports.
Store.Store KeyStore . Store KeyStore . Store Key.
Store.Store NameStore . Store NameMonthly Sales Analysis . Store Name.
Store.Store NameStore . Store NameStore . Store Name.
Store.Store NameStore . Store NameStores and Sales Details . Store Name.
Store.Store NameStore . Store NameVideo Analysis Information . Store Name.
Security
Administration AllowedUser Role Responsibility
YesSYSTEM
NoVIDEO5
NoPUBLIC
Summaries
Summary Set NameOwnerTable NameTable ColumnMap ToFolder NameAggregationItem Name
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCITYMaps To ===>Video Store TutorialAxis ItemCity
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_MONMaps To ===>Video Store TutorialAxis ItemCalendar Month
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSTORE_NAMEMaps To ===>Video Store TutorialAxis ItemStore Name
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_QTRMaps To ===>Video Store TutorialAxis ItemCalendar Quarter
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_QTRMaps To ===>Video Store TutorialAxis ItemCalendar Quarter
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_MONMaps To ===>Video Store TutorialAxis ItemCalendar Month
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSTORE_NAMEMaps To ===>Video Store TutorialAxis ItemStore Name
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCITYMaps To ===>Video Store TutorialAxis ItemCity
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCOST_SUMMaps To ===>Video Store TutorialSumCost
Discoverer V5 - OWB Lineage
Folders
FolderFolder HiddenFolder TypeDescriptionFolder KeyLast UpdatedFolder Id
EUL5 Business Areas & FoldersVisibleComplex EUL5_BA_FOLDERS25-Oct-2006100627
EUL5 Folders & ItemsVisibleComplex EUL5_FOLDERS_ITEMS25-Oct-2006100630
Eul5 Ba Obj LinksVisibleSimple EUL5_BA_OBJ_LINKS25-Oct-2006100582
Eul5 BasVisibleSimple EUL5_BAS25-Oct-2006100577
Eul5 ExpressionsVisibleSimple EUL5_EXPRESSIONS25-Oct-2006100592
Eul5 ObjsVisibleSimple EUL5_OBJS25-Oct-2006100607
EUL5 Business Areas & Folders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Conditions.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Folders & Items.Folder IdMight not exist in master folderOuter join on master Yes
EUL5 Business Areas & Folders.Business Area Id -> EUL5 Security.Gba Ba IdEUL5 Business Areas & Folders.Business Area Id = EUL5 Security.Gba Ba IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Summary Mappings.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Summary Mappings.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Joins.Master Folder IdAlways exist in master folderNoneYes
EUL5 Folders & Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Folders & Items.Item Id -> EUL5 Item Classes.Exp IdEUL5 Folders & Items.Item Id = EUL5 Item Classes.Exp IdAlways exist in master folderNoneYes
EUL5 Folders & Items.Item Id -> EUL5 Hierarchy.Hil Exp IdEUL5 Folders & Items.Item Id = EUL5 Hierarchy.Hil Exp IdAlways exist in master folderNoneYes
Eul5 Ba Obj Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas.Ba Id -> Eul5 Access Privs.Gba Ba IdEul5 Bas.Ba Id = Eul5 Access Privs.Gba Ba IdAlways exist in master folderNoneYes
Eul5 Bas.Ba Id -> Eul5 Ba Obj Links.Bol Ba IdEul5 Bas.Ba Id = Eul5 Ba Obj Links.Bol Ba IdMight not exist in master folderOuter join on master Yes
Eul5 Bas.Ba Id -> Eul5 Objs.Obj Ba IdEul5 Bas.Ba Id = Eul5 Objs.Obj Ba IdAlways exist in master folderNoneYes
Eul5 Expressions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto<