Hi, Listers,
We are trying to create a query against our Remedy system that will give us a list of Customers where the CustomerName field has more than four records for a customer. We’re having trouble building the query. We’re in BO 5.01. Any ideas?
Michael Welter
Sr. Technical Analyst
AirTouch
Listserv Archives (BOB member since 2002-06-25)
Michael.
Can’t you build a query to return all the rows, then add a column and apply a filter where the column > 4 ?
Hi, Listers,
We are trying to create a query against our Remedy system that will give us a
list of Customers where the CustomerName field has more than four records for a
customer. We’re having trouble building the query. We’re in BO 5.01. Any ideas?
Michael Welter
Sr. Technical Analyst
AirTouch
Listserv Archives (BOB member since 2002-06-25)
Hi Michael,
If use a condition in your query panel based on your measure object, this should be ‘translated’ to a HAVING clause in you query (e.g. HAVING count(cust_id) > 4).
May be this one helps ?
Kind regards,
Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be
Listserv Archives (BOB member since 2002-06-25)
Darren,
I thought of that, but the database is pretty large and I’d rather not return all rows. The microcube would come back as a maxicube. 
Michael
Can’t you build a query to return all the rows, then add a column and apply a filter where the column > 4 ?
Listserv Archives (BOB member since 2002-06-25)