Skip to Content
avatar image
Former Member

webi current Year

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2017 at 02:57 PM

    Hi;

    Create variables::

    Current Year =Year(CurrentDate())

    Current Month =MonthNumberOfYear(CurrentDate())

    Hope it helps;

    Add comment
    10|10000 characters needed 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

    Add comment
    10|10000 characters needed characters exceeded