joins between tables are not allowed in universes cont procs

building semantic layer
1

Hi all,

I am trying to create a Business Objects Universe for a SQL-Server 2005 database. The connection is all fine and I can display the tables, but when it comes to the joining on tables, i get the error:

joins between tables are not allowed in universes containing stored procedure!

I do not fully understand what the problem is… Yes this database does contain some Stored Prodecures, but not sure why this affects me trying to join two tables, I am not trying to run a SP!

Any help would be much appreciated
I am on BOXI Release 3

memphis (BOB member since 2010-06-08)

2

[Moderator Note: Moved from General Discussion to Semantic Layer / Universe Designer]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Just ran into the same problem. Did you ever find a solution?

dantheriver (BOB member since 2011-07-11)

4

Click the Universe parameter and look for this option under connection ‘Click here to choose stored procedure universe’, Is this option checked by any chance …?

BO_Chief :us: (BOB member since 2004-06-06)

5

Unfortunately yes, if while defining the Universe we mention it as Stored Procedure based one, then it is restricted for all sorts of joins.

Not sure why this is case for tables even.

jprasanthram :switzerland: (BOB member since 2010-12-10)

6

I have created a universe based on stored procedures earlier but that does not allow joins in the universe

when you use stored procedures and build a universe joins are not supported by BO which is by design and default behavior

However at the same time you cant use tables and give joins too.

Eswar

Eswar (BOB member since 2006-05-02)

7

Hi All,
Universe is supposed to design on database with tables having analytical data in it.
Universe help us to kepp the data easily accessible using the functionalities like @functions,conditional objects,derived tables etc.
Stored Procs itself has lopps and cursors used which may be processing large amount of data.
If we are trying having SPs in universe then we can’t treat the Output of it as table in BO.
The workaround for this is to denormalise the data by inserting O/P of SP into tables and using those in universe. :smiley:

swap_l (BOB member since 2009-04-09)