Obligatory join

building semantic layer
1

There is a way to make a join obligatory, also if i’m not using object of the second table? For example.
Table1, Table2 in join.
I use only object of Table1, but i want that in the where condition there is the join with table 2 anyway.
I can do this choosing the table in every object description…but is very long way beacuse i have 1000 differents objects…
Thanks in advance!

flavio20002 (BOB member since 2010-03-23)

2

With XI 3.x you can create universe class wide filters or even universe wide filters!

Andreas :de: (BOB member since 2002-06-20)

3

very cool. But in BO XI 2.0? there is something like that?

flavio20002 (BOB member since 2010-03-23)

4

there is no such feature in BOXI R2.

Rakesh_K :india: (BOB member since 2007-12-11)

5

You can associate an object from table 1 with table 2, but it will be like that for every query using that object.

6

Very good news…my company is going to update the version of business object in 2 weeks…:slight_smile: So i will use the feature of XI R3! Thank’s to everybody

flavio20002 (BOB member since 2010-03-23)

7

In XI R2 I would have tried to do this via a security restriction. You already have a restriction on T2 that you want to be included every time someone references T1. I would add a table restriction that includes “… and T2.ID is NOT NULL” or something like that and applied to the Everyone group. The idea is, anytime someone uses an object from T1 the security checks to see if T2 value is present… by adding T2 to the query we should also include the joins for security.

I don’t know if it would have worked, but that’s what I would have tried. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

8

I will try…thank’s very much!!

flavio20002 (BOB member since 2010-03-23)