I am trying to run a report that access two different universes and I am using Account ID as the Unique identifier for both.
I want my second query to only return results that link to the first query and I have done this through using “Account ID In List of the query result first universe.account ID” in my condition on my second query.
However, I am getting the error ORA-01795: maximum number on the list is 1000. I was told that this could be cause of the ‘In list’ function that I am using, but I have tried ‘equal to’ as well, i.e.“Account ID Equal to of the query result first universe.account ID” and it still throws up the same error.
Is there any way to get around this? Anyone come across this?
Many thanks for your help in advance.
slop (BOB member since 2008-06-24)