Author Topic: How to do Transformer Include when Needed Inclusion in Framework DMR  (Read 222 times)

Offline kgcognos

  • Community Leader
  • *****
  • Join Date: Oct 2013
  • Posts: 100
  • Forum Citizenship: +0/-1
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.

Offline kgcognos

  • Community Leader
  • *****
  • Join Date: Oct 2013
  • Posts: 100
  • Forum Citizenship: +0/-1
How to suppress members with no measures in Framework Manager DMR?
Thank you

Offline prikala

  • Community Leader
  • *****
  • Join Date: Dec 2005
  • Posts: 130
  • Forum Citizenship: +4/-0
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).

Offline stork

  • Full Member
  • ***
  • Join Date: Jan 2006
  • Posts: 46
  • Forum Citizenship: +0/-0
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

 


       
Twittear