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: