Universe designing

[Former Member]

Hi,

I have queries SQL, by using them, I have to create reports by using Universe.

Joined tables and classes & objects for few queries am not able to do.

Select a,s,d,f from tab1 Ineer join (tab2 left outer join tab3 ON tab2.col1=tab3.col1) ON

tab1.col=tab3.col where Year =2010

How to make this join??

[Former Member · Accepted solution]

Hey mshaik,

It is not possible to directly join them @ Universe.

As suggested, use Derived Tables. (Copy & Paste the SQL given)

OR

Custom SQL @query level. (Create relavant objects not exactly perfect @Universe, simply to drag to Result & filters pane @Query)

OR

If you have different Where cond's ,. you can use Sub query in query panel.

Hope it gives you some idea.

Gracias...!!

[Former Member · Accepted solution]

BO XI 3.1

I want to do it at Universe level.

I know about Derived table but it will decrease the performance.

Looking for better option.

Anyone help me in this.

[Former Member · Accepted solution]

In that case:

For Inner half join: Create Derived table.

For outer join: Join the outer table col to Derived table col.

In performance wise also, not much difference you can see.

Alternatively, Use Custom SQL @Query level.

Gracias...!!

[Former Member · Accepted solution]

Thanks for your help.

But I don't think it will solve the SQL query completely.

Using Custom SQL or Derived table fully may be helpful.

[Former Member · Accepted solution]

You may be correct.

But only thing is using Derived tables is performance issue. But it is just a copy for the query what you are looking after.

Gracias...!!

[Former Member · Accepted solution]

Thanks...!!

[former_member142702]

You can create a derived table an put your SQL statement as it is in the definition.

Which version of BOBJ do you use?

Regards,

Stratos