Do you experience the same issue if you expose Table B in your presentation layer? Are you able to see the generated SQL in the advanced tab? Is it including Table B as you are expecting it to, or is it being missed? If Table B is being commited, you may be able to skirt around the issue if you can bring any field from…

If your analysis is static, and it's not a particularly high cost to the database you could just create a second version of your analysis which is only the total and then place both of those analysis on a dashboard. Aggregation at top, detail at the bottom. If it's dynamic in any way, you could also convert the criteria to…

This can be caused by the knowledge modules that you are using. Assuming that you are using a control append approach: * On the logical panel of your mapping, select the target table, and open the properties. Select the "target" option, and choose "control append" as your integration option. * On the physical panel of your…