Skip to Content
author's profile photo Former Member
Former Member

Reporting year to date(YTD)

HOW TO DISPLAY YTD IN QUERIES ?

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 09:06 AM

    Please post questions like this in the BI forum, not here in the ramp up for 2004s

    2ways- variable on fiscal period going from either 001 to user entered single variable or 000 to user entered single variable

    or hierachy on fiscal period built on 001 - 002, 001-003, 001-004, etc.

    Sarah

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 10:05 AM

    Build a hierarchy on fiscal year or use variant .

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:00 PM

    I am not clear abt ur question .

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 06:59 PM

    You need to set a range in your variable. For example, if you are using Fiscal Year/Period as an input parameter, and the end user enters 008/2006, you can have BW automatically output results from Jan 2006 to 008/2006. This is accomplished in the Analyzer by choosing a setting in the variable. Simply choose RANGE instead of SINGLE VALUE. Then you must tell BW the range. You do this by typing a "1" in the text box, followed by a semin-colon ";", then you switch to the variable tab, select the variable, and then click the right arrow. When you look in the right pane, you will see the variable with "1;variable" underneath it. This is a little hard to describe, but it should set you on the correct path. Happy to provide more guidance.

    Add comment
    10|10000 characters needed characters exceeded