We have several fact tables, all of which share the same dimensions. In a relational Framework Manager model, we just include all the measures from all the fact tables in one namespacea along with one set of all the dimension tables. This works fine.
But if we inport that FM model into Transformer, we get an unhelpful error message saying the OLAP 'sum' function is not supported.
The error message appears as long as the additional measure columns appear in the datasources pane. If we delete the extra measures from that list, then all works fine (except we cannot report against those deleted measures).
How do we fix this?