BusinessObjects Board

Where Clause for Measure Object, How to do it in designer

building semantic layer
#1

Hi Experts,

Thanks for your quick answer. Your Forum is realy great :slight_smile: . I have following problem, I have a measure that counts the number of Layer that are assigned to specific Sack. Sack-Layer (relation is 1-Sack to Many-Layer).

I have the following sql:

Select count (disctinct layer.sack_id)
FROM sack,layer
WHERE sack.sack_id= layer.sack_id

How can i realize the Where condition in Universe Designer?.

Please Help !!!

Thanks
lamine

lamso (BOB member since 2008-04-03)

#2

Hi,
You have aked the question in the wrong forum. So you are likely to get less / delayed response compared with when asked in the correct forum.

You need to explain more as this simple SQL to be implemented in teh universe you need to create one object in the designer and the join present between these 2 tables in the designer.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

#3

Dwayne Hoffpauir just answered this question the other day – and it seems to keep coming up so often that I have now added a Designer FAQ with the answer.

Anita Craig :us: (BOB member since 2002-06-17)