Join Issue

building semantic layer
1

Hi All,

I have objects called Date and an another object called Received date and a conditional object called Current Year.
The Date object can display 2010 dates if I use conditional object current year but Received date displays from 2009 onwards.

I believe there is a join issue here. Can some one point me reason and why?
Thanks

JohnJustus :us: (BOB member since 2007-06-25)

2

It depends on how your database is configured.

For instance, your database is composed of a listing of customers. Along with their name, you have two dates: signup date and last renewed date.

If you filter for current year, are you filtering for customers who renewed this year or signed up this year? That same information can be on one row in the database, but obviously represent different information.

The same thing in your database. You need to know what the fields represent and which column the condition object is based on. A quick view of the generated SQL may give you some insight.

digpen :us: (BOB member since 2002-08-15)

3

[Moderator Note: Moved to Universe Designer - Jansi]

Jansi :india: (BOB member since 2008-05-12)

4

Hi Jansi,
Thanks.I was searching for this thread in General Discussion.

JohnJustus :us: (BOB member since 2007-06-25)