create two objects in universe for current Month and Year.These you can create on currentdate() function.You have Year & Month function in universe to get the values.
Instead of using prompt use these in the webi queries.
Hi Enrique,
Can you please tell me do you have any date field to identify year and month in your data.
If you have such we can do as follow.
I am considering YearD and MonthD objects from your data.
You need to create formulas as below.
Variable 1: Current Year =Year(CurrentDate())
Variable 2: Current Month =MonthNumberOfYear(CurrentDate())
Variable 3(Current year filter): if(currentyear=Yeard) then 1
Variable 4(Current month filter): if(currentmonth=Monthd) then 1
Once you create all above formulas.
you can apply filter on the report as Current year filter=1 and current month filter =1.
Hope this solve your purpose
Add comment