Skip to Content
author's profile photo
Former Member

Dispaly in Query output Errors

Hellog gurus,

I am building a report in which i want to show the output in columns as

Quantity (this year) / Quantity (previous year)

So i restrcited quantity with fiscal year / period and put a variable of interval.

What problem i am facing is that my POWER USER WANTS TO VIEW IT AS

Quantity (Jan- ... 2007) / Quantity (Jan- ... 2006)

This Jan - ... 200 selection should be user entry ..

So if i run the query and user has to select Jan- March of 2005

then this range should also represent on the Report output.

I hope you got what i mean to say.

So whatever range they enter it should visible on the report

The requirement is not to show month by month but aggregate quantity of range entered as well as the

VISIBILITY OF RANGE ENTERED.

i created and restricted for previous year and also set the offset year, It is solved

The problem is how shall i display the range of months they enter in Report output

below quantity

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 03:57 PM

    Hi,

    define 2 Text Variables, one that shows the start of your interval and one to show the end of the interval.

    Put both variables into the header of your restricted key figure (since you want to have the aggregation of your selected date range shown, I suppose you are using a restricted key figure).

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Create Text Var - >Type of var - Text ->Processing type - Replca Path ->Time char on which u hav created the interval var ->Replcaement Path - > Replacement Tab : Replacement Variable -Variable - > Variable - Giv the Interval Variable

      - > Replace with key or text.

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 01:16 PM

    Hello Cornelia,

    I understand completely your solution.

    But in my case i have to give user a selection for entering range of period for which they need to see value.

    And while creating Text variable it will only give me selection of Fiscal year/period variables which are SINGLE.

    so does that mean i create 2 text variables and make user to enter those value ALONG with the entry of INTERVAL RANGE entry.

    How to achieve this.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I know how to create a variable

      You replied-

      Set them to replacement path and let them be replaced by the starting / ending value of 0FISCPER.

      So while creating text variables both for start and end

      How shall i replace the starting value of 0fiscper

      How shall i replace the ending value of 0fiscper

      What settings/properties i need to select so that this text variables get replaced by starting / ending values