Archives of the TeradataForum

Message Posted: Fri, 22 Jul 2011 @ 14:08:15 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: PPI not working with Dimension Join

From:		rishi.agarwal

Hi Christian,

Txn_date is in integer format and PPI is on that column only. Scenario here is:

Fact

Txn_date
Measure1
:

Dimension (D_DAY)

Day_key (Integer format)
Calendar_dt (Date format YYYY-MM-DD)
Week
Month
:

Join Condition: Fact.txn_date = D_Day.Day_Key

PPI is working fine individually on the fact table, but when I am joining the FACT & Dimension ( to use time dimension hierarchy), I am applying filter conditions on D_DAY columns, say Calendar_Dt between '2011-01-01' and '2011-01-31' , In this case PPI is not working.How t get advantage of PPI in this case.

Thanks & Regards

Rishi Agarwal