OracleBIPublishBestPractice-甲骨文BIPublish最佳实践-培训
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
3 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Program Agenda
▪ Oracle BI Publisher Enterprise Overview ▪ Report Design Best Practices
Job Q Report Q BIP System Topic
JMS Resources
– Simplify report development & maintenance
– Reduce costs
wk.baidu.com
Labels
5 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Checks
Reports
XML / EFT / EDI
Oracle BI Publisher Enterprise
Eliminate Multiple-point Solutions
Invoices
▪ One Environment
– Author
– Generate
– Deliver
▪ Benefits
– Eliminate complexity
Destinations
– Data Modeling Guidelines – Template Design Guidelines – Reporting Guidelines
▪ Q&A
4 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
BI Publisher
Report output
8 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle BI Publisher Scheduler 11g
Client
Client
Web server
Oracle BI Publisher Enterprise
From Data to Document to Delivery
Interactive
Oracle, Oracle BI EE, Oracle BI Apps SQL Server
PDF HTML Excel
E-Business Suite, PeopleSoft, Siebel, JDE, Primavera
1 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle BI Publisher Best Practices
Rupesh Varma Principal Product Manager
2 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for oracle's products remains at the sole discretion of oracle.
– greater flexibility and reuse – fewer reports and better report maintenance – optimize data extraction and document generation process
Data Logic Layout Translation
BI Publisher
Web server
BI Publisher
BI Publisher Reports Repository
9 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Web server/JMS Provider (Web Logic, Active MQ)
Output Formats
Email Printer
Fax Repository e-Commerce
Destinations
6 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Architecture
BI Publisher
XSL
Layout Template Types
PPT Flash RTF
OLAP
Web Services
Data Sources
• Layout Editor • MS Word • MS Excel
• Adobe • Flex • XSL
Layout Design Tools
CSV XML EDI EFT
7 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Business Intelligence Publisher
Report Architecture
▪ Separate data logic, layout & translation benefits
Program Agenda
▪ Oracle BI Publisher Enterprise Overview ▪ Report Design Best Practices
Job Q Report Q BIP System Topic
JMS Resources
– Simplify report development & maintenance
– Reduce costs
wk.baidu.com
Labels
5 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Checks
Reports
XML / EFT / EDI
Oracle BI Publisher Enterprise
Eliminate Multiple-point Solutions
Invoices
▪ One Environment
– Author
– Generate
– Deliver
▪ Benefits
– Eliminate complexity
Destinations
– Data Modeling Guidelines – Template Design Guidelines – Reporting Guidelines
▪ Q&A
4 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
BI Publisher
Report output
8 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle BI Publisher Scheduler 11g
Client
Client
Web server
Oracle BI Publisher Enterprise
From Data to Document to Delivery
Interactive
Oracle, Oracle BI EE, Oracle BI Apps SQL Server
PDF HTML Excel
E-Business Suite, PeopleSoft, Siebel, JDE, Primavera
1 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle BI Publisher Best Practices
Rupesh Varma Principal Product Manager
2 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for oracle's products remains at the sole discretion of oracle.
– greater flexibility and reuse – fewer reports and better report maintenance – optimize data extraction and document generation process
Data Logic Layout Translation
BI Publisher
Web server
BI Publisher
BI Publisher Reports Repository
9 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Web server/JMS Provider (Web Logic, Active MQ)
Output Formats
Email Printer
Fax Repository e-Commerce
Destinations
6 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Architecture
BI Publisher
XSL
Layout Template Types
PPT Flash RTF
OLAP
Web Services
Data Sources
• Layout Editor • MS Word • MS Excel
• Adobe • Flex • XSL
Layout Design Tools
CSV XML EDI EFT
7 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Business Intelligence Publisher
Report Architecture
▪ Separate data logic, layout & translation benefits