Transcription
CPM Construction 2013Primavera Users:Welcome to BI Publisher!Daniel L Williams, PhDOracle Practice ManagerPartners ConsultingHow BI Publisher relates to Primavera and the Red StackNew Orleans, LA 27JAN13 - 31JAN131
CPM Construction 2013TopicsHistory of BI Publisher and PrimaveraAbout PrimaveraHow to use BI Publisher- Word Plug in and Sample Data- The Data Model- BIP Repository & Structure- Editing reports in BIP WebConnecting Primavera with BI Publisher- PCM- P6: true tables, report schema, and issuesNew Orleans, LA 27JAN13 - 31JAN132
CPM Construction 2013History2003 XML Publisher with EBS 11.5.102004 Oracle Acquires PeopleSoft/JDE2008 Oracle Acquires BEA Systems (WebLogic)2008 Oracle Acquires Primavera2010 Primavera P6 v8.0 BI Publisher 10g / WebLogic2011 Primavera PCM 14.0 BI Publisher 11g / WebLogic2012 Primavera Unifier BI PublisherNew Orleans, LA 27JAN13 - 31JAN133
CPM Construction 2013Architecture: Enterprise ApplicationsApplicationsP6BI PublisherApp ServerDatabaseUnifierPCMUCMWebLogicApplication ServerOracleDatabaseNew Orleans, LA 27JAN13 - 31JAN13JDEOBIEEmany more Applications run within theWebLogic Application Server,which stores information in theunderlying database.4
CPM Construction 2013Clarification: OBIEE vs BI PublisherBI Publisher- For Publishing “static” information- Reports delivered in a variety of formats- PDFs, Word, ExcelOBIEE- For Interactive analysis of data- Web Interface- More “free form”New Orleans, LA 27JAN13 - 31JAN13PCM/P6 ReportsP6 Analytics5
CPM Construction 2013What is BI Publisher?Started as XML Publisher for E-Business SuiteKey concept: Separate Data Model from Layout- you can report on virtually mplateTemplateOutput:Word, Excel,PDF &cNew Orleans, LA 27JAN13 - 31JAN13Delivery:Email, FTP,Repository,file systemScheduling &c6
CPM Construction 2013What is Primavera?MS Project – build a treehousePrimavera P6 – build a dozen nuclear plants worldwide1000’s of people, 10,000 of tasksPrimavera Contract Management – manage projectdocuments and costsNew Orleans, LA 27JAN13 - 31JAN137
CPM Construction 2013Primavera Reporting: Old and NewOld: InfoMaker- Windows Only- Not owned by Oracle- Not supported on 64-bit OSNew: BI Publisher- OS “independent”- Editing through MS Word, Acrobat Professional, Excel- 11g has Web-based Layout Editor- Owned and Intensely developed by Oracle acrossthe StackNew Orleans, LA 27JAN13 - 31JAN138
CPM Construction 2013Running BI PublisherTwo hatsServer setup and administrationReport Writer/DeveloperNew Orleans, LA 27JAN13 - 31JAN13
CPM Construction 2013Running BI PublisherLog into BIPublisherNew Orleans, LA 27JAN13 - 31JAN13
CPM Construction 2013Data SourcesFirst make yourdata sourcesNew Orleans, LA 27JAN13 - 31JAN1311
CPM Construction 2013Data SourcesJDBC is thenatural choicefor PrimaveraNew Orleans, LA 27JAN13 - 31JAN1312
CPM Construction 2013Data SourcesSettings are identical tothose set throughPrimavera databaseconfigurationapplicationNew Orleans, LA 27JAN13 - 31JAN1313
CPM Construction 2013Report Catalog: Layouts and ModelsNew Orleans, LA 27JAN13 - 31JAN1314
CPM Construction 2013Report: Data ModelNew Orleans, LA 27JAN13 - 31JAN1315
CPM Construction 2013Report: Data ModelNew Orleans, LA 27JAN13 - 31JAN1316
CPM Construction 2013Report: LayoutsTwo Main Options:- MS Word- Web UINew Orleans, LA 27JAN13 - 31JAN1317
CPM Construction 2013Report: LayoutsNew Orleans, LA 27JAN13 - 31JAN1318
CPM Construction 2013Report: ViewNew Orleans, LA 27JAN13 - 31JAN1319
CPM Construction 2013Reports in BI Publisher – now what?Tie the two together- BI Publisher Folders- Primavera Folders- Primavera Connection settingsNew Orleans, LA 27JAN13 - 31JAN1320
CPM Construction 2013BI Publisher Setup: FoldersNew Orleans, LA 27JAN13 - 31JAN1321
CPM Construction 2013Primavera Setup: FoldersNew Orleans, LA 27JAN13 - 31JAN13
CPM Construction 2013Primavera Setup: AdminCM.cmdOnly three settings: user, password, and URL- How does that work?New Orleans, LA 27JAN13 - 31JAN1323
CPM Construction 2013Secret Sauce: The URL reveals WSDLWeb Service Definition Language – how to request BIP reportsNew Orleans, LA 27JAN13 - 31JAN1324
CPM Construction 2013Secret Sauce: The URL reveals WSDLPrimavera P6Primavera PCMRequest BIP ServiceOtherOtherOtherTPS-27b/61 123.452 543.213 101.014 314.15- Primavera sends web requests specifying report,passing parameters such as project name- Primavera output is PDF by defaultNew Orleans, LA 27JAN13 - 31JAN1325
CPM Construction 2013Report in Primavera Contract ManagerNew Orleans, LA 27JAN13 - 31JAN1326
CPM Construction 2013Recap BI Publisher, formerly XML Publisher BI Publisher initially for EBS, now for everything Primavera 2008 acquisition, moving onto the Red stack BI Pub architecture Primavera/BI Pub interface via Web ServiceMore on Primavera:Oracle Primavera SpecialInterest Groupwww.PrimaveraSIG.comNew Orleans, LA 27JAN13 - 31JAN1327
CPM Construction 2013Questions?Daniel L WilliamsDWilliams@PartnersConsulting.comNew Orleans, LA 27JAN13 - 31JAN1328
CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 3 History 2003XML Publisher with EBS 11.5.10 2004 Oracle Acquires PeopleSoft/JDE 2008 Oracle Acquires BEA Systems (WebLogic) 2008 Oracle Acquires Primavera 2010 Primavera P6 v8.0 BI Publisher 10g / WebLogic 2011 Primavera PCM 14.0 BI Publisher 11g / WebLogic 2012 Primavera Unifier BI Publisher
