TM1 Forum

Hi

I am not able visualise the use of the active form in tm1- can any one help me understand active form concept/usage advantange with some exaple.

Regards,
ravi

Active forms are slices which allow the user to drill on rows.

Active Forms are great when your data will generate different amounts of row data dependant on the selected title dimensions.

The best example of a use that I have is our model that tracks the bill of materials to a job number. depending on the Job selected there may be 1 - 300 parts associated. In traditional excel based templates we had to account for the larger number and ensure the template could accomodate. With active forms the form just expands as needed.

Also as was pointed out by David the drilling capabilities within the formatted excel environment are big benefits.

Besides the dynamic row capabilities, Active Forms also allow for dynamic formatting as well

So besides providing for more function they also provide for a great looking report or input template

Keep in mind though that if you plan on going down the Active Form route that they can be a bit finicky and do not perform well with large amounts of data and/or stacked rows

Also, it is recommended that you use a defined subset in your rows and as a starting point of your development use a defined view as well
Which means you should think about your design before developing your Active Form

Solanna