Crosstab Condition: compare Rows and Columns

[charon]

Hiho Cognosers,
i need a little help on a crosstab report im building. First of all the environment.
- DMR
- Oracle 11
- Amount of Data: about 250k rows
Ive build a crosstab like the screenshot. Excuse the simple report, the original is much(!) more complicated, but i am trying to break it down. The special requierement are,
1) Dim 1 and Dim 3 have similar business keys and similar, but two different dimensions. Product line is quite the bad example dimension for this ;) The idea is, that there is a logical relationsshop between these dimensions, they base on the same phyiscal dimension of the data mart but use different business keys of the fact table.
2) Dim 1: is a sum element of a dmr hierarchy, and it contains only IDs where Dim1.ID = Dim3.ID. So in every row is only the sum of data aggregated where the key of Dim 1 is the same as Dim 3
3) I need a drill definition from the cells of the colums.
4) There is a detail report, from the cell of the colum u will get to a list report which shows you all variations of Dim 1 and 2, but it needed to be filtered by the row.
_____________________
1) and 2) i have found a solution in the data layer of my framework. But for the drill i am having issues to transfer the information of the business key alone to the next report, because they are two different and different modelled dimensions.
Does anybody has an idea how to pass the ID (which is the business key in the dmr) and only the ID as number from Dimension 1 of report 1 to Dimension 3 of report 2?!
Any hints are welcome. Thx and cheerz :P
mike