OracleBIPublishBestPractice-甲骨文BIPublish最佳实践-培训

Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.1Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.2OracleBIPublisherBestPracticesRupeshVarmaPrincipalProductManagerCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.3Thefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecision.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedfororacle'sproductsremainsatthesolediscretionoforacle.Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.4ProgramAgendaOracleBIPublisherEnterpriseOverviewReportDesignBestPractices–DataModelingGuidelines–TemplateDesignGuidelines–ReportingGuidelinesQ&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.5OracleBIPublisherEnterpriseOneEnvironment–Author–Generate–DeliverBenefits–Eliminatecomplexity–Simplifyreportdevelopment&maintenance–ReducecostsEliminateMultiple-pointSolutionsReportsChecksLabelsDestinationsInvoicesXML/EFT/EDICopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.6LayoutTemplateTypesOutputFormatsDestinationsEmailPrinterFaxe-CommerceRepositoryDataSourcesLayoutDesignToolsWebServicesOracle,OracleBIEE,OracleBIAppsSQLServerE-BusinessSuite,PeopleSoft,Siebel,JDE,PrimaveraOLAPOracleBIPublisherEnterpriseFromDatatoDocumenttoDelivery•LayoutEditor•MSWord•MSExcel•Adobe•Flex•XSLXSLXMLEDIEFTPDFHTMLExcelPPTCSVFlashRTFInteractiveCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.7ArchitectureBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.8OracleBusinessIntelligencePublisherSeparatedatalogic,layout&translationbenefits–greaterflexibilityandreuse–fewerreportsandbetterreportmaintenance–optimizedataextractionanddocumentgenerationprocessReportArchitectureReportoutputDataLogicLayoutTranslationBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.9OracleBIPublisherScheduler11gBIPublisherWebserverBIPublisherWebserverBIPublisherReportsRepositoryClientClientSchedulerdatabaseJMSResourcesEmailPrinterFaxRepositoryFilesystemFAXQ.PrinterQ.EmailQ.FTPQ.WebDavQ.FileQ.JobQReportQBIPSystemTopicWebserver/JMSProvider(WebLogic,ActiveMQ)Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.10ProgramAgendaOracleBIPublisherEnterpriseOverviewReportDesignBestPractices–DataModelingGuidelines–TemplateDesignGuidelinesQ&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.11DataGeneration•DataSourceTypes–File(XML)–SQLQuery–MDXQuery–LDAPQuery–ExcelSpreadsheet–HTTP(XMLFeed)–WebService–OracleBIAnalysisDataSourcesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.12DataGenerationJDBCVsJNDI(SQLType)BothtypesofconnectionusethesameJDBCdriverWithJNDIyoucantakeadvantageofconnectionpooling–BetterperformanceConnectionalreadyestablishedtothesourceBestpracticeforreportswithmanyparameterswithSQLtypeLOVsattachedtothem–BetterRDBMSresourcemanagementConnectionTypes21WebLogicServerBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.13DataGenerationEnableforlargereports–Slowerperformance,butpreventsout-of-memoryerrors–UsewithscheduledreportsScalableModeCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.14DataModelDesignOptimizedataextractionSimplifylayoutdesignforreportdevelopersReducedocumentgenerationtimeObjectivesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.15DataModelDesignLeverageback-endsystemresources(whenpossible)–Joindata–Filter&groupdata–Performexpensivecalculations&datatransformations–SortdataConsidergoingagainstBIServerinsteadofextractingdatadirectlyfromthesourcesystemsUseBIServerLogicalSQLinsteadofAnswers/AnalysisDataExtractionSelectt.OFFICE_DSCasOfficesum(f.REVENUE)as“SalesSumFromBISAMPLE.SAMP_REVENUE_F“fBISAMPLE.SAMP_OFFICES_D“tWheret.OFFICE_KEY=f.OFFICE_KEYgroupbyt.OFFICE_DSC20Vs20,000recordsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.16DataModelDesignParameters&LOVs–CacheLOVSforbetterperformance–ForlargeLOVs,passNULLtotheparameterwhenusersselectAll&modifyWHEREclauseinDataSetquerytousetheNVLfunction.Forexample:“Whereorder_id=nvl(:p_ordid,order_id)”DataExtractionCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.17DataModelDesignEventtriggersBeforeDataTriggers–GeneratedynamicSQL–PopulateTEMPtables–SetusercontextAfterDataTriggers–Insertrowstoatargettable–Sendnotifications–CleanordeleteTEMPtablesDataExtractionSelectEMPLOYEE_ID,DEPARTMENT_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARYfromemployeeswhere&p_where_clauseCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.18DataModelDesignStructuredata–tomatchhowdataisdisplayedinthereportUseshortXMLtagnames–theyreducethesizeofXMLdatafileUsedisplaynames–tosimplifytemplatedesignCreateglobal&group-levelaggregatefunctions–forbestperformance,createthemindatamodelinsteadofreportlayoutPre-sortdataNote:Groupingdataindatamodelautomaticallysortsdatabythegroupingeleme