Skip to Content
0

webi current Year

May 11, 2017 at 02:37 PM

151

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.

Enrique

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

3 Answers

AMIT KUMAR
May 11, 2017 at 02:44 PM
0

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.

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

Hi;

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.

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

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

Share
10 |10000 characters needed characters left characters exceeded