OBI EE - Oracle Business Intelligence Enterprise Edition

北冥

copy不走样
■ Physical layer. Represents the physical structure of the data sources to which the Oracle BI
Server submits queries. This layer is displayed in the right pane of the Administration Tool.
■ Business Model and Mapping layer. Represents the logical structure of the information in the
repository. The business models contain logical columns arranged in logical tables, logical joins,
and dimensional hierarchy definitions. This layer also contains the mappings from the logical
columns to the source data in the Physical layer. It is displayed in the middle pane of the
Administration Tool.
■ Presentation layer. Represents the presentation structure of the repository. This layer allows
you to present a view different from the Business Model and Mapping layer to users. It is
displayed in the left pane of the Administration Tool.
Server Admin Guide,p18.

补充下，这个工具是windows平台的客户端开发工具。也就是开发工作只能基于windows平台。
你要是装unix平台了，那就麻烦你搞个windows开发机器，反正这基本是默认模式。
有一次又吃饱了，查了下metalink，看看人家给不给个unix平台的开发工具。回答很干脆：不考虑！

北冥

B-Breakfast
做技术的一定要有早饭的良好习惯啊。呵呵，玩笑啦，我想想怎么说iBot.
B-iBot
iBots are software-based agents driven by schedule or events that access, filter, and perform analytics on data based upon defined criteria.
Users receive information from iBots in the form of alerts that appear on their designated delivery devices or dashboards.

Oracle BI Scheduler is an extensible application and server that manages and schedules jobs. Oracle BI Scheduler supports two kinds of jobs:
■ Scripted jobs.
Scripted jobs are set up and submitted using the Job Manager feature of the Oracle Business
Intelligence Server Administration Tool. For example, a scripted job could periodically load Oracle
BI Server usage statistics into a back-end database. For scripted jobs, Oracle BI Scheduler
communicates with Oracle BI Server.
Oracle BI Scheduler supports two published Java interfaces and two scripting languages.
■ Supported Java interfaces:
❏ SchedulerJavaExtension.java
❏ SchedulerJobInfo.java
■ Supported script languages:
❏ VBScript
❏ JScript
NOTE: Scripting for iBots and scripts defined by the Oracle BI Scheduler Job Manager are
supported only under Windows platforms. The Java interfaces support all platforms.
■ Unscripted jobs, called iBots.
iBots deliver reports and alerts to end users. iBots are configured and submitted for execution
using Oracle Business Intelligence Delivers. Oracle BI Scheduler communicates with Oracle
Business Intelligence Presentation Services for unscripted jobs. For more information, see Oracle
Business Intelligence Presentation Services Administration Guide.

本来想翻译一下，发现自己的表达更不清楚。
简单而言iBot就是预警调度的一段脚本，名字很形象。

[ 本帖最后由 北冥 于 2008-3-19 15:10 编辑 ]

北冥

没有想到凑26个字母也有难度，sigh，看来真的老了...
计划：
C-Catalog

D-Delivery
   定义分发的。比如分发的报表的格式、目的设备、是否调度等。
E-

F-Fact table
   嗯，这个很重要，却真不知道怎么说。

G-Group
   强调下BI Server Group 和 Presentation Group不是一个概念。

H-

I-Interactive Dashboard
  仪表盘，上去玩2下，不用我解释。

J-JavaScript
   JS的基础有助于开发出极其炫目的仪表盘和报表。花哨，可是客户很买账。

K-
   想了半天，Kamus?

L-Logical Layer

M-Model

N-

O-Online/Offline
   Repository可以在线编辑，这样修改能为前端实时应用；也可以离线编辑

P-Publisher
  OBI EE的格式报表工具。一开始很崩溃，拿word设计模版真的很难说专业，但是很容易上手。需要xdo的基础

Q-Query
   适当地设置log level，你能监控所有的查询。

R-Repository

S-Session

T-Time Dimension

U-User Interfac
    个人比较偷懒，恨不得就保持OBI EE的默认界面。但是大多客户不，有些很勤快的有很多主义。有html/web/js/dom基础的比较开心，没有的话只有补齐。

V-Venka
   Venka's Blog，强调一下。

W-Writeback
   不支持回写的BI前端无论如何说不过去，OBI EE的WriteBack需要的配置并不复杂。简单的说就是有一个xml格式的回写模版执行回写sql语句。

X-XML
   Dom的理解对仪表盘和报表的定制极其有帮助

Y-Why OBI EE
   开始了，一切顺其自然。主要是因为其他BI产商的产品比较难弄到完全的版本。

Z-. z Z
   都z了，可以睡了。

[ 本帖最后由 北冥 于 2008-3-18 15:39 编辑 ]

北冥

C-Catalog
The Presentation Catalog stores the content that users create in Answers and Dashboards. This
content, which includes items such as folders, links, and objects (that is, requests, filters, prompts,
dashboards, and so on), is stored in a directory structure of individual files.
catalog文件夹存储用户在前端answers,dashboard创建的对象，比如报表、过滤器、提示和仪表盘页面等。每一对象对应一个.atr的属性文件
默认位置\\OracleBIData\web\catalog，可以通过修改instanceconfig.xml文件修改路径。

7.9.3版本是单个文件，10.x后每一个presentation instance一个目录，我不相信有人需要这个升级向导呵呵。upgrade guide有专门的升级命令，很快，也好用。原来打包了的文件现在往目录下看是一个个的独立文件，类似：
\\OracleBIData\web\catalog\paint\root\shared\demo
paint%2eregion.atr
paint%2eregion
1,248 paint
86 paint.atr
1,293 paintdemo
paintdemo.atr

[ 本帖最后由 北冥 于 2008-3-19 15:13 编辑 ]

北冥

中场休息一下。
翻收藏夹的时候发现BIC2GO的链接了，简单介绍下，好东西！

Oracle Business Intelligence Challenge 2 Go，简称BIC2GO：
http://bic2g.oracle.com/
按网页上的介绍，该站由Oracle北美销售队伍维护，内外人员皆可访问。
我能找到许多我关注和需要的。

Event页面会列出最近enable partner的培训，不过中国的，基本没有呵呵。
http://etc-us.oracle.com/pls/ptc/f?p=139:3:767939872927689

Support页面上资源列表很齐全：
http://bic2g.oracle.com/BIC2G_EE_Support.htm
比我上一帖子全多了：
Web Resources
Oracle Business Intelligence (10.1.3.2.0) Downloads & Documentation
OBI EE Documentation
OBI EE Oracle By Example Hands-on Training
OBI EE News, Technical Info, and Demos
OBI EE 10.1.3.2 New Features
OBI EE 10.1.3.2 System Req'ts and Supported Platforms
Fusion Intelligence for EBS
Fusion Intelligence for Peoplesoft EPM
Oracle BI Applications (former SBA Applications)
Oracle Partner Network -- Product Focus Areas
Product Focus Area -- Oracle BI
Oracle University Certification Upgrade
Oracle Information Applicances
Oracle Warehouse Builder Roadmap
Oracle Data Integrator on OTN
Oracle Data Integrator Statement of Direction

北冥

Blog越来越成为主题搜索的目的地了，比如Venka的blog，经常都能找到我要的，伊是Oracle的员工呵呵。
还有一些可能非Oracle相关维护的blog，比如Rittman和John Minkjan的，前面提过。
加一个Majendi的，http://majendi.blogspot.com/
另John的101系列挺好玩的，内容不多，浏览一遍不需要几分钟。OBI EE 101的内容算比较丰富了的。
http://www.blogger.com/profile/08228393663535024706
有趣的一点是他和Venka两人的主题最近总撞车，猜两人都是就Forum上的问题研究的，敬佩ing.

北冥

W-Writeback
可以参考下：
http://www.itpub.net/thread-956153-1-1.html
补充下具体步骤吧，虽然文档上足够详细(Configuring Report Write Back一章)：
Using the Administration Tool, configure the new table:
注意：
1，Disable the Make Table Cacheable property for the write back table in the Physical Table window.This ensures that data written back to the database is displayed to the user, and not a cached value.
2， Enable write back for the connection pool.
3， Create a write back template that specifies the SQL necessary to both insert and update values into the table you created.
模版的存放位置也讲究的：\\OracleBI\web\msgdb\customMessages，模版文件名字无关，默认是load该目录下所有xml文件的。所以没事别乱放无关的xml文件，会有影响的肯定。
Template Sample:
------------------------
<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="wb">
<XML>
<writeBack connectionPool="sh">
<insert>insert into LastName values('@{c0}')</insert>
<update>UPDATE LastName SET LastName = '@{c0}'</update>
<postUpdate>COMMIT</postUpdate>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
------------------------
这里面有个<postUpdate>COMMIT</postUpdate>的问题。官方文档上说：
■ If a parameter's data type is not an integer or real number, then add single quotes around it. If
the database does not do Commits automatically, then add the optional postUpdate node after
the insert and update nodes to force the commit.
我的db写上这句就会报错，虽然能正确回写。所以去掉，默认是自动提交的。
还有一点，如果你的回写和insert无关，那么只能是<insert> </insert>，注意中间的空格，这是必要的。<insert></insert>或者<insert/>都不接受。

4， In Oracle BI Presentation Services, grant write back privileges:
5， In Answers, configure write back reports.

[ 本帖最后由 北冥 于 2008-3-19 14:41 编辑 ]

北冥

[ 本帖最后由 北冥 于 2008-3-19 14:56 编辑 ]

北冥

zaiqilianqi

福音呀，谢谢