课件cognos培训建行c8t-02transer_fundamentals

1、Transformer FundamentalsCognos 8 BIObjectives At the end of this module, you should be able to:discuss the basics of OLAP analysisdiscuss the importance of business requirementsreview Transformer and Cognos 8 BI componentsdefine categories and members Business intelligence helps people to:use corpor

2、ate data to support decision making explore and analyze data to reveal trends within a businessRaw DataOrganized InformationBetter Business DecisionsBusiness IntelligenceQuarterMonthTypeCustomerLineBrandNumberCountryBranchSales RepQuantityCostMarginCombination 1QuarterMonthTypeCustomerLineBrandNumbe

3、rCountryBranchSales RepQuantityCostMarginCombination 2When?Time(2007)Who?Customers(Channels)What?Product(Type)Where?Location(Region)Result?Indicator(Revenue)Comprehensive AnalysisDimensional Analysis ExampleExamine OLAP Data StructuresQ4TimeQ1Q2Q32005Order MethodsFaxDimensionJanFeb.Q1Q2.20052006.Hie

4、rarchy/LevelsStartApril 1EndJune 30AttributesProductsCamping EquipmentMountaineering EquipmentOutdoor ProtectionGolf EquipmentPersonal AccessoriesTelephoneMailE-MailWebMembersCellOLAP Analysis and ReportingPowerCubeUsersBenefits of Transformer Transformer is:easy to customize, flexible, and portable

5、designed for production environments The business requirements impact every aspect of the model and cube. By keeping these requirements at the center of your design, you can better serve the decision- makers in your organization.Business RequirementsDimensional ModelingTechnical Architecture DesignP

6、hysical DesignData Staging DesignEnd-User Application SpecificationDeploymentPlanningMaintenance and GrowthProject Planning and ManagementBusiness RequirementsWhat is a Model?Model Types Transformer can save models as the following two types of files:.mdl - a model stored in ASCII file format is a s

7、maller size, compatible between versions of Transformer, and can be used for find and replace activities.pyj - a model stored in binary file format is a larger size, version-specific, and quicker to load1. Import your data sourceDo I have the data that meets my needs and my users needs?2. Create and

8、 examine your measuresDo they reflect how you measure the performance of your business?3. Create and examine your dimensions and levelsDo they allow effective data analysis?4. Create and test your PowerCubesDoes it provide the right information in a way that is easy to understand and work with?From

9、Model to PowerCube a structure that stores data dimensionally and provides:secure data accessfast retrieval of data can be distributed across a network or to individual computers.What is a PowerCube?Measures A measure can:provide quantifiable results that gauge the success of your businessaddress pr

10、imarily numeric questionsadd perspective to your dataTimeProductsRegionsYearsQuartersMonthsProduct lineProduct typeProduct nameRegionCountryCityDim 1Dim 2Dim 3Dim 4Dim 5EmployeeQuestion tobe answeredWhen WhatWhereWhoHowDimensionsLevelsWhat are Dimensions and Levels?When WhatWhereWhoHowTimeRegionsRet

11、ailer typesMargin RangesProductsDim 1Dim 2Dim 3Dim 4Dim 5DimensionYearsQuartersMonthsProduct lineProducttypeProduct NameRegionsCountryCityRetailer typeMargin RangeEmployeeLevels2134Additional DimensionsNorthern EuropeSwedenKistaCategories/Members:NorwayDenmarkFinlandLevel:RegionLevel:CountryLevel:City Category/Member:Categories/Members In Transformer, categories are individual data items that populate a level in a dimension. In Cognos 8, these items are called members. Category/Member:Summary At the end of this m