Filtering criteria using an Exit variable

[Former Member]

Hi,

I have a requirement as follows:

There are 2 info objects for Start& End Periods of project.

There is another Keyfigure(number of months) which is populated by calculating the difference of Start & End periods.

Now, the filtering criteria would be Start period, End period and number of months.

When the user enters the Start and End periods of the project and also the number of months, the system shoudl display all the projects matching the above filtering criteria.

Eg:

Project1: Start period : 01.2009

End period : 06.2009

Number of months : 6

Project2: Start period : 02.2009

End period : 04.2009

Number of months : 3

Project3: Start period : 03.2009

End period : 05.2009

Number of months : 3

Project4: Start period : 05.2009

End period : 07.2009

Number of months : 3

Project5: Start period : 05.2009

End period : 09.2009

Number of months : 5

Now if the user enters the following the filtering criteria:

Start period: 01.2009

End period: 12.2009

Number of Months : 3,

the system should display only project2,project3,project4.

Any thoughts on how to achieve this using an Exit variable? Because the variables Start and End periods are created on 2 seperate info objects.

Thanks

Shyam

[former_member434828]

Hi,

I think you should create the two variable..

One for start period where user puts the start period:- 01/2009 to 01/2009

Also in the end period user can select the :- 01/2009 to 012/2009.

in exit variable you can take the user input and add the high value for strat period similar to user input..

and in the end period user puts the end month and in exit u need to put the start period in low value.

Hope this helps..

in this caase, u will get the

start period value 01/2009 to 01/2009

End Period Value 01/2009 to 12/2009.

Regards

Gopal

[Former Member]

Hi,

Thanks for the reply.

But I fail to understand why the user puts the start period:- 01/2009 to 01/2009 and end period as 01/2009 to 012/2009.

In my example stated above, user enters only 1 value for each.

Best Rgds

Shyam