Dispaly in Query output Errors

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hello,

Yes the key figures are restricted.

Thanks for your reply.

Can you advise how to put it into Header.

I am begineer so if you can elaborate more it will be really helpful.

[Former Member · Accepted solution]

you go to query designer, to the properties of your restricted key figure, next to the name (which will be shown in the header of column or row) there is the variable button - you press it and select the variable or create a new one...

all very simple

[Former Member · Accepted solution]

For aggregation of Intervals - Try creating a selection for each keyfigure restricting it to Range Variable , <b>remove the variable/restriction from Filter Tab</b> ( still ull get the prompt for var as u hav restricted in selection )for previous year offset it by -1.

For proper headers create a text variable - go to description of the selection - click on the yellow icon - create - Replcaement Path - giv ur Time Char - Replacement Tab : Replacement Variable with Variable - Variable - Time char....

[Former Member · Accepted solution]

Hello Cornelia,

Thanks for the detailed reply

Can you advise that how shall i create the text variable for Starting period of user entry and Ending period of User entry and wat values to select while creating the same.

I got the logic how to create Text variables.

But while creating can you please adv ise what options to change or put in which required fields, as i will need to create those variables both for interval start range and interval end range

[Former Member · Accepted solution]

Oh common, that is really easy. Just go through all the tabs and have a look around.

there is one tap "replacement path" and the question for "intervall usage" from value / to value and you select by pressing the radio button whatever you need.

also have a look at the online library

http://help.sap.com/saphelp_nw2004s/helpdata/de/03/6ba03cc24efd1de10000000a114084/content.htm

regards

Cornelia

[Former Member · Accepted solution]

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.

[Former Member]

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.

[Former Member]

Hi,

how did you so far restrict your key figure? With fixed values?

I understoof that you were asking only for how to show the selected values.

Now it seems that you have not even the selection variable.

You need a variable for selection of the values the user want to have in the report and text variables if you want to show the selected values in the header of columns.

[Former Member]

Thanks for reply.

I created a Interval range variable for Fiscal year or period and used it for

USER ENTRY SELECTION on first screen.

So i do have to create seperate text variables both for start period and end period in order to DISPLAY /SHOW in Column header in output, Right ?

I already created those.

So user have to enter the values like this

01/2006-05/2006 for Interval Selection--INTERVAL VAR.

01/2006 for Start Date Selection---TEXT VARIABLE - START

05/2006 for End date Selection---TEXT VARIABLE - END

The interval variable i used for interval selection,

I cannot use it altogether for Display Correct.

thanks

[Former Member]

yes, but your text variables don´t have to be for user input. Set them to replacement path and let them be replaced by the starting / ending value of 0FISCPER.

when you use them in the column with the restricted key figure, the system detects the intervall used and replaces the text correctly.

[Former Member]

How shall i select the starting and Ending value of 0fiscper

In replacement path i have to select the variables for each that is understood.

But how shall i create/ select the variables for Starting and Ending for 0fiscper

[Former Member]

I don´t understand your question.

Have you had a look into the online library about how to create variables?

It´s all described there.

[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