Page 1 of 1

TM1 Help

Posted: Wed Aug 06, 2014 11:11 am
by AliUgur
Hi , I need help for an issue on TM1, anybody WHO can answer my question .. ı need to plus two items and ımport two one item in another cube ?
these are my codes in process..


İliski = CellGetS('}ElementAttributes_2_Hesap_Planı',V_Kalemler, 'Mali_Tablo_Secimi');
Seçim = CellGetS('}ElementAttributes_2_Hesap_Planı',V_Kalemler, 'TP_YP_Secimi');

CellPutN(0, 'TM1_Mali_Tablo',İliski,Seçim,'Solo',P_Ay,P_Senaryo,'MİZAN');

Data = CellGetN('Mizan',V_Kalemler, P_Ay, P_Senaryo,'FİNAL MİZAN');

CellPutN(NValue, 'TM1_Mali_Tablo',İliski,Seçim,'Solo',P_Ay,P_Senaryo,'MİZAN');
CellPutN(Data+NValue, 'TM1_Mali_Tablo',İliski,Seçim,'Solo',P_Ay,P_Senaryo,'MİZAN');

Re: TM1 Help

Posted: Wed Aug 06, 2014 12:34 pm
by BariAbdul
Hi You have to derive or get the value from the cube for example by using
CellGetN(Cube,element1,element2......)
Add the derived value with existing value
nValue=A(the old value)+B(the value you got through CellGetN

Pass the new value to the cube you want:

Code: Select all

CellPutN(nValue,Mali_Tablo',İliski,Seçim,'Solo',P_Ay,P_Senaryo,'MİZAN');
you don't need this statement that is given in your code:
CellPutN(NValue, 'TM1_Mali_Tablo',İliski,Seçim,'Solo',P_Ay,P_Senaryo,'MİZAN');
Thanks