Question Re: webi current Year in Technology Q&A

webi current Year

Former Member — Thu, 11 May 2017 14:37:58 GMT

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

Re: webi current Year

amitrathi239 — Thu, 11 May 2017 14:44:56 GMT

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.

Re: webi current Year

Former Member — Thu, 11 May 2017 14:57:24 GMT

Hi;

Create variables::

Current Year =Year(CurrentDate())

Current Month =MonthNumberOfYear(CurrentDate())

Hope it helps;

Re: webi current Year

Former Member — Thu, 11 May 2017 18:38:37 GMT

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.

Re: webi current Year

Former Member — Thu, 12 Oct 2017 14:26:44 GMT

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