TM1 Forum

First off thank you everyone for your help I appreciate it. Using the index sounds like good idea only problem I have is that it's a large dimension with multiple hierarchies for different users sets. The hierarchy for the field is recreated monthly as there is movement of cost centers often between...

I'm trying to set default elements for report viewing in TM1. Right now we give everyone access to a dummy cost center element for a report members in the field need to review. Every member in the field has different cost center elements they need to review but they for the most part don't overlap. ...

Great thanks I can isolate the levels ['Purchase%_Total']=IF(ELLEV('d.sku',!d.SKU)>2,['IcecreamSold_Units']\['IcecreamAvail_Units'],[ELLEV('d.sku',!d.SKU)=3,'IcecreamSold_Units']\ELLEV[d.sku',!d.SKU)=3'IcecreamAvail_Units'])); What I am struggling with is how to push the level 3 results into levels ...

Is there a way to restrict a calculation to two specific levels using a rule. Right now I have a formula to determine what percent of people want to buy different flavors of ice cream ['Purchase%_Total']=C:['IcecreamSold_Units']\['IcecreamAvail_Units']; I want to restrict the C: calculation to level...