BO reports - Universes - dynamic column

[amadese]

Hi,

I hope somebody can help me because I try to display data in a report but I don't know how to do it.
I have the tool BusinessObjects XI 3.1 .

In this report I would like to display the data from a linked table of a database as column header and another part of these data in the cells of the rows.

More details:

Here below my short database for this issue:

- Table Contracts:

Id Budget global
1 5000
2 3000

- Table Portfolios :

Id Label
1 Portfolio 1
2 Portfolio 2
3 Portfolio 3


- Linked table portfolios_linked for the link between the tables "Contracts" and "Portfolios"

Id Id Contracts Id Portfolios Budget
1 1 1 2000
2 1 2 3000
3 2 1 1000
4 2 2 1000
5 2 3 1000


In my report I would like to display the values as:

Id Contracts Portfolio 1 Portfolio 2 Portfolio 3
1 2000 3000
2 1000 1000 1000


Therefore a portfolio can be defined for several contrats.
The portfolio labels will be defined as column and the budget values will be in the cells for each contract row.

I do not know how to do that in the report. I think that I have to modify the universe.

Many thanks in advance for your help,

Regards,

Sebastien