TM1 Forum

Thanks:)

A sample: CalcJanAccount1Value = CELLGETN(srcCube , VersionInput1 ,SUBST(pPeriod,1,4) | '01' , vBilling_Code , pAccount1 , '401' , vBusiness_Unit , vBU_Region , vMandate , vCounterparty , vProduct , vClient , vReporting_Measure ); CalcJanAccount2Value = CELLGETN(srcCube , VersionInput1 ,SUBST(pPerio...

Yes, Already did but not working. I am trying to create a multi dimensional extract where x axis has combination of Months and account and Y axis has combination of 5 dimensions. In export view: I am using "Total account" and "Current month" In Data tab: Im doing cell get n for 2...

Hi all, I have created an TI Process in TM1. I have created an export view with one element (Account) at consolidated level. In data tab, I am writing cellgetn formula for different combinations of hierarchies for different accounts using the export view. Though the consolidated Account has value, l...

Thankyou so much.

I am using TM1 perspectives not web. files are already heavy that is why need a solution that it calculates only specific cell, don't you think macro enabled files (xlsm) would make it more heavy?

Also, in the meantime, are you able to provide the vba script for it please?

Is it something that can be inbuilt in the excel addin itself which can be used by every employee of the company rather than just a adhoc Macro file. Something in TM1 config files or so?

Hi,

I am looking for a way to recalculate say 500 cells in TM1 worksheet (slices) rather than whole worksheet. Also, F2+Enter works only on 1 cell. Doing this 500 times is not feasible. Any suggestions?