Generating Custom Group members using SQL
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