Problem in display of char. and key figure for yearly query

[Former Member]

Hello all,

I got a query in which i have to do restriction on

Calendar Day/Month in Rows under Material which is a Characteristics

So it should be

PACKAGE QUANTITY

JAN FEB MAR APRIL.......DEC

PACK1

PACK2

PACK3

PACK4 for current year

PACK4 for prior YEar

Now the months display is not pre decided, it can be anything as per the input of user.

So i have to restrict it on Calendar month for Material twice

In current year , just introducing the Interval range variable

In previous year, same restricition with offset -12

Now the problem is while displaying it shows

JAN'06 JAN'07 FEB'06 FEB'07 MAR'06 MAR'07........

PACK1

PACK2

PACK3

PACK4 for current year

PACK4 for prior YEar

Which is not desirable.

I only want value for Jan in one column

and for previous year and current year in different rows thats it.

If i remove Calendar year/month from columns there is no way I CAN DISPLAY MONTHS .

How to achieve this.

Please suggest.

[Former Member · Accepted solution]

Try using two variables, year and month, instead of year/month. It may allow you to move the year to the rows and leave the months on the columns.

Cheers,

Rusty

[Former Member · Accepted solution]

The time characteristics available are

calendar year, calendar year/month , calendar year/week , calendar day

fiscal year variant, fiscal year, fiscal year/period

posting period

Can you please elaborate,

which time characteristics i use in rows

Set offset value for those time characteristics with which value

Whic time char. to use in columns.

Please advise.

[Former Member · Accepted solution]

Kartikey,

Rusty's suggestion wont work - using two characteristics for year and month will have the same effect as the position you are in at the moment.

ie..

2007 Jan.07 Feb.07 Mar.07 Apr.07

2006 -

---

Jan 06 Feb 06 Mar 06

If you have the posting period of 01 - 02 - 03 (just the period number only, no year) then your query will display

2007-01-02-03-04

2006-01-02-03-04

Regards

Gill

[Former Member · Accepted solution]

Gill,

That's what I meant when I said use year and month only, placing the month (period) on the columns and the year on the rows. The Cal year/month variable will not work in this case.

Cheers,

Rusty

[Former Member · Accepted solution]

the variable might be ok but the characteristic in the columns should just be period not fiscal year/period

[Former Member]

Kartikey,

You want to compare month on month to the previous year. As you rightly state your Fiscal Period value contains month & year so it wont be possible.

We have setup a Posting Period characteristic that we populate during data loads. It is populate with the Period Number only, 01 - 02 - 03 etc.

In this way you can put Posting Periods in your columns ad all Jan postings for the years you select will appear in the one column. Then as you put Fiscal Year in the rows you will break up the values to compare month on month by year.

Regards

Gill