Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Generating Custom Group members using SQL

VictorFagundo
Member Posts: 16
Greetings,
I have a need to create a more user friendly "All Column Values" heading than the default supplied by BI 11.
Using this method i can accomplish that:
http://blog.guident.com/2012/10/customizing-obiee-11g-prompts-all-column-values-to-a-custom-value/
however in this method you have to manually select all the members that are to make up your new group.
Is is possible to select members using SQL?
-VAF
I have a need to create a more user friendly "All Column Values" heading than the default supplied by BI 11.
Using this method i can accomplish that:
http://blog.guident.com/2012/10/customizing-obiee-11g-prompts-all-column-values-to-a-custom-value/
however in this method you have to manually select all the members that are to make up your new group.
Is is possible to select members using SQL?
-VAF
Answers
-
Use {} or try out as below
http://www.cool-bi.com/Tweaks/AllColumnValues.php -
Hi Srini,
Thanks for your response, but I'm not trying to pass the "all values" through a presentation variable. Rather I'm attempting to create a CUSTOM naming for "(ALL COLUMN VALUES)"
Example, I have a dimension that is a list of products with 20K+ distinct values. On the prompt that filters this dimension i want the "All Column Values" selection to display as "All Products".
The article i linked in my original post shows how to do this using a custom group, but the author selects the 50 members manually. This works if your dimension is something like states, but not for my "products" dimension that has 20k+ members.
Furthermore it would be useful to have the custom group only made up of SELECT members that i chose with a SQL statement, such as all members with sales > 100k for the last 6 months.
Yes giving the "All column values" a custom name is splitting hairs, but the summation of small tweaks like this is what sets apart "intuitive" reports from "bulky" reports.
Possible? -
You can mention your custom name for all values in the 'default value' part.
Syntax:
@{Presentation Variable}{Default value}
Example:
@{v_products}{All Product Values}
So when my selection is open for all products, it will display "All Product Values".
This discussion has been closed.