OBIEE Tips #5: Too many values in single select prompt

转载 2012年03月24日 07:51:24

OBIEE’s single select prompt can’t display by default more than 256 values (It displays a “Too Many Values” value at the end of the list when the number of values is greater than 256).

This can be fixed in two ways:

1) edit the instanceconfig.xml file by adding the following line:

1 <Prompts><MaxDropDownValues>MAX_VALUES</MaxDropDownValues></Prompts>

where MAX_VALUES is the number of values the prompt will display.
Take care: a big value could affect the performances.

2) Change the single-select value prompt to the multi-select value prompt. Multi-select value prompt displays all the values without limitation.

By default it displays the first 50 values and a link to show the next 50 and so on.
This value can be modified; just edit the instanceconfig.xml file by adding the following line:

1 <Prompts><MaxScrollValues>SCROLL_VALUES</MaxScrollValues></Prompts>

where SCROLL_VALUES is the values’ range number to show.

3) If you need to use a single select prompt because of business requirements, the best way is to create a first prompt by which you can select a first subset of values and constrained the next one on that.

The example above has been done quickly by changing the “Starts With” prompt formula that generates the range values with the following code:

01 CASE
02 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'A' THEN 'A-F'
03 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'B' THEN 'A-F'
04 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'C' THEN 'A-F'
05 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'D' THEN 'A-F'
06 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'E' THEN 'A-F'
07 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'F' THEN 'A-F'
08
09 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'G' THEN 'G-L'
10 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'H' THEN 'G-L'
11 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'I' THEN 'G-L'
12 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'J' THEN 'G-L'
13 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'K' THEN 'G-L'
14 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'L' THEN 'G-L'
15
16 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'M' THEN 'M-R'
17 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'N' THEN 'M-R'
18 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'O' THEN 'M-R'
19 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'P' THEN 'M-R'
20 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'Q' THEN 'M-R'
21 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'R' THEN 'M-R'
22
23 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'S' THEN 'S-Z'
24 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'T' THEN 'S-Z'
25 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'U' THEN 'S-Z'
26 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'W' THEN 'S-Z'
27 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'X' THEN 'S-Z'
28 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'Y' THEN 'S-Z'
29 WHEN SUBSTRING("D5 Employee"."E01 Employee Name" FROM 1 FOR 1) = 'Z' THEN 'S-Z'
30
31 ELSE 'UNKNOWN'
32
33 END

That should not be done in a production environment; infact it’s better to map the range values in a table and add the appropriate business logic.

CDH分支节点无法被监听,错误提示ValueError: too many values to unpack

检查系统是否安装有两个版本的JDK,配置文件是不是指向了oracleJDK,我的情况是指向了openJDK,就先按照我的另一个博客(http://blog.csdn.net/data8866/arti...

关于 Python opencv 使用中的 ValueError: too many values to unpack

关于 Python opencv 使用中的 ValueError: too many values to unpack
  • jjddss
  • jjddss
  • 2017年05月24日 11:21
  • 2677

亚马逊服务器(Linux 3.13.6)A very large skb can span too many pages (more than 16) to be put in the driver

Brendan Gregg's Blog  home Linux perf Rides the Rocket 11 Sep 2014 Riding the rocket ...

nginx报错accept4() failed (23: Too many open files in system)

今天系统进不去了,用ssh连接服务器也非常慢,负载均衡显示后端连接异常,但是通过telnet命令查看后端端口是正常的,用其他的服务器telnet这台服务器的端口,不通,感觉很奇怪。首先自己先写了一个测...

【跟着stackoverflow学Pandas】Select rows from a DataFrame based on values in a column -pandas 筛选

Select rows from a DataFrame based on values in a column -pandas 筛选 https://stackoverflow.com/quest...

Too many open files 解决方法

  • 2012年12月20日 17:42
  • 2KB
  • 下载

INSERT小记(insert into select和not in,values括号里不能放select)

记一次初学愚蠢经历,如果未来发现更好的方法,也算留念

Too many open files 问题的解决.txt

  • 2012年03月28日 10:51
  • 5KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:OBIEE Tips #5: Too many values in single select prompt
举报原因:
原因补充:

(最多只允许输入30个字)