How to retrieve thirteen months prior data in Web Intelligence !

Saturday, August 22, 2009 3:03
Posted in category business objects

  1. Create a Web Intelligence report with [Date object], other objects, measures#etc
  2. After the report is generated define a variable #13-Months-Back# using #RelativeDate()# to approximately minus the current date with 13 months as following
  3. 13-Months-Back=RelativeDate([Date Object];-395) .
  4. Now insert a new column in the report and place #Thirteen_Months_Back# variable object.
  5. Use #13-Months-Back# variable in the graph,#etc

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

You can leave a response, or trackback from your own site.

One Response to “How to retrieve thirteen months prior data in Web Intelligence !”

  1. Rodrigo says:

    July 11th, 2011 at 5:19 am

    Good Morning,

    Thanks a loooooot for your solution.

    But I have a question and i hope you can answer to me!..

    I have a NUM field and i need to do the same that you did in the post. It works with NUM field?

    Tks!!

Leave a Reply