primavera users: welcome to bi publisher! - … welco… · cpm construction 2013 new orleans, la...
TRANSCRIPT
![Page 1: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/1.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13
Primavera Users:Welcome to BI Publisher!
Daniel L Williams, PhDOracle Practice Manager
Partners Consulting
1
How BI Publisher relates to Primavera and the Red Stack
![Page 2: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/2.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 2
Topics
History of BI Publisher and Primavera
About Primavera
How to use BI Publisher
- Word Plug in and Sample Data
- The Data Model
- BIP Repository & Structure
- Editing reports in BIP Web
Connecting Primavera with BI Publisher
- PCM
- P6: true tables, report schema, and issues
![Page 3: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/3.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 3
History
2003 XML 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
![Page 4: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/4.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 4
Architecture: Enterprise Applications
Oracle
Database
WebLogic
Application Server
UCM
P6 PCM
BI Publisher many more…
Applications
OBIEE
App Server
Database
Unifier JDE
Applications run within the WebLogic Application Server, which stores information in the underlying database.
![Page 5: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/5.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 5
Clarification: OBIEE vs BI Publisher
BI Publisher- For Publishing “static” information- Reports delivered in a variety of formats- PDFs, Word, Excel
OBIEE- For Interactive analysis of data- Web Interface- More “free form”
P6 Analytics
PCM/P6 Reports
![Page 6: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/6.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 6
What is BI Publisher?
Started as XML Publisher for E-Business Suite
Key concept: Separate Data Model from Layout
-> you can report on virtually anything
Data Extraction
Layout Template
Output: Word, Excel, PDF &cLayout
TemplateLayout Template
Delivery: Email, FTP, Repository, file system
Scheduling &c
![Page 7: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/7.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 7
What is Primavera?
MS Project – build a treehouse
Primavera P6 – build a dozen nuclear plants worldwide 1000’s of people, +10,000 of tasks
Primavera Contract Management – manage project documents and costs
![Page 8: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/8.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 8
Primavera Reporting: Old and NewOld: InfoMaker
- Windows Only
- Not owned by Oracle
- Not supported on 64-bit OS
New: BI Publisher
- OS “independent”
- Editing through MS Word, Acrobat Professional, Excel
- 11g has Web-based Layout Editor
- Owned and Intensely developed by Oracle across
the Stack
![Page 9: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/9.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13
Two hatsServer setup and administration
Report Writer/Developer
Running BI Publisher
![Page 10: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/10.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13
Log into BI Publisher
Running BI Publisher
![Page 11: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/11.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 11
Data Sources First make your data sources
![Page 12: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/12.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 12
Data Sources JDBC is the natural choice for Primavera
![Page 13: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/13.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 13
Data Sources Settings are identical to those set through Primavera database configuration application
![Page 14: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/14.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 14
Report Catalog: Layouts and Models
![Page 15: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/15.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 15
Report: Data Model
![Page 16: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/16.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 16
Report: Data Model
![Page 17: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/17.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 17
Report: Layouts
Two Main Options:- MS Word- Web UI
![Page 18: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/18.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 18
Report: Layouts
![Page 19: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/19.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 19
Report: View
![Page 20: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/20.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 20
Reports in BI Publisher – now what?
Tie the two together- BI Publisher Folders- Primavera Folders- Primavera Connection settings
![Page 21: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/21.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 21
BI Publisher Setup: Folders
![Page 22: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/22.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13
Primavera Setup: Folders
![Page 23: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/23.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 23
Primavera Setup: AdminCM.cmd
Only three settings: user, password, and URL->How does that work???
![Page 24: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/24.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 24
Secret Sauce: The URL reveals WSDL
Web Service Definition Language – how to request BIP reports
![Page 25: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/25.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 25
Secret Sauce: The URL reveals WSDL
- Primavera sends web requests specifying report,passing parameters such as project name
- Primavera output is PDF by default
Request
Primavera P6
Primavera PCM BIP Service
OtherOther
Other
TPS-27b/61 $123.452 $543.213 $101.014 $314.15
![Page 26: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/26.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 26
Report in Primavera Contract Manager
![Page 27: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/27.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 27
Recap
> 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 Service
More on Primavera:
Oracle Primavera Special
Interest Group
www.PrimaveraSIG.com
![Page 28: Primavera Users: Welcome to BI Publisher! - … Welco… · CPM Construction 2013 New Orleans, LA 27JAN13 - 31JAN13 Primavera Users: Welcome to BI Publisher! Daniel L Williams, PhD](https://reader031.vdocuments.us/reader031/viewer/2022022503/5ab1a8037f8b9a1d168cefef/html5/thumbnails/28.jpg)
CPM Construction 2013
New Orleans, LA 27JAN13 - 31JAN13 28
Questions?
Daniel L Williams