BusinessObjects Board

Universe filter

building semantic layer
#1

Hi Folks ,

I have a database oracle ,and i have one date field condition let say invoice date ,i need to remove a month from it as one object ,

i need to create a filter condition in a suc a way the if the user select month of march 03 ,then user need to get data of march as well as jan + Feb +Mar,
and if the user select let say april then we need to display a april data in one row, and show the data in other row of the report as Jan +feb +mar +APril ,as soon ,

http://forumtopics.org/busobj/images/smiles/banghead.gif
can you please help this is issues
:hb: :hb:

rizwan syed :us: (BOB member since 2010-07-08)

#2

So basically you need to display data for months <= selected month, correct?

Marfi :poland: (BOB member since 2006-12-18)

#3

can you please clearly state your requirement.

Rakesh_K :india: (BOB member since 2007-12-11)

#4

So you want to select a date, using that dates month as an end point with its year and show data, for all months, going back to the beginning of that year, correct?

This may help get you started:-

https://bobj-board.org/t/152613

Mak 1 :uk: (BOB member since 2005-01-06)