Whenever User enters data in Websheet (Form), last entered data will be present on Form. If User needs to enter new record, it becomes tedious to clear data from each of the text box, if Form comprises good number of text boxes. This will not be best way of utilizing User services. To avoid or improve efficiency of User, TM1 can be designed in better way using multiple Cubes. Create 2 named cubes, lookup cube (Test_Lookup) and cube which contains data (Test_Emp) Below are details of Dimensionality and structure of cubes Input Form where User can create new record, update record. Clear Button: ...

Most of the times business would like to generate reports in different formats to show data in different periods. They might be interested to display each set of data in different fonts, colors with capability of Row expansion. The easiest way to develop those kind of reports is, using TM1 Active Forms. To achieve this functionality using Active Forms, developer should know how to make each data set independent of each other so that none of them have influence of other. Let’s see how to create multiple active forms in single websheet as shown below: Above both data sets are displayed using ...