Serious issue in display output of yearly query...........

[Former Member]

Hello friends i have to design a Yearly query in which it should look as follow:

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4

Now, the months to be displayed and year selection is not pre defined.

So i have to create Variable for it, that i understand.

But the user want to see the comparison of 2 years,,, monthly wise in above shown fashion...

Now please suggest how to achieve this.....

If i restrict Net post twice with Calmonth setting offset, it does not work...

because doing so it displays data but in following way....

-

---

net weight 1 -

---

net weight 2----

---

jan05 jan06 feb05 feb06...........jan05 jan06 feb05 feb06........

1 1 1 1

Is there any other way......

If i try to restrict Post 4 twice with Calmonth and seting offset for previous year....

the data displayed is as follow

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4

1st year 1 1

2nd year 1 1

Please suggest my user want to see it as follows

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4 1 1 1 1

[Former Member · Accepted solution]

the display got wrong........ pls refer below.........

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4

Now, the months to be displayed and year selection is not pre defined.

So i have to create Variable for it, that i understand.

But the user want to see the comparison of 2 years,,, monthly wise in above shown fashion...

Now please suggest how to achieve this.....

If i restrict Net post twice with Calmonth setting offset, it does not work...

because doing so it displays data but in following way....

-

---

net weight 1 -

---

net weight 2----

---

jan05 jan06 feb05 feb06...........jan05 jan06 feb05 feb06........

...1................1................................... 1............... 1

Is there any other way......

If i try to restrict Post 4 twice with Calmonth and seting offset for previous year....

the data displayed is as follow

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4

1st year ................1................. 1

2nd year......................... 1................ 1

Please suggest my user want to see it as follows

-

---

Net Post----

---

-

---

jan05 jan06 feb05 feb06.....................so on

Post1

---Post2

-

---

Post3

-

---

Post4....... 1........ 1..... 1....... 1

.

[Former Member · Accepted solution]

i couldn't able understand your requirement.

with restricted KF, youcan achive your output.

Is your POST 4 belongs to Year IO in your example.

You can achive this using simple Restricted KF i guess. It will come as long as POST4(i don't IO .. you didn't mention here) belongs to Year IO.

records in your Cube should have POST4 and Year value. (all 1's in your example)

[Former Member · Accepted solution]

Just use separate values for MONTH and YEAR (OCALMONTH and OCALYEAR).

The restrict the columns by the variable for MONTH and just place YEAR in the columns as a free characteristic (or you can play around with it and an offset)

The user can either enter Year and month separately or if thats too cumbersome you can write a user exit to take the value of whatever time variable they enter and pass those values to Month and Year...you can then set offsets (or allow user selection via another variable) to determine the breadth of the report.

Don't restrict the rows at all just let BW sort stuff based on your column definitions

[Former Member · Accepted solution]

well first of all all 1's is just for e.g.

it has different values for different months.

Now if i restrict Key figure, than i have to restrict Net post twice,

In first restriction i will just restrict it for interval at 0CALMONTH

In second restriction i will restrict it with interval at 0CALmonth and set offset = -12.

If i do this , i will see the output as follow:

-

---

net weight 1 -

---

net weight 1----

---

jan05 jan06 feb05 feb06...........jan05 jan06 feb05 feb06........

...1................2...................................3............... 4

and restriction to 0calmonth will give thsi output only..

Time char available are as follow:

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

fiscal year variant, fiscal year,

fiscal year/period, posting period

thankss

[Former Member · Accepted solution]

Do you have month or any Date IO in the Rows? if it has any date io, take out that and try again your report Output.

Nagesh Ganisetti.

[Former Member · Accepted solution]

i still don't understand why you are restricting the rows at all