I was wondering if someone could help me with this problem I am having
when I try to combine queries from different universes.
SQL #1 from universe A contains 2 objects (ISBN & TITLE)
SQL #2 from universe B contains 2 objects (ISBN & STD. COST)
All four objects are dimension objects.
I run these SQL's separately and place them into separate reports.
I go into the data manager and link ISBN from SQL 1 to SQL 2.
I then insert a third report and insert a table. I walk through the
wizard and indicate I want to 'Insert existing data from the
document'. B.O. then lists the above 4 variables. When I select ISBN
& TITLE from SQL 1, the STD. COST object becomes grayed out and I am
not able to select it.
How do I correct this so I can select the STD. COST object as well.
Rob V.
Pearson Education
I was wondering if someone could help me with this problem I am having
when I try to combine queries from different universes.
SQL #1 from universe A contains 2 objects (ISBN & TITLE)
SQL #2 from universe B contains 2 objects (ISBN & STD. COST)
All four objects are dimension objects.
I run these SQL's separately and place them into separate reports.
I go into the data manager and link ISBN from SQL 1 to SQL 2.
I then insert a third report and insert a table. I walk through the
wizard and indicate I want to 'Insert existing data from the
document'. B.O. then lists the above 4 variables. When I select ISBN
& TITLE from SQL 1, the STD. COST object becomes grayed out and I am
not able to select it.
How do I correct this so I can select the STD. COST object as well.
Hi Rob:
The reason you are not able to select the STD. Cost is because it is a
Dimension and it is not linked to Title (probably shouldn’t be). If it were
a measure, you should be fine. Generally speaking, when you try to link
data providers and want to select dimensions from both data providers, you
can only choose all dimensions from one of the data providers and the
linked dimensions from the other. You can however select any measures from
both as long as you have the common dimension(s) from one of them.
If you need more details on linking data providers, let me know and I’ll be
glad to help.
Regards,
Chander Aggarwal
COMPUEXCEL http://www.compuexcel.com
The home of BusinessObjects Essentials - the Worlds First and Leading Full
Multimedia Computer Based Training For BusinessObjects, with over 15,000
users world-wide!
This is due to a bug in the software. Tech Support gave me a
workaround until this is fixed.
1) After you run your two queries, Data >> View >> Link ISBN from
Universe A to ISBN from Universe B. Then Link Title from Universe A
to STD in Universe B.(Even though this probably doesn't make sense to
do)
2) Insert third report and insert table. Choose "Insert existing
data", then choose all 4 objects (none of them should be greyed out).
The data may look odd for the columns you linked but logically should
not have been linked.
3) Go back to Data >> View and unlink Title from STD.
4) The data should look right now.
The trick is to link all of the dimension objects (or as many as
possible) between queries even if they should not logically be linked,
then setup your combined table, then unlink the extra objects. This
will enable you to select any object when inserting the third table.
Please let me know if you have any questions.
Thanks,
Caren Katz
Hartford Investment Management Company
caren.katz@thehartford.com
Regarding . .
"try to combine queries from different universes.
SQL ¶1 from universe A contains 2 objects (ISBN & TITLE)
SQL ¶2 from universe B contains 2 objects (ISBN & STD. COST)
All four objects are dimension objects.
I run these SQL's separately and place them into separate reports.
I go into the data manager and link ISBN from SQL 1 to SQL 2.
I then insert a third report and insert a table. I walk through the wizard
and indicate I want to 'Insert existing data from the document'. B.O. then
lists the above 4 variables. When I select ISBN & TITLE from SQL 1, the
STD. COST object becomes grayed out and I am not able to select it"