TM1 Forum

I have the same problem and i found this document (atached) on IBM site

Duncan,

I did as you suggested and it worked

My rule now is :
['Classe' ] = S: DB('Premissa Cargos1',DB('Despesas Viagem1', !Cenarios, !Centro de Custo, !Meses, !Qtde Viagens, 'Posicao') , !Cenarios, 'Classe');

Thank Duncan, Declanr and Tomok for help

I understand what you guys are saying, but what I'm trying to do I put in the attached file.

See if it is possible to do this via a rule or not.

Thanks again

Yes, cargos is a list in cube (picklist)

Yes I´m using in rule and this dimension exists in two cubes but as picklist This work : ['Classe' ] = S: if (DIMIX('Cargos','Diretoria' ) = DIMIX('Cargos',DB('Despesas Viagem1', !Cenarios, !Centro de Custo, !Meses, !Qtde Viagens, 'Posicao') ), DB('Premissa Cargos', 'Diretoria', !Cenarios, 'Classe')...

Hi All, I have a problem with the function Dimix. The syntax I need only work with a dimension Time : for example : Dimix (Year , !Year ) or Dimix (Year, 'Jan') this owrk fine. But when I try this with other dimension (not time dimension) , this not work. for example : Dimix (business, !business ) n...