I have a requirement to have some Webi reports scheduled anytime and broadcast with the current Fiscal Year and the current Period (month) data.
Fiscal_Year and Period (i.e. 2017 and 05) are numeric objects in the Universe.
Can someone help me with a formula? And how to implement it? am not sure which is better, at report or Universe level?
Or is it simpler to just use the system date in a filter? Then, how?
Thanks in advance.
Enrique
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;
Create variables::
Current Year =Year(CurrentDate())
Current Month =MonthNumberOfYear(CurrentDate())
Hope it helps;
Hi Ricardo,
How would I implement this since I need to schedule the reports, monthly?
Isn't that the variables are only visible after the report has run?
Thank you for your reply.
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