Prompted Union Queries

building reports desktopintelligence
1

Kasey,

Try entering your values delimited with a SEMI-COLON. That should return
rows for your query. There is a long-winded explanation that I will try to
spare you. Just try it and see if that corrects the situation.

Also… is this a Universe Variable that prompts you or a script?

Thanks!
-rm

Listserv Archives (BOB member since 2002-06-25)

2

Make sure you enter them CUST1,CUST2,CUST3. Don’t put a space in like
CUST1, CUST2, CUST3.

Listserv Archives (BOB member since 2002-06-25)

3

In a message dated 99-03-12 16:40:14 EST, you write:

  I have a user who has created a prompted union query.  The prompt is
  an in list and asks for customer id.  If we enter any one of several
  customer ids and run the query data returns.  If we enter more than
  one customer id (separated by a comma) there is no data to fetch.

There is an inconsistency in the way BusObj parses prompted values. On the
Query Panel you must enter items separated by a comma, with no embedded spaces
as Steve mentioned. On a prompt window you must enter the items separated by
a semi-colon, again with no spaces.

Note: if you can use the “Values” button or the “Show List of Values” operator
then the entries will be filled in correctly.

The reason you are getting “No Data to Fetch” when using the comma as a
separator on the prompt is that BusObj is looking for a single customer ID
that looks like:

“value1,value2,value3”

In other words, it is not parsing the entries into separate values. Since
there is no single customer id that matches that value, you have “no data to
fetch”. This is a “user education” issue, unfortunately!

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)