Key date in query designer

[former_member522325]

Hi All,

I have a requirements to read data based on t.code S_AHR_61016403 by using Trip Begins On date and filter by receipt date therefore I’m using DS 0FI_TV_01 and able to get data into Cube level correctly.

In Query designer, I have to use trip beginning date and filter by receipt date then put in MTD and YTD bucket based on receipt date.

For example, trip beginning date 01.07.2014 – 31.07.2014, could get 100 records which has different months data with total amount1500/- but based on receipt date 01.07.2014 – 31.07.2014 there are only 75 records with total amount 1000/-  I only interested total value 1000/-

I’m thinking to create a Key Date in query designer to read beginning date range and receipt date range. 

Can anybody give how to achieve this.

regards

Naani

[former_member522325]

Hi All,

Can anybody advice.

regards

Naani

[former_member182470]

0FI_TV_01 is a transaction datasource. Hence your Trip begin/Enddates are transactional data. You cannot use them as part of Key date in Query designer.

One more thing, you can't use ranges in Key date. It works only with single date.

you have to either create two variables in query filter. or restrict your KF with both variables.

[former_member522325]

Thanks Suman.

I'll check further.

Regards

Naani