Webi problem in cross table

[#1]

Hello,

I have a very simple univers. In this univers, I have two tables with link.

In webi, I create a query but when I use a cross-tab, there is a problem. The picture below explain the problem.

The problem :

When I create a vertical table, there are 4 lines for the same ID (NRB Number), each for a code with a differenet timestamp.

When I create a cross table, there are always 4 lines for the same ID. For me, in cross table, I need only 1 line with 4 column (one for each code).

I don't understand why ?

Any help will be appreciate.

Thanks in advance

Dimitri

[Former Member · Accepted solution]

Select the table and do a right click. Then select the last option Format Table.

Tick the checkbox Avoid Duplicate Row Aggreagation.

[Former Member · Accepted solution]

Hi,

As like Rakesh said that select the whole report and reight click on that report then format the report and Tick the Check box Avoid duplicate reows aggrigation..

I hope your problem Should resove...

Cheers,

DSP

[dherla2 · Accepted solution]

Hi,

I have tried and now, ih ve the following :

Is it possible to have only one row ?

Regards

Dimitri

[Former Member · Accepted solution]

What does that  1,2,3,4 in the Column header denotes?

If they are different (EXP,FTP...) as in your first screen shot then we can't bring it in a single row.

[dherla2 · Accepted solution]

Hi,

I have a record in one table. This record has 4 states in a second table. The relationship between table-1 and table-2 is "one-to-many".

Thus, in the previous screenshot, I have a record (2012041415) with 4 states with different timestamp.

I would like the following table.

ID                    State 1           State 2          State 3          State 4

2012041415     31/12 20:34     31/12 21:00    02/01 7:46     02/01 14:50

Is it possible to have only one row ?

Thanks in advance

Dimitri

[Former Member · Accepted solution]

I don't think that could be done in a cross table. You can try using the combination of Horizontal and Vertical tables with some function and make it appear like Cross Tab

[dherla2 · Accepted solution]

Dimitri Herla wrote:
Hi,
I have a record in one table. This record has 4 states in a second table. The relationship between table-1 and table-2 is "one-to-many".
Thus, in the previous screenshot, I have a record (2012041415) with 4 states with different timestamp.
I would like the following table.
ID                    State 1           State 2          State 3          State 4
2012041415     31/12 20:34     31/12 21:00    02/01 7:46     02/01 14:50
Is it possible to have only one row ?
Thanks in advance
Dimitri

The problem is very simple... The timestamp is define like a dimension not a measure. I create a variable with the type of measure and now, I have only one row.

Thanks everyone for your help

Dimitri