To create dynamic date range with one date input

[system]

Hi, I am new to Business objects.

First issue : I have requirement to design the report where the user enters the year ( yyyy) and month (mm)
Then report has to display the last 3 years of data from the entered date.

Second issue: How the add the ‘ALL’ to LOV.

I need help to create this logic in designer. I am using XI R2.

Your help is much appreciated.

Thanks

---

Ckblues (BOB member since 2013-03-24)

[system]

Hi,
1.create the filter for date variable<=current year-3…

2. for All lov refer this link
   http://scn.sap.com/thread/1201562

---

Snazzy775 (BOB member since 2012-04-26)

[system]

Welcome to B:bob:B!

Please check these 2 entries in the Designer FAQ:

120×120 10.4 KB

Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list? Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt. (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Co…

120×120 10.4 KB

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Where is it that defines how to set up a date range ?

I am looking for something this post requests; a object set up in Designer that will allow the user to select a date or range.

i.e.

Date Variable that will accept an input from the user to do the following as potential filters:

Between (Seed 1) and (Seed 2)

Less Than (Seed 1 - for 1; 13; 26; 52 weeks prior)

Greater Than (Seed 1 - for 1; 13; 26; 52 weeks prior) ending on (Seed 2)

Equal to (Seed 1 or Seed2)

thanks for any help

---

di652 (BOB member since 2005-02-24)

[system]

Look in the date sticky at the top of the forum. Create appropriate date objects in your universe (eg 1_Week_Ago, Start_Of_Year, Today etc).

Then in your report add these to your filters eg:

YourDateObject between Start_Of_Year and Today

Debbie

---

Debbie (BOB member since 2005-03-01)