当前位置：文档之家› BIEE常见问题

BIEE常见问题

仪表板： (3)

仪表板分组下拉显示： (3)

设置默认的仪表板： (6)

撤销页面“刷新“按钮(不建议) (7)

如何跳过注销页面，直接跳转到登陆界面 (8)

交叉表行数限制 (8)

报表显示上的列级别控制 (9)

报表中现实自己有权限访问的第一个列 (9)

仪表盘顺序定制 (9)

时间细度不一样 (10)

Prompt值显示的顺序定制： (10)

表格下的“125－”是1到25条记录的显示方式,需要改成“1－25”（附图） (10)

查询大数量时，出现等待提示，可以在下面修改 (11)

Dashboard中钻取返回提示修改： (11)

友好打印PDF中的空格 (11)

Answer中的主题文件夹层次现实： (12)

Excel下载如果不自动变成科学计数法： (12)

如何强制Answer中列的宽度 (12)

个性化汇总查询： (13)

在仪表板上加入当前client日期显示： (14)

在Answer的Titel中加入变量显示： (14)

客户化仪表盘右上角的产品清单，如去除等多产品中的Marketing (15)

在仪表板制定位置显示Deliver的内容 (15)

OBI EE and oracle stored procedures WITH parameter passing (15)

如何将Go URL中的“页选项”按钮去除 (17)

Configuration for the Dashboard Prompt Types Feature (18)

图形： (20)

中文显示方块问题 (20)

BIEE中雷达图中文显示问题： (20)

图形鼠标点到的地方的值的背景希望是透明的： (20)

BIPublisher Chart Description (20)

图形出现“Evaluation Time Limit“ (21)

指定BIEE中图形的类型(flash,SVG,PNG) (21)

图形中“上”字，“名”字和“作”字的链接错误 (21)

配置和服务 (23)

几处配置文件的作用优先级别 (23)

禁止OC4J自动启动 (23)

如何在Office 2003中启用BIEE Excel Add-in (23)

BIP (24)

BI Publisher 和Oracle BI Server 的安全集成 (24)

报表复制 (26)

RDF to RTF Template Generator (26)

RDF to Data Template Generator (26)

其他 (26)

修改BIEE中的用户密码 (26)

BIEE和其他应用集成，如果出现频繁登录提示： (31)

Metadata report (31)

Oracle BIEE性能提高 (32)

使用BIP和iBot中的外部认证 (32)

BIEE 10.1.3.2中ibot的配置： (33)

其他Web程序调用BIEE的报表方式： (33)

其他Web程序调用BIEE的仪表板方式： (34)

Customizing OBI EE – GO URL Parameters (35)

从BIEE的报表链接到其他系统： (38)

Writeback for dashboard commentary in OBI EE (39)

Siebel Analytics Web Catalog 升级到Oracle BIEE Presentation Catalog (45)

How To Log An Oracle Support Service Request Via SupportWeb for Oracle Business

Intelligence Enterprise Edition (OBIEE) (48)

Applies to: (48)

Goal (48)

Create SR for BIEE from metalink: (50)

仪表板：

仪表板分组下拉显示：

1．配置instanceconfig.xml，加入的配置，然后重启BI presentation server.

数字3表示，当一个组的仪表板数量大于等于3时，会将仪表板分组下拉显示。

2. 添加用户组和仪表板，因为我们上面配置的数字是3，所以当Dashboard数量超过3时，就会出现Dashboard Group的排列了。

2）创建新目录组

同上再创建两个Dashboard: G1Dashboard2,G1Dashboard3

3．重新登陆就能看到结果

设置默认的仪表板：

1）用户自己定义默认仪表板：

用户登录后，点击设置-> 账户

在首选项中，可以设置自己希望的缺省仪表板：

2）方法2：系统设计中设计方法：

Default dashboard can be defined by administrators by setting a PORTALPATH session variable for the user. Search the Server Admin guide in bookshelf for PORTALPATH for more info.

You can create on the RPD a system variable called PORTALPATH pointing to default dashboard, e.g. :PORTALPATH='/shared/Production/_portal/New Dashboard'法3：

To hide the mydashboard from the dashboard area you can go to admin, click on manage priveleges and in the catalog section, Remove the permission for everyone for Personal Storage My folder and My Dashboard.

撤销页面“刷新“按钮(不建议)

As a workaround here is the instruction disable the refresh button :

1. The XML file to modify is called controlmessages.xml and this file is located in the \SiebelAnalytics\Web\App\Res\Messages folder.

2. In that file you'll find the following lines for the Refresh Button (they're very long lines so I took out the commented bits (unused code between !):

onclick="RefreshPage('@{sawCmd}[javaScriptString]&PortalPath=@{portalPath}[jav aScriptString]&Page=@{pageName}[javaScriptString]');return false;"

title="@{title}">

border="none">

3. Comment the whole thing out between and the closing tag with .

4. Then add the following line instead:

5. Save this file in the SiebelAnalytics\Web\Res\CustomMessages folder. Then restart IIS, SAW (Siebel Analytics Web) and SAS (Siebel Analytics Server) services.

Note: It is suggested the use of the SiebelAnalyticsData folder instead just so that upgrading Analytics does not remove this change. No changes should be kept in the

SiebelAnalytics\Web\Res\Messages folder.

Note 2: You should leave on the SiebelAnalytics\Web\Res\CustomMessages folder the controlmessage.xml file with the alterations described above. You should not leave any copy of the original controlmessages.xml file on this folder.

(for all the xml config files will be load into server under this folder I think)

6. I would finally suggest you that before changing any .xml file, please do a backup and save it in a different folder.

如何跳过注销页面，直接跳转到登陆界面

定制$SAW_HOME/Web/App/Res/messages/logoncontrolmessages.xml

修改...的内容

将下面的内容添加到之前

交叉表行数限制

CubeMaxRecords and CubeMaxPopulatedCells are 2 variables set in instanceconfig.xml or the registry and are used for tuning Pivot Table output. BE CAREFUL WITH THESE THOUGH...Setting to high can bring the SAS to a grinding halt...ask why so many records are needed in this particular report?

----------------

Maximum Number of Records To Process in a Siebel Analytics Pivot Table

We can override the maximum number of records that can be processed by a pivot table. The internal default is 20000.

Maximum Number of Populated Cells in a Siebel Analytics Pivot Table

We can override the maximum number of populated cells that Siebel

Analytics Web allows in a pivot table. The internal default is 150000.

报表显示上的列级别控制

Administrator中我们可以控制每个列用户和组的访问权限，当一个用户访问的表中存在自己没有权限访问的列时，默认他会得到以下错误：

如果你希望他能看见这张表，只是不能看见他没有权限访问的列时，我们可以在NQSConfig.ini 文件中设置：

[ SECURITY ]

DEFAULT_PRIVILEGES = READ;

PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;

报表中现实自己有权限访问的第一个列

In Answers for the column formula use:

CHOOSE(columnA, columnB etc.). If the user has access to ColumnA, then that is returned, else it tries columnB and so on.

修改[OracleBI]\web\msgdb\l_zh\messagesutilmessages.xml

复制到：【BIEE】\OracleBI\web\msgdb\customMessages

仪表盘顺序定制

add blank between dashboard name

时间细度不一样

1)One fact table stores data in month level.

2)One fact table stores data in day level.

3)I want to show the data from these two fact tables in one answer report in month level.

You will need One logical Time dimension table that will source data from 2 physical time dimension tables (using 2 Logical Table Source), one at a day granularity and the other at a month granularity. At the physical layer, Fact 1 will join to the month grain dimension table whereas Fact 2 will join to the day grain dimension table.

Prompt值显示的顺序定制：

增加排序字段，按要求定制权值，例：

SELECT DW_DM_SJ.NF FROM JC_ZYFY order by case when DW_DM_SJ.NF <'2005年' then 1 else 2 end desc

表格下的“125－”是1到25条记录的显示方式,需要改成“1－25”（附图）

修改：BIEE\OracleBI\web\msgdb\l_zh\messages\reportgeneratorsmessages.xml

将下面部分：

记录 -

记录 - （所有记录）

记录 - （结束）

system="WebReportGenerators" table="Exceptions">

改成：

记录 -

（所有记录）

记录 -

（结束）

重新启动BI Presentation Server

查询大数量时，出现等待提示，可以在下面修改

当在查询过程中，如果数据量大，会出现刷新图标，旁边有个“取消”链接。如果点“取消”链接，会出现BIEE 页面上方所有主题的区域，跟在请求中调仪表盘出现的现象一样。

修改：BIEE\OracleBI\web\msgdb\l_zh\messages\viewmessages.xml 文件，并将修改后的文件复制到

\BIEE\OracleBI\web\msgdb\customMessages\文件夹下，文件名不变

重新启动BI Presentation Server

正在搜索 ...要取消，请单击此处。

成你希望的提示语言，或者直接删除，不让用户看见

Dashboard中钻取返回提示修改：

用“导航”方式开发的下钻功能，在页面的左下角会出现“返回”按钮，不管下钻了多少层，点击“返回”按钮都返回到首页。希望或者去掉此按钮，或者将此按钮的名称改为“返回首页”。

复制 D:\oracle\product\BIEE\OracleBI\web\msgdb\l_zh\messages\viewmessages.xml 到：

D:\oracle\product\BIEE\OracleBI\web\msgdb\customMessages

修改返回成：

返回主页

重新启动BI Presentation Server

友好打印PDF中的空格

仪表盘页左下角的“友好打印机”按钮，关于打印成“PDF”格式的文件。开发的时候在叙述中加入的（空格），在pdf格式的文件中都显示成“ ”编码。（附图）

请在叙述中直接使用空格（全角），而不是，如果要换行，请直接使用叙述中的换行符。

如果要修改布局排列，请点击组合布局中“叙述”的“格式化试图”按钮

Answer中的主题文件夹层次现实：

做法：

在administrator中，presention中，点击表名称

在description中，增加描述性字符，之前加上-> 就可以了

Excel下载如果不自动变成科学计数法：

Concatenate char(30) in the Answers,eg: char(30)||'888888888888888888'. Excel will filtrate char(30) automatically

如何强制Answer中列的宽度

Using custom CSS pls

{word-break:break-all; width:200px;}

{word-wrap:break-word; width:50px;} 如下图：

个性化汇总查询：

在仪表板上加入当前client日期显示：

将D:\Oracle\BIEE\OracleBI\web\msgdb\l_zh\messages\uimessages.xml文件中，修改最后倒数第二行的信息

原来：

欢迎使用

insert="1"/>!

改成：

，您好！今天是<SCRIPT language=JavaScript type=text/JavaScript> tmpDate = new Date();date = tmpDate.getDate();month= tmpDate.getMonth() + 1 ;year= tmpDate.getYear();document.write(year);document.write("年

");document.write(month);document.write("月

");document.write(date);document.write("日

");</SCRIPT>

此时间为访问者客户端PC上的时间，而并非服务器时间。

在Answer的Titel中加入变量显示：

@{biServer.variables['NQ_https://www.doczj.com/doc/8c2340178.html,ER']}

@{biServer.variables['NQ_SESSION.GROUP']}

The default format for the Presentation Variable is as follows :

@{VariableName}[FORMAT]{VariableValue}

If you wish to instantiate a Presentation Variable in the Title view and use it , you could put something like this ...

Presentation Test = @{mytitlevar}{123} in the title , which would display as "Presentation Test = 123".

Additionally if you do not wish to supply value to the variable, you could just put the following ... @{mytitlevar}{}

Please note , the [FORMAT] will be applied on the VariableName and not the variable value. Some examples here :

@{myFormat}[999.99]{123} ... will display as 123 (format mask 999.99 is not applied)

@{system.currentTime}[dd/MMMM/yy] .... will display as 11/September/07 (format mask

dd/MMMM/yy is applied)

You should be able to use these in the Title / Sub Title area of the Title view

Additionally these will work in Static Text View and Narrative.

客户化仪表盘右上角的产品清单，如去除等多产品中的Marketing

Copy OracleBI\web\msgdb\messages\commonuitemplates.xml

OracleBIData\web\msgdb\customMessages\commonuitemplates.xml

(DONOT MODIFY THIS FILE DIRECTLY)

Modify this config xml file, delete the customized part as your wish, eg:

target="@{target}">

Restart the presentation service.

If you just want to customize the display, do the similar operation for file uimessages.xml.

在仪表板制定位置显示Deliver的内容

“_Delivers”

OBI EE and oracle stored procedures WITH parameter passing

In 10.1.3.2 you could not execute a stored procedure directly in the connection pool, but need to next it in a function. Here is an example:

CREATE or replace PROCEDURE prc_apply_security (

v_user in varchar2) as

BEGIN

-- clear context

prc_set_security('lausd_context','school','');

-- set user context

prc_set_security('lausd_context', 'user', v_user);

upper(sys_context('lausd_context','user')) = 'ELEMENTARYVPD' THEN

prc_set_security('lausd_context','school','ELEMENTARY SCHOOL 1');

END IF;

END;

Since BI EE does not see to be able to call a procedure directly ('call' does not work), imbed in function..

CREATE OR REPLACE function fn_apply_security

(bi_user in VARCHAR2)

RETURN VARCHAR2

AUTHID CURRENT_USER

PRAGMA AUTONOMOUS_TRANSACTION;

v_result VARCHAR2(4000);

BEGIN

prc_apply_security (bi_user);

v_result := 'prc_apply_security executed';

RETURN v_result;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

v_result := 'Error calling procedure prc_apply_security';

RETURN v_result;

END;

-- ***************************************************************************** -- BI EE CONFIGURATION

-- ***************************************************************************** ENTER IN THE BI EE CONNECTION POOL (don't enter the ; at the end of the SQL stmt) select fn_apply_security(':USER') from dual

参考：

从adiministrator中调用：

https://www.doczj.com/doc/8c2340178.html,/2007/08/29/obi-ee-10133-and-vpd/

从answer中调用：

https://www.doczj.com/doc/8c2340178.html,/2007/09/10/oracle-bi-ee-10133-support-for-native-database-fun ctions-and-aggregates/

如何将Go URL中的“页选项”按钮去除

在D:\Oracle\BIEE\OracleBIData\web\config\instanceconfig.xml文件上面加入以下内容：

False

用Administrator登陆BIEE，在设置->管理，选择管理权限

将仪表盘中的，“保持选择”和“分配缺省选择”权限不要分配给不希望看见“页选项”按钮的用户或者组

这样普通用户就看不见“页选项”按钮了。

对于可以修改这个仪表板的用户，他们仍然能看见“修改仪表板”的链接。你可以用Administrator通过设置->管理，选择“管理介绍目录”将相应的仪表板的修改权限不分配给这些用户。

Configuration for the Dashboard Prompt Types Feature

This section explains how to configure the new Dashboard Prompt Types

feature.

For configuration, the Create Bookmark Link is enabled by default. The following nodes must be added to the instanceconfig.xml under the "ServerInstance" node:

True

"EnableBookmarkURL" controls whether or not the "Create Bookmark Link" is

shown in the "Page Options" menu while "EnablePromptedURL" controls the appearance of the "Create Prompted Link." The Bookmark Link refers to a stub saved in the Presentation Services catalog and "BookmarkExpirationDays" allows an administrator to set a lifespan for how long these should persist. Please see the "Making Oracle BI Presentation Services Configuration Changes" section within the Oracle Business Intelligence Presentation Services Administration Guide for more information on editing the instanceconfig.xml

configuration file.

For advanced applications, and for both the "Create Bookmark Link" and "Create Prompted Link" functionality, two Javascript functions can be called to retrieve these values from custom scripts embedded on the originating Dashboard Page. Note, for Javascript functions to work a HardenXSSconfiguration must be set to false in instanceconfig,xml.

For the Bookmark Link, the function linkToPage(bInlineDrill,bGetBookmarkOnly) can be called. If the second argument is omitted or set to "false," the browser address bar will be updated with the bookmark URL. If the second argument is set to "true," the browser address bar won't be refreshed. In either case, the bookmark URL is retrieved asynchronously and put into variable

saw.bookmarkURL. Polling the value of saw.bookmarkURL will give the link. This variable is set to empty string when the function is invoked. As for the first argument, if you see the "Page Options" menu on the page, set it to true, otherwise, set it to false.

For the Prompted Link, the function GetPURL( ) returns the Prompted Link as a string.

图形：

中文显示方块问题

更改web用户的个人区域设置为中文

老版本的解决方法：

\j2ee\home\applications\analytics\analytics\res\s_oracle77\popbin

\maui\web\config\chartfontmapping.xml

\maui\Corda50\bin\CordaFontConverter.exe相应字体文件

且适用于某些特殊图表类型（比如Radar）的字体定制

BIEE中雷达图中文显示问题：

1.修改\OracleBIInstallDir\web\app\res\s_oracle10\popbin\radar.pcxml 文件

2.找到部分

3. 3. 作如下的修改：

MaxLengthHorizontalText='40' MinorTick='Size:Large;' Font='Name:Albany WT SC;Size:19;'

4.MinorFont='Size:20;'/>

5.重启Java Host和Presentation 服务

图形鼠标点到的地方的值的背景希望是透明的：

1. 在[OracleBI]\web\app\res\[s_皮肤名称]\popbin目录下，查找相关图形的.pcxml文件

2. 编辑文件，找到DataLabels的标签，修改其中的属性：TransparentBackground='True'

3. 复制此文件到：OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\[s_皮肤名称]\popbin下（这是你部署BIEE的应用服务器的位置，请根据情况注意）

4. 重新启动Oracle BI Java Host和Oracle BI Presentation Server 两个服务。

所有的默认图形（没有自己定义过字体的）都会现实背景是透明的。

BIPublisher Chart Description

https://www.doczj.com/doc/8c2340178.html,/xmlpublisher/2006/07/31#a65

https://www.doczj.com/doc/8c2340178.html,/xmlpublisher/2007/02/22#a161

D:\oracle\maui\xmlp\Desktop\Template Builder for Word\fonts -〉

C:\Java\jdk1.5.0_09\jre\lib\fonts（要有相应的中文字体才能正常显示中文）