We are using DMR model (in FM). We have a dimension table "company". We have two fact tables "journal_line" and "sales_order_line".The fact fields are coming from these two tables. These two fact tables are joined to the company dimension via another dimension("team" dimension), i.e. not directly joined to company dim. Whenever we are selecting the company prompt(tree) to run the report an erroror is thrown(when using the dimension model......DMR).but when we are using the same relational structure for the report, there is no error.
I am attaching the error screenshot herewith.