BIEE 常见问题解答 下载本文

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;} or

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

个性化汇总查询:

Region East Central West South (East + Central) Summary (West + South) Summary Total Sales Total 100 200 300 400 300 700 1000 BIEE can do it easily in pivot view.

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

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

信息 原来:

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

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

@{biServer.variables['NQ_SESSION.USER']} @{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 \= 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 to

OracleBIData\\web\\msgdb\\customMessages\\commonuitemplates.xml (DONOT MODIFY THIS FILE DIRECTLY)

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

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: