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.
How to suppress members with no measures in Framework Manager DMR?
Thank you
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).
Quote from: kgcognos on 03 Dec 2018 03:18:23 PM
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