cancel
Showing results for 
Search instead for 
Did you mean: 

QUERY DESIGNER

Former Member
0 Kudos
28

HI,

I designed a query which will display the planned costs for the projects upto last month starting from last year Jan.

I did like this

Filter:

Fiscal year variant(calender year,4 spec:periods)

Fiscal year( restricted to 2006 and 2007)

Columns:

Cal.year/month(Not assigned : exclude from selection)

This is working well but its is displaying the values for future months also, a macro is written and all the future motnhs r being deleted.But i want this to achieved in query itself without any display for future months.

can u help me how this can be acheived.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Create a Customer exit variable which returns From Month as Jan and To Month as Current Month-1. And restrict the KF with this variable on Cal. Year/Month.

Hope this helps.

Bhargava

jaya_mogali
Contributor
0 Kudos

Hello Venku,

make following selections.

Option 1.

Filter:

Fiscal year variant(calender year,4 spec:periods)

Fiscal year( restricted to 2006 and 2007)

Cal.year/month > Select Variable > Value Range > Current Calendar Month (0CMONTH) variable > Specify Variable Offsets > -24 to -1.

Option 2.

Time Characteristics allow you to select Fixed values as well as variables.

Filter:

Cal.year/month : For Previous year select Jan 2006 to Dec 2006

and for current year select variable 0CYTLM (Cumulated to last Month)

No need to select Fiscal Year

You can make such combinations with variables on Calendar.year/ month by selecting two varaibles. (ie one for Current calendar year and other for previous calendar year)

Option 3: You can create your own variable by Customer exit

Jaya