搜索
1OverviewOracleBIPublisher(formerlyknownasXMLPublisher)isarevolutionaryreportinganddocumentoutputmanagementsolutionfromOracle.OracleBIPublisherreportformatscanbedesignedusingMicrosoftWordorAdobeAcrobat,thetoolsthatareeasytouse,andmostusersarealreadyfamiliarwith.OracleBIPublisheralsoallowsyoutocreatereportsfrommultipledatasources.OracleBIPublishercanbeusedasastand-alonereportingproductorintegratedwiththeOracleBusinessIntelligenceSuiteEnterpriseEdition.YouwillstartbyloggingintoBIPublisherandcreatereportsfromvariousdatasources,suchasOracleDatabase,Webservices,RSSfeeds,andFiles.YouwillalsocreateparameterizedreportthatusesLOVs.BecauseBIPublisherisintegratedwithOracleBIEnterpriseEdition,youcanalsocreatetheBIpublisherreportsbasedonOracleBIAnswersrequest,andalsobasedonOracleBIServersubjectarea.However,thesetopicsarebrieflydiscussedinthistutorial.Formoredetails,youcanrefertotheOBEtitledIntegrationofOracleBIPublisherwithOracleBusinessIntelligenceEnterpriseEdition,10.1.3.2.Also,youwillbeguidedthroughthestepstocreateandpublishRTFtemplatesinMSWordbyconnectingtoBIPublisher.Youwillalsoschedulethereport,andviewthesaveddata.ScenarioYouwillbeusingvariousdatasetsforthisOBE.Forexample,youwillcreateasimpleemployeesalaryreportbasedonthehumanresources(HR)sampleschemaoftheOracleDatabase.FortheFiledataset,youwillusethedemofilesandtemplatesthatareprovidedwithBIPublisher.FortheBIAnswersrequestandBIServersubjectarea,SH.rpdisused,whichisbasedontheSHschemaofthedatabase,andsoon.Tocontinuewiththestepslistedinthetopics,youshouldhaveinstalledtherequiredsoftwareandperformedtheothersetupasmentionedinthefollowingtopic,Prerequisites.PrerequisitesBeforestartingthistutorial,youshould:1.HaveaccesstoorhaveinstalledOracleDatabase10g(preferablyversion10.2)2.Haveaccesstoorhaveinstalledthesampleschemas(HR,OE,andSHspecifically)3.HaveaccesstoorhaveinstalledOracleBIPublisherandOracleBIPublisherDesktop10.1.3.2.YoucaninstallBIPublisherDesktopbyclickingtheTemplateBuilderlinkinBIPublisher:WhenyouhavesuccessfullyinstalledBIPublisherDesktop,theBIPublishermenuandBIPublishertoolbarsaredisplayedinMSWord.Note:OracleBIPublisherDesktopwasformerlyknownasTemplateBuilder,andis2mainlyusedforbuildingtheRTFtemplatesforBIPublisherreportsinMSWord4.HavecreatedauserforinstallingtheBIPublisherschedulerschematablesbyperformingthefollowing:CreateaBIPScheduserwiththerequiredprivilegesinthedatabasebyloggingintoSQL*Plusasthesysorsystemuser:SQLcreateuserbipschedidentifiedbybipscheddefaulttablespaceuserstemporarytablespacetempquotaunlimitedonusers;SQLgrantconnect,resourcetobipsched;Note:Thenameoftheusercanbeanyappropriatename.5.Havesetuptheproxyparameters(toavoidanyfirewallproblemswiththeWebServicesandRSSdatasetreports)inthexmlpserverstart.batfileortheoc4j.cmdfileasperyourinstallation.Modifythefollowingline,whichdefinesJAVA_HOME.(Observetheproxyparametersinbold.):•%JAVA_HOME%\bin\java%JVMARGS%-jar-Dhttp.proxyHost=myproxy.mycompany.com-Dhttp.proxyPort=Port%OC4J_JAR%%CMDARGS%Restartxmlpserveroroc4jasthecasemaybe.IfyouwanttocreatereportsbasedonOracleBIAnswersrequestandOracleBIServersubjectarea,thenyoushouldalso:1.HaveaccesstoorhaveinstalledOracleBIEE10.1.3.2includingOracleBIPublisher3andOracleBIPublisherDesktop10.1.3.2.YoucanfollowtheinstructionsaslistedintheOBEInstallingtheOracleBusinessIntelligenceSuiteEnterpriseEditiononWindows.2.HavecreatedanODBCconnectiontotheOracleDatabase,andsetuptheSH.rpdmetadatarepositorybyfollowingthestepslistedintheOBECreatingInteractiveDashboardsandUsingOracleBusinessIntelligenceAnswers.Also,itisstronglyrecommendedthatyougothroughthistutorialtoknowthestepsinvolvedincreatinganAnswersrequest,creatingadashboardpage,andsoon.3.HavesetuptheintegrationbetweenBIPublisherandOracleBIEE:IfyouhaveincludedBIPublisherEnterprise,whenyouinstalledOracleBIEnterpriseEdition,thenOracleBIinstallerwillsetuptheintegrationwiththePresentationServices,bysettinghostname,port,andURLvalues.However,youneedtosettheAdministratorpasswordfromtheBIAdministrationtoolasfollows:1.SelectAllProgramsOracleBusinessIntelligenceBIAdministration.2.SelectOpenOnline.(ToopenSH.rpdonline,enterAdministratorasUsernameandleavethePasswordfieldblank.)3.SelectManageSecurityUsersAdministrator,andcheckouttheAdministratoruser.4.Intheproperties,setthepasswordfortheAdministratoruserandclickOK.IftheIntegrationwithPresentationServicesisnotsetupatthetimeofOracleBIEEinstallation,youcanalsosetupthisintegrationfromBIPublisherasfollows:1.FromtheAdminpage,underIntegration,selectOracleBIPresentationServices.2.EnterthefollowinginformationaboutyourBIPresentationServicesserver:4•ServerProtocol–Selecthttporhttps•ServerVersion–Selectv4•Server–Entertheserverhostname(forexample,server01.mycompany.com)•Portfortheserver–Thedefaultportis9704.•AdministratorUsernameandPassword•URLSuffix–Thedefaultvalueisanalytics/saw.dll.GettingStartedForgettingstartedwithBIPublisher,performthestepslistedineachofthefollowingsubtopics:LoggingIntoOracleBIPublisherSettingPreferencesLoggingIntoOracleBIPublisher:TologintoBIPublisher,performthefollo