If I have one universe built off of a SQL Server, and another built off of Access, I know that I can link them together to form one universe. Can the user select objects from both areas in one query and be successful?
Tim K Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager
heuer_tk@exchange.phs.com
Listserv Archives (BOB member since 2002-06-25)
I believe the anwser is no.
One of the criteria for derived universes is that they are created from the same database. The reason being is that the derived universe’s Database Connection Parameters are applied for all the linked-to universes. In your example, if SQL server is the derived universe linked to an Access based universe, then BO will attempt to look for the Access objects in SQL Server and not find them.
Hope that helps.
Tim K Heuer wrote:
If I have one universe built off of a SQL Server, and another built off
of Access, I know that I can link them together to form one universe. Can the user select objects from both areas in one query and be successful?
Tim K Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager
heuer_tk@exchange.phs.com
Listserv Archives (BOB member since 2002-06-25)
In a message dated 98-06-26 10:42:53 EDT, you write:
If I have one universe built off of a SQL Server, and another built off of Access, I know that I can link them together to form one universe.
Um, no, I don’t think you can link universes that have different connections. At least if you are talking about using the “linked universe” feature of Designer. You can only link universes (in Designer) that share the same connection. Therefore you cannot link universes that point to a different type of database.
Can the user select objects from both areas in one query and be successful?
Which makes this question a moot point.
Several ideas:
You can have users select the SQL Server universe, run a query. Select the Access universe, run a query. Link the two queries in a document. This requires the user to do some work.
Create “attached tables” in your Access database that connect to the SQL Server database. That way you can, in fact, create one universe for both sets of information. The Access connection is the only one being used since it (Access) is providing the connection to SQL Server. In Designer you would only have one connection.
This solution is transparent to the user, but much more demanding on the designer. Plus, you lose features of SQL Server that are not available in Access since the sql generated by BusObj is created for Access. Any special functions available in the SQL Server universe are not directly available. Plus, performance would be a key issue.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com See you in Orlando in '98!
Listserv Archives (BOB member since 2002-06-25)
No. BusinessObjects is not able to link universes based on different databases. If you need to do this, try linking the SQL Server tables to the Access database and then create a universe based on the Access database.
Robert
Schmidt Interactive Software, Inc.
We now post Document and ReportScript examples!!
If I have one universe built off of a SQL Server, and another built off of Access, I know that I can link them together to form one universe. Can the user select objects from both areas in one query and be successful?
Listserv Archives (BOB member since 2002-06-25)