Skip to Content

webi current Year

May 11, 2017 at 02:37 PM


avatar image
Former Member

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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

May 11, 2017 at 02:44 PM

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.

10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 11, 2017 at 02:57 PM


Create variables::

Current Year =Year(CurrentDate())

Current Month =MonthNumberOfYear(CurrentDate())

Hope it helps;

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

avatar image
Former Member Oct 12, 2017 at 02:26 PM

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

10 |10000 characters needed characters left characters exceeded