How to do Transformer Include when Needed Inclusion in Framework DMR

[kgcognos]

Is there a way to not show members that do not have any measures in Framework Manager DMR?
Just like in Transformer Cubes there is an Inclusion Property to set to Always Include or Include when Needed??

Thank you in advance.

[kgcognos]

How to suppress members with no measures in Framework Manager DMR?
Thank you

[prikala]

Transformer cube has the advantage that is it generated and during generation, it is trivial to transformer to check whether a certain member is needed or not.
In DMR the fact is queried only when it is needed in the report, usually after dimensions have already been populated.

I think the only efficient way is to have a separate table for "include when needed" dimension and populate it only with the dimension rows that are needed (or populate all rows but flag rows that have corresponding fact rows and filter the dimension using the flag column).

[Andrei I]

Is there a way to not show members that do not have any measures in Framework Manager DMR?
Just like in Transformer Cubes there is an Inclusion Property to set to Always Include or Include when Needed??

Thank you in advance.

Yes, but you need to implement your dimensions base queries as a joins to the fact tables.
Most likely you would need to materialize these queries in ETL to make them work fast