ITPub博客

Oracle BIEE全称：Oracle Business Intelligence Enterprise Edition；Oracle BI Publisher以前叫XML Publisher（也可缩写为BIP）；Oracle BI Publisher是OBIEE其中的一个组件，主要用于展示不同格式的报表；Oracle Business Intelligence Foundation Suite (OBIEE)则是一套完整的，开放的企业级商务智能系；Oracle BI Publisher主要用于OLTP；OBIEE主要用于OLAP；The main takeaway here for me is that BI Publisher is clearly a tool meant for operational r

BI Publisher Report有很多性能问题是因为，rtf模板中含有大量的ancestor-or-self标签，在生成Output的时候，Report将会花很多时间来解析XML。Solution:把ancestor-or-self标签转换成绝对路径。比如：<?ancestor-or-self::*/LP_FROMDATE?>   改成     <?/INVARCLI/LP_FROMDATE?>测试报表的改动，可以参考：Update Data Template(xml file) and RTF(rtf file) Template for BI Publisher Report Reference: R12: Troub

XML Template Example1.Responsibility:XML Publisher Administrator2.Home > Data Definitions3.In \'Search\' area,enter \'Min-max planning report (XML)\' into name field,and query4.click query result - Min-max planning report (XML)5.press \'Update File\' button,upload the new date template file INVISMMX_XML.xmlRTF Template Example1.Responsibility:XML Publisher Administrator2.Home -> Templates,Query with Name:"Min-max planning report (XML)"3.Click query result - Min-max planning rep

这里演示一下，开发一个最简单BI Publisher Report的流程，下图为开发的基本流程.Data Template(.xml) 作为Data Source，用于数据源的定义，以及取数的SQL语句;Template(.rtf) 用于定义输出展示(Layout); (RTF:Rich Text Format)1.首先创建一个Demo数据CREATE TABLE demo_products ( product_code NUMBER, product_name VARCHAR2 (100)); INSERT INTO demo_products VALUES (569, \'Oracle Cost Management\'); INSERT INTO demo_products VALUES (

安装完BI Publisher之后，然后试图在Word中打开BI Publisher的插件，报：自动化(Automation)错误（Automation Error）这个错其实不是BI Publisher的问题，而是Word的问题。解决方法：The solution is to unregister and re-register the C:\Windows\System32\MSCOMCTL.OCX fileIf on a 64-bit machine, type the following: regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX Hit ENTER then type regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCXIf on a 32-bit machine, type the

14 Easy Steps to End-User Empowerment: Convert Custom Reports to BI Publisher from Mohan Dutt

Best Implementation Practices with BI Publisher from Mohan Dutt