Monday, May 23, 2011

Active Form Top Ten Tips

In no particular order but hopefully a useful list for people to check through to ensure good performance:

  1. Delete any Named references with #Ref in them, do an Excel find to see if there are any #Ref in cell formula, check for external links and change/delete
  2. Delete any unused columns or rows. Use the slider as an indicator as to how many rows/columns are saved with the sheet
  3. Keep SUBNM, ELCOMP formula to a minimum
  4. Before publishing the Active Form delete all rows below the tm1rptrow formula
  5. Any lookups to cube that are used in other formula’s need to be a DBR rather than DBRW
  6. Workbooks perform best when uploaded to TM1 Server (copied to TM1 server through Add File route), subsequent navigation options via action buttons should then have “Look In: TM1 Applications” selected
  7. Try to minimise the number of worksheets in a workbook. Definitely less than 8
  8. Try not to use Action buttons formatted as hyperlinks
  9. Don’t use dynamic named ranges e.g. ranges that are not visible to objects within the workbook
  10. Use named ranges in action button properties rather than cell references e.g. =rngTM1Server not =’Sheet1’$A$1