Archive for the ‘Universe Design’ category

Split and Search

October 22nd, 2009

Presented at the GBN conference on a way to provide users the way to enter a comma delimited list of values into a prompt and then use a database function to split those values in order to return the list as a table that can be used in joins.

WHERE rs_tb_cms_groups.group_ID IN ( SELECT rs_tb_cms_groups.group_ID FROM @Prompt(‘Group
Name ‘,’A',{‘California’,'New York’},mono,constrained,not_persistent,))

If anyone wants the full article including the Oracle and SQL server code please contact Kevin McManus at answers@mcmanusconsulting.com

GBN/BOUG Conference 2009 Dallas

October 20th, 2009

Best Business Objects conference I have been to. What as missing in free entertainment was replaced with better content. More in depth training on Xcelsius, Universe Design , web intelligence and Crystal Reports.