Forum Stats

  • 3,851,540 Users
  • 2,263,997 Discussions


How to "think" use of multiple logical table sources

Hi everybody,

i'm new to OBIEE and its paradigm. I'm trying to build a prototype with multiple physical sources: ERD and a Data Mart; I need OBIEE to go to the Data Mart model at the need of aggregated info and to go to the relational model at the need of transactional info. I need to do that working with dimensions, assigning different sources to each logical level of the dimension.

My problem begins when thinking how to actually do that. Here is my question:

- Should I add the relational source in the data mart logical table source folders, mapping the same information with joins? If so, how does dimensions work from that point? (drill down)

thanks in advance!
This discussion has been closed.