I'm using JasperSoft Server 5.6 and I want to design a domain with two fact tables. Let's assume, I also have two dimensions. Both dimensions are not interconnected, but both dimensions are referenced in both fact tables (see the attached depiction). Furthermore, the two fact tables aren't interconnected. When I want to query information from both dimensions without any information from any fact table, I have two possible join paths. I can either join dimension 1 and 2 via fact table 1 or fact table 2. As far as I've tested JasperSoft Server, JasperSoft decides on its own, which join path it takes. Therefore, I was not be able to decide on my own which join path JasperSoft shall use and to do that dynamically - like everytime I'm opening a report based on this domain. Is there any possibilty to let the user define the join path / which fact table shall be used ? E.g. in SAP BO Universe Designer you can select a context in this case.
As long as you are not looking to join fact table 1 + 2 together then we're in good shape. What you need to do is create 2 "data islands" for the join paths. If you notice our example Supermart domain only allows one island at a time (Like Sales) and the others get greyed out. In the domain designer you will use the table copy feature (which creates an Island)...explained in this video https://www.youtube.com/watch?v=wXY7nSDxjjE&index=2&list=PL5NudtWaQ9l7lR...