If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issues with Person Address

Started by jb2321, 20 Oct 2011 10:17:54 AM

Previous topic - Next topic

jb2321

We have a few reports that have to pull street, city, state, and zip from Person Address and these reports take an extreme amount of time to complete.  We have tried filtering address by various address rules that are setup with minimal success.  Has anyone encountered anything similar when attempting to pull address information or know of any tips and tricks to pull address in a timely fashion.  Thanks...

blom0344

Quote from: jb2321 on 20 Oct 2011 10:17:54 AM
We have a few reports that have to pull street, city, state, and zip from Person Address and these reports take an extreme amount of time to complete.  We have tried filtering address by various address rules that are setup with minimal success.  Has anyone encountered anything similar when attempting to pull address information or know of any tips and tricks to pull address in a timely fashion.  Thanks...

Person Address? 

Are you refering to a certain table? Did you check whether query-time is excessive? Are you explicitly sorting the data by to many levels?
Hard to give any advice without a lot more specific details..