arne.arnold

Hi, 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. Best regards, Arne