TM1 Perspective Websheets & Active Forms

​TM1 Perspective Websheets & Active Forms

TM1 Perspective Websheets & Active Forms can be extremely helpful to take your TM1 data and manipulate it with Excel’s formulas to get quicker turn around on ad-hoc reports and calculations that have not been designed in existing TM1 cubes. While the natural design of Active Forms, in general, is not as flexible as Websheets, they may require less maintenance in the long run on certain types of reports. This is especially true when rows in your report frequently need to bring in new elements each time they are added to a dimension. With some creative thinking and your Excel knowledge, you can actually get a lot more customizing into Active Forms than what you may have initially thought.

For more information on Perspective Websheets & Active Forms function, please reference the TM1 Reference Guide.

Add additional Excel formulas to the right of your Active Form area:

In this example, columns H – J are simple Excel calculations and are not reading from the TM1 database.

TM1 Perspective Websheets

Perspective Websheets & Active Forms

Show the Format Area and copy over to additional columns as needed:

TM1 Perspective Websheets

Perspective Websheets & Active Forms

Expand the range used in the Named Range called TM1RPTFMTRNG to include your additional columns:

TM1 Perspective Websheets

Perspective Websheets & Active Forms

TM1 Perspective Websheets

Perspective Websheets & Active Forms

Hide the Format Area and then Rebuild Current Sheet:

TM1 Perspective Websheets

Now your Excel formulas will expand and contract with the Active Form and include formatting.

If you liked this blog on TM1 Perspective Websheets & Active Forms then check out this really informative write up on what exactly the IBM Cognos Analytics Server (ICAS) is by clicking here.

Please contact us at services@lodestarsolutions.com for more information.

Leave a Comment

X
Send this to a friend