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

Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›1OracleBIPublisherBestPracticesRupeshVarmaPrincipalProductManagerCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›2Thefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecision.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedfororacle'sproductsremainsatthesolediscretionoforacle.Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›3Oracle’sSafeharborstatementInthispresentationwearenotdiscussinganynewfeatures.ProgramAgendaOracleBIPublisherEnterpriseOverviewReportDesignBestPracticesDataModelingGuidelinesTemplateDesignGuidelinesReportingGuidelinesQ&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›4Agenda--Quickoverview–pollaudience--Talkaboutdeployment&systemrequirements--YouwillfindseveralslideswithsomeusefulinformationaboutconfigurationoptionsintheAppendixofthispresentation.--TalkaboutReportDesignBestPractices(guidelines/recommendationsfordatamodel&templatedesign)--Deployment&Systemrequirementapplytothestandalone(EnterpriseversionofBIP)--RTFtemplatedesignguidelines/recommendations/bestpracticesareapplicableacrosstheboard(EBS,PSFT,SiebelandotherOracleproductsthatintegratewithBIPublisherstandaloneusingWebservices(orembedourtechnology).--WewilltrytoleavetimeforQ&Aattheend,butfeelfreetoaskquestionsaswegoOracleBIPublisherEnterpriseOneEnvironmentAuthorGenerateDeliverBenefitsEliminatecomplexitySimplifyreportdevelopment&maintenanceReducecostsEliminateMultiple-pointSolutionsReportsChecksLabelsDestinationsInvoicesXML/EFT/EDICopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›BIPublisherisOracle’sstrategicproductofferingforpixel-perfect,printerquality,high-volumereporting.Youcanuseittogenerateallyourbusinessdocuments:invoices,purchaseorders,billingstatements,financialstatements,EFTdocuments,governmentforms,marketingcollateralsandallothertypeofcustomerfacingdocuments.Youcanalsouseittocreatemanagementtypereportsthataresuitableforonlineviewing.KeyBenefits===========Iteliminatespointsolutionsandreducescomplexity.Itoffersoneenvironmenttoauthor,generate,anddeliverallyourdocuments.Asaresult,itreducescostsbyeliminating3rd-partysolutionsandoutdatedhomegrownsystemsthataredifficulttomaintain.IthasthelowestTCOcomparedtootherreportingsolution/toolinthemarkettoday5LayoutTemplateTypesOutputFormatsDestinationsEmailPrinterFaxe-CommerceRepositoryDataSourcesLayoutDesignToolsWebServicesOracle,OracleBIEE,OracleBIAppsSQLServerE-BusinessSuite,PeopleSoft,Siebel,JDE,PrimaveraOLAPOracleBIPublisherEnterpriseFromDatatoDocumenttoDeliveryLayoutEditorMSWordMSExcelAdobeFlexXSLXSLXMLEDIEFTPDFHTMLExcel ppt 关于艾滋病ppt课件精益管理ppt下载地图下载ppt可编辑假如ppt教学课件下载triz基础知识ppt CSVFlashRTFInteractiveCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›6CompletedocumentgenerationANDdeliverysolution.Canextractandcombinedatafromavarietyofdatasources.BusinessuserscancreatereportlayoutsusingfamiliardesktoptoolssuchasMSWord&Adobeprofessionalontopofthatdata.Documentscanbegeneratedinawiderangeofoutputformats,andcanbedeliveredviamultipledeliverychannelsbasedontheenduser’sorrecipient’schoice.ArchitectureBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›7OracleBusinessIntelligencePublisherSeparatedatalogic,layout&translationbenefitsgreaterflexibilityandreusefewerreportsandbetterreportmaintenanceoptimizedataextractionanddocumentgenerationprocessReportArchitectureReportoutputDataLogicLayoutTranslationBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›8OracleBIPublisherScheduler11gBIPublisherWebserverBIPublisherWebserverBIPublisherReportsRepositoryClientClientSchedulerdatabaseJMSResourcesEmailPrinterFaxRepositoryFilesystemFAXQ.PrinterQ.EmailQ.FTPQ.WebDavQ.FileQ.JobQReportQBIPSystemTopicWebserver/JMSProvider(WebLogic,ActiveMQ)Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›<>BIPublisherschedulerhasbeencompletelyre-architectedin11g;it'sbasedonJavaMessagingService(JMS)queuetechnology.<>AllowsyoutodedicateoneormoreBIPublisherserversexclusivelyforparticularfunctionssuchasreportgeneration,documentgenerationorhighdemanddeliverychannels(FTP,Fax,WebDAVetc.).<>ThedefaultJMSproviderforOracleBusinessIntelligencePublisher11gisWeblogicJMS.AlternativelyApacheActiveMQcanbeconfiguredasJMSprovider.======<>Whenausersubmitsajob,thejobinformationisstoredintheQuartztables,andthenecessarytriggerstorunthejobarecreated.<>WhenascheduledjobisexecutedbytheQuartztrigger,thejobmovesintotheschedulerjobqueue(JobQ).<>TheJobProcessordetermineswhetheraparticularjobneedstobehandledbyburstingengineorbatchjobprocess.<>Atthisstagethejobispickedupbytherespectiveengine/processandthebusinesslogicisexecuted.ThereportmetadataisgeneratedandcapturedintoReportQueue.<>ThejoboftheReportProcessoristokeeplisteningtotheReportQueueandgeneratethereportsbasedonthemetadataavailable.<>OncethereportisgenerateditthenpassesonthedeliveryrelatedinformationtoDeliveryQueue.<>ThejoboftheDeliveryProcessorsistolistentotheDeliveryQueueanddeliverthereportusingrespectiveDeliveryAPI(s).FailoverProcess<>Intheeventoffailureofanodeintheclustertheothernodeassignedforthesameprocesswilltakeover.9ProgramAgendaOracleBIPublisherEnterpriseOverviewReportDesignBestPracticesDataModelingGuidelinesTemplateDesignGuidelinesQ&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›10DataGenerationDataSourceTypesFile(XML)SQLQueryMDXQueryLDAPQueryExcelSpreadsheetHTTP(XMLFeed)WebServiceOracleBIAnalysisDataSourcesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Whattypeofdatasource?<>FreetouseanydatasourcetypeyouwantogettheXML<>BIPcanworkwithanydatasourceaslongasthedataisprovidedinXMLformat<>Forlargereports,useaDataTemplate.ThisespeciallytrueforEBS,whereoftenyouhavetochoosebetweenusingOracleReportsVsDataTemplate.UsingOracleReportsmayresultinfasterdeployment(datastructureisalreadydefinedinOracleReports),butDataTemplateisgenerallyfasteratdataextraction.11DataGenerationJDBCVsJNDI(SQLType)BothtypesofconnectionusethesameJDBCdriverWithJNDIyoucantakeadvantageofconnectionpoolingBetterperformanceConnectionalreadyestablishedtothesourceBestpracticeforreportswithmanyparameterswithSQLtypeLOVsattachedtothemBetterRDBMSresourcemanagementConnectionTypes21WebLogicServerBIPublisherCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Whattypeofconnection?JNDI–Recommendedbecauseofconnectionpooling.Forexample–whenthereportcontainschainedparameters,eachtimethereportisexecuted,theparameterswillinitiatetoopenadbsessioneverytime,whichistimeconsuming.ButbyusingJNDIthatprecioustimeisavoided.12DataGenerationEnableforlargereportsSlowerperformance,butpreventsout-of-memoryerrorsUsewithscheduledreportsScalableModeCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›13DataModelDesignOptimizedataextractionSimplifylayoutdesignforreportdevelopersReducedocumentgenerationtimeObjectivesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›14DataModelDesignLeverageback-endsystemresources(whenpossible)JoindataFilter&groupdataPerformexpensivecalculations&datatransformationsSortdataConsidergoingagainstBIServerinsteadofextractingdatadirectlyfromthesourcesystemsUseBIServerLogicalSQLinsteadofAnswers/AnalysisDataExtractionSelectt."OFFICE_DSC"as"Office"sum(f."REVENUE")as“SalesSum"From"BISAMPLE"."SAMP_REVENUE_F“f"BISAMPLE"."SAMP_OFFICES_D“tWheret."OFFICE_KEY"=f."OFFICE_KEY"groupbyt."OFFICE_DSC"20Vs20,000recordsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Dataextraction<>Leverageback-endsystemresourcespushexpensivejoinstotheDB)<>Optimizeyourqueries<>Filteringdata(dependingonreportdatarequirement,filterdata@thesource,oruseparametrs)15DataModelDesignParameters&LOVsCacheLOVSforbetterperformanceForlargeLOVs,passNULLtotheparameterwhenusersselectAll&modifyWHEREclauseinDataSetquerytousetheNVLfunction.Forexample:“Whereorder_id=nvl(:p_ordid,order_id)”DataExtractionCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Parameters&LOVs--CacheLOVs--passall,VspassNull)16DataModelDesignEventtriggersBeforeDataTriggersGeneratedynamicSQLPopulateTEMPtablesSetusercontextAfterDataTriggersInsertrowstoatargettableSendnotificationsCleanordeleteTEMPtablesDataExtractionSelectEMPLOYEE_ID, DEPARTMENT_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARYfromemployeeswhere&p_where_clauseCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Before&afterdatatriggers--dynamicqueries,--populatetemptables,--cleanupafterdataisextracted--SendnotificationsEtc.DataTrigger=Procedure(DBPackage)thatgetscalledwhenSQLisgetexecutes17DataModelDesignStructuredata–tomatchhowdataisdisplayedinthereportUseshortXMLtagnames–theyreducethesizeofXMLdatafileUsedisplaynames–tosimplifytemplatedesignCreateglobal&group-levelaggregatefunctions–forbestperformance,createthemindatamodelinsteadofreportlayoutPre-sortdataNote:GroupingdataindatamodelautomaticallysortsdatabythegroupingelementBurstingItalsorequiresthatdataintheXMLissorted(orgrouped)bythesplit-bykey.BestPracticesforFasterDocumentGenerationCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Layoutcreation&Documentgeneration<>Datastructure(matchhowdataistobedisplayedinthereport)<>XMLtagnames(reducethesizeofXMLdatafile)<>Displaynames(namespresentedtousers,simplifytemplatedesign)<>Global&group-levelaggregatefunctions(forbestperformance,createindatamodelandprintonreport)18ProgramAgendaOracleBIPublisherEnterpriseOverviewSystemConfigurationGuidelinesBIPublisherServerConfigurationOptionsReportDesignBestPracticesDataModelingGuidelinesTemplateDesignGuidelinesQ&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›19 RTFTemplates Easytocreatew/BIPublisherTemplateBuilderAdd-intoWordGreatestflexibilityandfunctionalityforhighlyformattedreportsRTFmarkedupwithXSLcodeorBIPublishersimplifiedXSLWiderangeofoutput(PDF,HTML,Excel,PPT,RTF,MHTML) BIPublisherTemplate11g WebbasedLayoutEditor–noclientinstallationrequiredBestforManagementReport–WYSIWIGexperienceSupportInteractiveOutputWiderangeofoutput(PDF,HTML,Excel,PPT,RTF,MHTML) ExcelTemplates Excelw/datamappedtonamedcells&ExcelandXSLformattingGreatforformatted,trueExceloutputandburstoversheetsExcelXLSoutputonlyDocumentFormattingandLayoutWhatTemplateTypeshouldIuse?(1of2)Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›20WhenyougottocreatealayoutThefirstquestionyouhavetoansweriswhatTypeofreportandoutputamIgenerating.Thatwillguideyoutowhichtemplatetypetouse.BIPublisheroffersmanychoiceswhichmayoverwhelmabeginnerBIPublishertemplates2)RTFTemplates….WeprovidetheBIPublisherTemplateBuilder–anAdd-IntoWord–thatprovidesseveralwizardsthatallowyoutoeasilyinsertdatafields,tablesandcharts.Controlinstructionslikedatafields,loopsandifstatements.3)PDFFormsallowyoutofilloutexistingPDFformswithdatafromBIPublisher.ThisismostusefulwhenyouhavethedocumentalreadyavailableasaPDFform.AtypicalcaseisgovernmentformsthatareoftenalreadyavailableasPDFforms.InthiscaseyoucanjustusetheexistingPDFformandavoidreplicatingtheform.PDFFormsonlygeneratePDFoutput. PDFForms PDFformswithXMLelementsmappedtoformfields.GreattousewithgovernmentformsPDFoutputonly-createdinAcrobatProfessional e-TextTemplates Textoutputonly–forelectroniccommunicationGreatforcharacterdelimitedorfixedpositiondocs(EFT&EDI)RTFwithtableofstatementstoplacefieldsandseparators FlashTemplates SWFfileswithBIPublisherdata–forsophisticatedinteractivityCreateinAdobeFlexBuilder XSLStyleSheets Allowsforthirdpartytoolsandlegacysolutions ExcelAnalyzerTemplates Notrecommended(deprecated)Exceloutputonly.Canrefreshdataw/parameters.DocumentFormattingandLayoutWhatTemplateTypeshouldIuse?(2of2)Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›214)ExcelTemplatesnewin11gand10.1.3.4.1preferredmethodforcreatingExcelSpreadsheets–greatestflexibility.DoesrequirehandcodingintheExceltemplate.PlanforanExcelAdd-insimilartotheRTFTemplateBuilderAdd-in.5)eTexttemplatesareusedtocreatetextdocumentsforelectronicdatainterchange.YoucancreatefixedwidthandcharacterdelimitedtextrecordsfromanRTFspecificationdocument.eTextdocumentaremostlyusedforETFwhichis…ElectronicFundTransferdocumentsorEDI–ElectronicDataInterchangedocuments.6)FLASHTemplatesuseflashfilesyoucancreatewithAdobeFlexBuilder.Theyallowyouunlimitedinteractivity,butarenotsuitableforprintedreports.FlashTemplatescangenerateFlashandPDFoutput.7)XSLStylesheetscanbeusedtocreatelayoutswiththirdpartytoolsortomakeuseofexistingstylesheets.XSLstylesheetscangenerateawiderangeofoutputlikeRTFTemplates.InmostcasesRTFtemplatesareabetterchoicethenXSLstylesheets.8)EXCELAnalyzertemplateallowyoutoloadaflatdatasetintoEXCEL.YoucaneitheruseourmacrostorefreshthetemplatesoraddyourownVBAmacrosthatarestartedonopeningthedocument.ExcelAnalyzercanonlyproduceExceloutput.Youhavechoices.RTFisthemostcommonlyusedbutusedoftheLayoutEditor/BIPublisherTemplateisincreasing.BIPublisherTemplate(11g)BestPracticesUseLayoutGridstopositioncomponents–similartotablesinRTFTemplatesLayoutGridscanbenestedLayoutGridCellcanbejoinedTheminimumheightofrowscanbefixedDoNOTputlargetables(Perform.)orpivottablesintoLayoutGridsDesignConsiderationCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›22BIPublisherTemplate(11g)BestPracticesTheInteractiveViewerisoneofBIPublisher’smostpopularnewfeaturesInteractivityworksbestforflattablesorsimplenestedmaster-detaildatasetsUnrelatedqueriesorgroupscannotinteractDisableinteractionsforunrelatedqueriesintheConfigureEventsDialogDesignConsiderationBAD:CountryontwobranchesDataG1CountryRevenueG2CountryCostGOOD:CountryincommonparentDataG1CountryG2RevenueG3CostCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›23RTFTemplateBestPracticesUsetablestocontrolpreciselywherefielddatawillbeplacedinthereportUseWordTablesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›TheFirstandmostsimplerecommendationusetablestocontrolexactlywherefielddatawillappearinthegenerateddocument.Usefieldsininlinetextonlyforformlettersandwheretextwithinlinedatafieldsareappropriatelikeformletters.Don’ttrytocontrolthepreciseplacementoffieldswithspacesortabs.24RTFTemplateBestPracticesKeepthetemplatecleanSupportedbytheTemplateBuilderFieldBrowserCanbecoloredorhiddentohelpunderstandthestructureCaveat:Wordheader&footerdon’tallowformfieldsUseFormFieldsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Thenextrecommendationistohidecustomcodeinformfields.25RTFTemplateBestPracticesAchieveconsistencyinthetemplateandbetweentemplatesIn11guseStyleTemplatestocontrolthetemplatestylesUseWordStylesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›UseWordstylestoformattextanddata–font,weight,bold,italics,etc.26RTFTemplateBestPracticesKeepiteasytounderstand,debugandmaintainIngeneralbettertohavedifferentbusinessdocumentsindifferenttemplatesTrytolimitthelogicintemplatestosimpleiforloopstatementsUsesubtemplatestosimplifydocumentsifnecessaryManycalculationsarebetterperformedinthedatamodelDon’tovercomplicateyourtemplateCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›27DocumentFormattingandLayoutWhatisasubtemplate?AdocumentthatcontainslayoutandorcodethatcanbedefinedonceandusedmultipletimesMultiplefunctions(called“templates”inXSL)ortextsegmentscanbedefinedinasinglesubtemplatefileSubtemplatetypesXSLsubtemplatesforcodere-useorseparationRTFsubtemplatesforlayoutre-useCaveat:UseofRTFsubtemplatesmakesithardertounderstandandvisualizethetemplatestructureSubTemplates:IntroductionCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›28DocumentFormattingandLayoutRTFsubtemplatesRe-usecommonlayoutssuchastermsandconditionsInternationalizedaddressblockXSLsubtemplatesTransformationsforcomplexchartrequirementsDynamicallyapplyformattingtoaportionofdata(e.g.subscripting/superscripting/chemicalformula)PrintformattedXHTMLdata–converttoFOusingsubtemplate(asusedinOracleContracts)(11.1.1.6supportsHTMLindata) Startingw/11.1.1.3werecommendusingStyleTemplatesforHeader/FooterinsteadofRTFSubTemplateSubTemplates:UseCasesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›29RTFTemplateBestPracticesBIPublisherusesXPATHtoaccessdataelementsDEPARTMENT_NAMEisinsertedinthetemplateas<?DEPARTMENT_NAME?><?DEPARTMENT_NAME?>istranslatedtotheXPATH.//DEPARTMENT_NAME.//DEPARTMENT_NAMEsearchesforDEPARTMENT_NAMEinthecompletesub-treestartingfromcurrentcontextPerformanceConsiderations:XPATHConceptsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›<?FIELD?>willmaketheXSLenginesearchforanelementwiththenamefieldinthecorrectcontextUsing<?FIELD?>hastheadvantageofnotbeingaffectedbychangesintheXMLtreeandmakesiteasiertomovepartsofaRTFtemplatearound.However,isgenerallynotgoodforperformancewithlargeXMLdatasets.UsepreciseXPATHexpressions–e.g.<?/ROWSET/ROW/FIELD?>ifitturnsoutthattheperformanceofthetemplateisinsufficient.30RTFTemplateBestPracticesUsethefullrelativepathforlargedatasetsInsteadof<?for-each:DEPT?>use<?for-each:/DEPT_SALS/DEPT?>Insteadof<?DEPARTMENT_NAME?>use<?./DEPARTMENT_NAME?>Forlargedocumentsthatdon’tfitintomemorythesearchrequiresdiskaccessForsmalldocumentsthesearchtimeisnegligiblePerformanceConsiderations:XPATHTuningCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›31RTFTemplateBestPracticesXPATHTuningStartwiththeouterloopsandoutermostdataaccessReducingfulltreesearcheswillprovidebiggerimprovementsthanoptimizingaccessinasmallsubsetofthedataFixingtheXPATHinasinglefor-eachloopmaybealltheperformancetuningyouneedtodoTablesLARGEtablesthatspanhundredsofpagesconsumeconsiderableserverresources.Ifpossiblegroupthedataandcreateatableinsideeachgrouping.DonotnestLARGEtablesintotables.PerformanceConsiderations:XPATHTuning&TablesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›OuterloopsaccessthecompleteXMLtreeThisisinparticularcriticalforreportsrunninginscalablemode,Sincepartofthedocumentmaybestoredondisk.32RTFTemplateBestPracticesBettertoSortdatainthedatamodelGroupBy<?for-each-group?>willforcetheXSLenginetosortdataChecking“Dataalreadysorted”optionintheTableWizardwillnotre-sortdata(goodthing)PerformanceConsiderations:GroupingCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›33TemplateBestPracticesDon’tovercomplicateyourtemplatesUsetables(layoutgrids)toplacedatafieldspreciselyUseformfieldsandwordstylesforclarityUsesubtemplatesforre-useandencapsulatecomplexcodeOptimizeyourdatastructureforinteractivityifnecessaryPerformanceoptimizationOptimizetheXPATHFocusoptimizationonouterloopsSortinthedatabaseanduse“group-adjacent”inthetemplateSummaryCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›34StayConnectedwithBIPublisherhttp://www.oracle.com/technetwork/middleware/bi-publisher/overview/index.htmlCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Q&ACopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›37Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›38AppendixCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›ResourcesCertificationmatrix(11.1.1.x)http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xlsHighavailabilitywhitepaperhttp://www.oracle.com/technetwork/middleware/bi-publisher/bip-cluster-deployment-366859.pdfSizingSpreadsheetforBIPublisherEnterprise10gMyOracleSupportNote-948841.1Sub-templateswhitepaperhttp://www.oracle.com/technetwork/middleware/bi-publisher/overview/bip-subtemplate-1-132933.pdfQUARTZScheduling(clustering)wikipagehttp://wiki.opensymphony.com/display/QRTZ1/ConfigJDBCJobStoreClusteringCPURatingshttp://www.spec.org/cpu2006/results/cpu2006.html#SPECint_rateCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›40ServerConfigurationOptionsScalablethreshold(inbytes)Cacheexpiration(inmin)Cachesizelimit(#ofdatasets)MaximumcachedreportsDatabaseFetchSizeAdministration>ServerConfigurationDefaultvaluesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›<>ReportScalableThreshold–Whenxmldatasizeislargerthanthisvalue,scalablefeatureofXSLTprocessoristurnedonregardlessofserverorreportsettings.Enteravalueinkilobytes.Thedefaultis10,000,000(10MB).<>CacheExpiration–Expirationperiodforthedatasetcacheinminutes.Thedefaultis30.FordatasetsreturnedbyaSQLquery,HTTP,orOracleBIAnswers,youhavetheoptionofcachingthedatasetreturnedbythequery.Thereturneddatasetwillremainincachefortheperiodspecifiedbythisproperty.41ServerConfigurationOptionsBursting(10gonly)Enablemultithreading–Default:False*Threadcount–Default:2*FOprocessingUseBIPublisher’sXSLTprocessor–Default:TrueEnablescalablefeatureofXSLTprocessor–Default:False*Pagescachedduringprocessing–Default:50Enablemultithreading–Default:False*FOParsingBufferSize–Default:1000000*EnableXSLTruntimeoptimization–Default:TrueAdministration>RuntimeConfiguration>PropertiesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›TheRuntimeConfigurationpageenablesyoutosetruntimepropertiesattheserverlevel.Youcanalsosetpropertiesatthereportlevel.Ifdifferentvaluesaresetforapropertyateachlevel,thereportlevelwilltakeprecedence.Tosetapropertyatthereportlevel,selectthereport,andthenselecttheConfigurelink.NotesonFOProcessing"EnableMultithreading"Youshouldonly"EnableMultithreading"onmachinesthathavemultipleprocessorsormulti-coreprocessors.Theamountofperformancegainseenbyenablingthissettingwilldependonhowmuchthecurrentsystemresourcesareutilized.OnasystemthathasnumeroususersrunningandrelativelyhighCPUutilizations,youwilllikelyonlyseeminorimprovementsaftersetting"Enablemultithreading"toTrue.Ifthesystemisusedbyonlyafewusers,orreportsarescheduledsequentiallyoneatatime,orthenumberofCPUsismorethanthenumberofconcurrentreports,thenturningonmultiplethreadsmayspeedupreportgeneration.42Report-levelPropertiesEditReport>Properties>FormattingCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Server-levelconfigurationsettings(includingserver-levelruntimeproperties)applytoallreports.Inmostsituationsthepestpracticeistoleaveserver-levelpropertiestotheirdefault(typical)settings,andoverridedefaultserver-settingsonaneed-tobasisatthereportlevel.43Report-levelPropertiesForlongrunningreportsTakeadvantageofschedulinganddisableRunReportOnline.ViewingReportsOnlineReportEditorReportViewerCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›44Report-levelPropertiesEnableDataCachingSavesXMLdataforreuseuptotheCacheExpirationthresholdImprovedperformancewithdifferenttemplate/outputformatNotrecommendedforreal-timedataEnableDocumentCachingBetterperformanceConsumesmoreTempstoragespaceUserLevel(11gonly)DisableforbetterperformanceifdatacanbesharedacrossusersCacheDuration(11gonly)ViewingReportsOnlineReportEditorCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Otherreportlevelpropertiesthatimpactperformanceinclude:<>EnabledocumentcacheWithdocumentcacheenabled,whenauserviewsthereportonline,thedocument(datapluslayout)willbeplacedincache.Whenthesameuserusestheonlineviewertoviewtheexactsamereport(samelayout,sameoutputtype,sameparameterselections)thedocumentwillberetrievedfromcache.ThedocumentwillremainincacheaccordingtothecachespecificationssetintheSystemMaintenancepage.45DataModelDesignGuidelinesAvoidre-usingthesamenameforelementnames;itcancauseconfusionintemplatedesign.Forexample,CITYunderSHIPPING_ADDRESSandBILLING_ADDRESS.Butinmanycasesyouarebetteroffusingdifferentnamese.g.S_CITYandB_CITYElementNamingCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Selectionofdatainthelayouttemplateisdonebyname.Tomakesurethatyoudon’taccidentallyselectthewrongdatainthelayouttemplate,useuniqueelementnamesintheXMLdata.BIPextractsdataforprocessingtoanXMLfile–ThesizeoftheXMLfiledoesmatteranditdoesimpactperformance.46DataModelDesignGuidelinesAvoidgeneratingemptytagsintheXMLAggregationoverfieldsthatcontainemptytagswillfailwitha“notanumber”exceptionMissingfieldsdonotcauseanissuewithXSL–forexampleaprintstatementwilljustreturnanemptystringAvoidXMLattributesTheyaresupportedinbothRTF&Exceltemplatesbuttheyaddanextralayerofcomplexity;theyarenotsupportedintheBIPublisherLayoutEditorNULLElements&XMLAttributesCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›ForexampleifyouencounteranullvalueforAMOUNTinthedatabase,donotgenerate<AMOUNT></AMOUNT>or<AMOUNT/>,leaveoutthewholetag.Therearetworeasonsforthat:XMLwillbesmallerXSL-FOhandlesitbetter;nullvaluesinelementscausetroublewithformatmasksandaggregations47DataModelDesignGuidelinesIfpossibleuseSQL/JDBCagainstBIServerinsteadofusinganAnswersRequestasadatasourceTip:CopytheSQLinanAnswersRequestandpasteintotheQueryBuildertextareaOBIEEDataSourceCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›48Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.‹#›50