Variable within Variable

[#1]

Hi Everyone,

I have three fields Qtr Desc(Quarter Description), Date & Created Date.

So, when I pick 2011 Q4 in Qtr Desc it selects a date range 1/2/2011 to 03/28/2011.For the same date range I want all

the items created in this date range.

So how do I do this.

Please help,

Regards,

Bikash

[Anonymous]

Hi Bikash,

I assume the Created Date is in another table than the Date? Otherwise you should be able to just add the field Created Date to your layout.

If you have a proper connection between the tables it should work just fine. Are you connecting on the Date field?

[#3]

Yes Johannes,

They are in separate tables. Created date is from the fact table called Opportunity and the Fiscal Year and Qtr Desc are from Time dimension table - Time.

Could you please suggest how can I achieve this?

Thanks & Regards,

Bikash

[#4]

Hi,

This is how my Data Model looks like.
I want to connect CREATED_DATE and the Time Table by some way.

Thanks in advance,

regards,

Bikash