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

Reporting year to date(YTD)

HOW TO DISPLAY YTD IN QUERIES ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.