Transforming a vertical table into an horizontal table in Business Objects

[Former Member]

The report I have in Webi currently look like the table below:

Site ID WO ID Task Task ID Task Status

2BE3063C 1237116 1 14950 Open

2BE3063C 1237116 2 14951 Open

2BE3063C 1237116 3 14952 Open

2BE3063C 1237116 4 14953 Open

I would like to transform the table to this form, using formulas:

Site ID WO ID Task ID Task(1) Task(1) Status Task(2) Task(2) Status Task(3) Task(3) Status

I can't figure out which formulas, or functions to use, or even if it is possible to done this in Webi. Any help in this regard will be greatly appreciated.

Thanks

Ayo

[Former Member]

Hi Ayo,

You can simply right click on the table in Webi, and then select "Turn To" and change it from a horizontal table to vertical, or vice-versa.

If you actually need columns with a heading for every task per site, then you would have to create variables for each different task instance, or create multiple report blocks with different filters, or something along those lines.

Thanks

[Former Member]

I know I have to create a variable, the problem I am having is the formula to use. That is what I need help with. I need to go from:

Site ID WO ID Task Task ID Task Status

2BE3063C 1237116 1 14950 Open

2BE3063C 1237116 2 14951 Open

2BE3063C 1237116 3 14952 Open

2BE3063C 1237116 4 14953 Open

to this table

Site ID WO ID Task1 Date Task1 Status Task2 Date Task2 Status Task3 Date Task3 Status Task4 Date Task4 Status

2BE3063C 1237116 3/14/2010 Closed Open Open Open

Edited by: aojiku01 on May 11, 2011 5:20 PM

[Former Member]

Hello, Sorry for the late reply. If there are not too many tasks you could simply create columns for each and then place a filter in each column/formula for when task = 1, 2, 3 etc. Otherwise this sounds like it would be more easily done as a table in your database, or possibly a derived table in the universe.

Thanks

[Former Member]

Thanks for the info. Now I need to know, how do I "place a filter in each column/formula for when task = 1, 2, 3 etc." That is the part that I am having trouble with. That is really what I need directions on.

[Former Member]

you can achive this using cross tab functionality.