webi current Year

[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.

Enrique

[Former Member]

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

[Former Member]

Hi;

Create variables::

Current Year =Year(CurrentDate())

Current Month =MonthNumberOfYear(CurrentDate())

Hope it helps;

[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.

[amitrathi239]

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.