Every Tuesday we publish a new IBM Planning Analytics Tips & Tricks blog post. Today’s post is the first in a series of three highlighting our 15 most popular blog posts of 2018.
IBM Planning Analytics for Microsoft Excel (PAx) provides several tools to view, maintain, and report on your Planning Analytics data. Dynamic Reports, one of the PAx reporting tools, allows you to create flexible reports with personalized formatting. An example of this is a ranked report, which will display and sort the top set of rows. Read the full blog post to learn how to insert a TM1RPTFILTER formula into a cell on the Excel worksheet containing the Dynamic Report.
IBM Planning Analytics for Excel (PAx) gives you the ability to use an asymmetrical approach that allows you to display combinations of elements without the repetition. IBM Cognos TM1 and IBM Planning Analytics gives you the ability to quickly create views of your existing data. The views are symmetrical, which means that any rows or columns that contain multiple elements will include all possible combinations of the selected elements. But sometimes you may not want to see all combinations.
Read the full blog post for an example of a symmetrical view that will be converted into an asymmetrical view. The example will use a Financial GL cube.
IBM Planning Analytics enables you to create a temporary VIEW or SUBSET TurboIntegrator function. This blog post explains why you may need to, and how to do so. IBM has gone to great lengths to ensure that the transition to Planning Analytics is a seamless process and has added some new functionality to help make your system more efficient.
Two commonly used TurboIntegrator (TI) functions are SUBSETCREATE and VIEWCREATE. These processes are used to create a new component in your process, but they sometimes can cause an issue. If you create a new subset or view in the prolog but then have the process fail with the DATA tab then the process will end without removing the new components. This is most likely because VIEWDESTROY and SUBSETDESTROY are most likely within the Epilog.
There are ways to code around this in the existing version of TM1, but Planning Analytics now offers the ability to create a temporary VIEW or SUBSET as of version 10.2.2 FP4. This is done by adding a flag at the end of the command.
Did you know you can easily reset cube logging in TM1? A previous tech tip was written to discuss when to enable and disable logging. As stated in that posting, it is best practice to turn cube logging off while processing TurboIntegrator processes. Typically, logging is turned off in the Prolog and turned back on in the Epilog. But if an error occurs when the process is run, it never reaches the Epilog and logging never gets turned back on.
There are several ways to prevent data entry to TM1 in TM1 Web websheets. The first approach can be used for input templates. Use this approach when you want your users to be able to enter data for certain cells/columns, but not others. By default, every cell in an Excel worksheet has the ‘Locked’ property set. This property has no effect on the cell unless the sheet or workbook is protected. In this example, we can select certain cells of an input template to be enterable and certain cells to be locked down or protected. To unlock certain cells in the template, right click the cells and select Format Cells. In the Format Cells dialogue box, select the Protection tab, uncheck the Locked checkbox, and select OK. Read the full blog post to learn the details.
Come back next week to read about the next five most popular blog posts of 2018.