I have a report that will end up containing multiple queries. Query 1 lists
amounts by accounts by cost centers. There are conditions for specific cost
centers and accounts in this query. Query 2 has the same objects, but has a
condition to return 1 account (this account is not returned in query 1).
When the 2nd query is run, a row for that account shows up in the table from
query1. The value for that account is blank in the query1 table. The
second query’s table looks ok. Any ideas on what is happening here?
Thanks in advance.
Mike Yarbrough
Infometric Systems Corporation myarbrough@sjmc.org
One thing that you could check is to see if the queries are being
automatically
linked. When you have multiple queries in a report, Business Objects will
link the data providers if any one of the dimension objects has the same
object.
To check this you need to go into the data manager window. From main menu
select “Data” then “View…”. Open one of the data providers and click
on your dimension objects. The image of the dimension (blue cube) will
contain
an arrow in it.
To remove the link, highlight the dimension object, click on the definition
tab. At the bottom of the tab, you will see a “Unlink” button. Click the
button. You will need to do this for all dimension objects that have the
arrow in the image.
Thanks
Jeff Moore
Electronic Data Systems
Hello all,
I have a report that will end up containing multiple queries. Query 1
lists
amounts by accounts by cost centers. There are conditions for specific
cost
centers and accounts in this query. Query 2 has the same objects, but has
a
condition to return 1 account (this account is not returned in query 1).
When the 2nd query is run, a row for that account shows up in the table
from
query1. The value for that account is blank in the query1 table. The
second query’s table looks ok. Any ideas on what is happening here?
Thanks in advance.
Mike Yarbrough
Infometric Systems Corporation myarbrough@sjmc.org