BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

SQL Server 16 table limit problem


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Sep 25, 1998 7:12 am 
Post subject: SQL Server 16 table limit problem



Our new DW will use SQL Server 6.5 as the database, and we have recently learned that there is a 16 table limit in queries. We thought we could get around that by running two separate queries in BusObj, and using the link function in the reporter. Either I am using this linking method wrong, or it is a very useless item.

Anyone else have a database with the 16 table limit? Any hints or suggestions you can share? Are there other tools that would work better then BusObj to put two queries together?

Thanks for ANY assistance.


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Sep 25, 1998 8:58 am 
Post subject: SQL Server 16 table limit problem



In a message dated 9/25/98, 9:21:43 AM, BUSOB-L@LISTSERV.AOL.COM writes: <<Our new DW will use SQL Server 6.5 as the database, and we have recently learned that there is a 16 table limit in queries. We thought we could get around that by running two separate queries in BusObj, and using the link function in the reporter. Either I am using this linking method wrong, or it is a very useless item.>>

What sort of problems are you running into? There are a number of issues involved in this process, the main one being the data model and how the universe design has been done. To link queries you need "common" objects between the two queries. Typically these are database ID colums. Other items need to be details associated with those linked objects, or be linked themselves. If you can post a specific question about your linking issues perhaps someone can offer a more concrete answer.

The 16 table limit is just one of the more irritating SQL Server / Sybase issues. It usually comes in when people set up views on their data and then use views through a tool like BusinessObjects. Each table in each view counts towards the 16 table limit, so if you use 6 views each with 3 tables then you have too many...

Unless it has been changed recently, there is also a 16 object limit in the "Group By" clause as well.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0271 seconds using 17 queries. (SQL 0.0026 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo