TM1 Forum

Is there a way or function to dynamically pull all parameters labels and inputs on runtime in TI Process?
For example GetProcessName(0) returns the current process being executed.

Do I need to execute this code from MetaData tab or Prolog itself is fine?

ok. Thanks for your help!

Initially it was not set to auto sort by Hierarchy. I have done that now. Now after auto sort set, I deleted all elements and try adding again using code and it seems to be working. What was I doing wrong? Also please clarify what does element weight parameter mean here in DIMENSIONELEMENTCOMPONENTA...

Set to sort manually by Name.
Still same issue. example below, 903 and 904 are not rolling up to Total Entity.

is below code incorrect?
DIMENSIONELEMENTINSERT('dimName','', xle , 'N' );
DIMENSIONELEMENTCOMPONENTADD( 'dimName', 'Total Entity', xle, 1);

+Total Entity
--900
--901
--902
903
904

Not sure what that means. Do we set it from edit dimension structure? or via code? This is the code that will add elements going forward

Hi everyone, Below is the sample syntax I am trying to add element to Parent called 'Total Entity'. DIMENSIONELEMENTINSERT('dimName','', xle , 'N' ); DIMENSIONELEMENTCOMPONENTADD( 'dimName', 'Total Entity', xle, 1); Someone time the result shows elements added under 'Total Entity' as child (which I ...

Yes I tried clearing the data and rebuilding it still the same. they are zeros. I tried division and it return #DIV/0! error.
I tried using public subset of level 0 for dimension still same result, tried MDX still the same.

Willi wrote: ↑Thu Mar 15, 2018 9:24 am Is the column in question the only column wich reference the TM1RPTVIEW-Cell? If not, all columns have to be zero that the line is suppressed.

The Active form has only two columns and both are referenced to TM1RPTVIEW

HI, Just as a further check have you tried dividing something by the value? If it returns a div error then at least you know for sure the value is zero. Also I presume you haven't manually changed the TM1RPTVIEW suppress zero parameter at all? If so did you rebuild the worksheet or just recalculate...

Thank you Alan..that answer the way tm1 might be behaving but I do not see any decimal values even if i maximize the decimal places to 20...any hack / tips for this?

TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help

Apologies didn't check back sooner. Yes, the cube representation looks good.
Value in E7 = Total Excluding Entity 155 Amount if it exists though not expected.

My sample cube set up is Cube dimensions; Version Period Entity Region Sample_Cube_Measure 1) 'Net' 2) 'Gross Val' In Sample_Cube, whereever there is data I want to Sum Total Value 'Net' for all elements under Dimension 'Entity' except value of '155' (Total - 155 Amount), Dimension 'region' will be ...

Hi everyone, Please help me out with below requirement; I want the rule results to return value in consolidated cell/intersection of Entity 155, Measure Element 'Gross Val' For example; 'Gross Val' Measure Element at Entity '155' = SUM Total of this critirias -- > 'Total Level' of Region Dimension, ...

Thank you BariAbdul!

Thank you for reference link. Very helpful.

Thanks for confirming that Wim! Appreciate your help.

Hi Experts, what are TM1 Rules Capabilities? Can it create cubes, dimension, other TM1 Objects etc. like the TI Process? I believe the answer is 'No' and that TM1 Rules are used majorly to calculate real-time numbers rather than storing numbers as a static value.

Thank You