I don't believe that Impromptu is capable of correctly joining a conformed dimension to multiple fact tables. Business Objects can join multiple fact tables by defining "contexts" which set up multi-pass SQL. I've also just posted a question similar to this one on comp.databases.olap...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.