How to restrict last 12 months from current date

[Former Member]

Hi,

SAP BO 4.2  Service pack 2.

Tool: Information design tool

Back end : Oracle 10g

i have date object i need to restrict data in that object for last 12 months from current date. it should be sequence order.

i want like below format:

Aug-15

Sep-15

Oct-15

Nov-15

Dec-15

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Aug-16

please reply anyone have idea.

Note: i want create above requirement object in Information design tool not in webi

[amitrathi239]

try this.Create predefined filter in the universe.

Table.Col1  BETWEEN  add_months(sysdate,-12) and sysdate

[Former Member]

Hi Amit,

i used below formula data is coming fine but sequence is not coming properly:

@Select(Custom Dimensions\DateCalculations\Day Wid Date)>=(@Select(Custom Dimensions\DateCalculations\Last12months startdate)-1) and @Select(Custom Dimensions\DateCalculations\Day Wid Date)<=@Select(Custom Dimensions\DateCalculations\Current date)

i am able to get last 12 months like as shown in above post but it is not coming is sequence  and i need date object with 12 months

below is the sequence i am getting

NOV-15

APR-16

SEP-15

DEC-15

FEB-16

AUG-15

JUL-16

MAR-16

AUG-16

JUN-16

OCT-15

JAN-16

MAY-16

Thanks,