PROBLEM WITH DISCOVERER JOINS

Hi everybody!!

I had implemented a datawarehouse based on star squema. I have dimensions, facts and relational tables.So I want to joins then in Discoverer.

The situation is the following: I have 2 dimensions and one fact table and one relational table. The problem is that I cannot take objets from the fact table and the relational table at the same time, because both of them are joined with the 2 dimensions: relational table is join to one Dimension1 element and the fact table is joined to another element of the same dimension, so happens with Dimension2.

I worked on Bussiness Objects and contexts solved that problem. Do you know how to do it in Discoverer?

Thanks for your help in advance,

Ana Received on Fri Aug 01 2003 - 11:37:13 CEST