TM1 Forum

Hii guys, im new on tm1 and im trying to make a lookup cube to consolidate acounts with groups.

i have one cube "origen" with acounts , versions and months
another cube "destino" with groups, versions and months.
and the last one called "currency" with a currency name dimension with only one element(groupCurrency) and the acounts

http://s15.postimg.org/hndv2ej97/picture.png


I'm using this guide ftp://decisionsystems.com/itm1/tm1_adva ... _guide.pdf page 3-23 exange rates

i want to consolidate the acounts with the corresponding group , so in the guide there was something similar with the exange types.

so am trying this rule in my "destino" cube

[]=N:DB('2.origen',DB('2.currency',!1. cuentas,'currency'),!1. Meses);

but i cant pull it off, the error said there is a problem near " 1. cuentas" and i think it's becasue it cant find any 1. cuentas dimension there, cause there inst, but that's why i make the second DB , to get the currency group. im sorry if is hard to understand, but im not native english speaker. If you guys get the idea of what am trying to do , pls let me a hand on this, i posted like 2 mores topiic with the same question in a diferent way , and "tomok" gave me a good solution, but a need a simple table to change the acount's groups , clients request.

Thanks for any help

Hello

Your DB function returns an error, since the cube 2. destino (where the rule is located) does not contain dimension 1. Cuentas.
Hence, that 'information' cannot be used to do a lookup to cube where you have that dimension 1. Cuentas.