IBM Cognos TM1

IBM Planning Analytics Tips & Tricks: Log Lock Notification

December 8, 2020 by Lee Lazarow Leave a Comment

Have you ever tried to move or download log files and then realize that some of the files cannot be modified since they are in use? IBM Planning Analytics Workspace (PAW) recognizes this and now offers notifications to let you know which files are locked.

You can download log files by first selecting the PA Administration button at the top of your screen.

IBM Planning Analytics Tips & Tricks: Log Lock Notification

One inside the administration area, you can view the logs by clicking on the three dots at the top, right corner of your server and selecting the option called “Download logs.”

From there, you can simply select the logs that you want to download and then select the “download” button at the bottom of the screen. Any locked log files will show the word “locked” on the screen and will also prevent you from selecting that log. The example below shows the tm1server.log file checked and shows the tm1s.log file as locked.

IBM Planning Analytics Tricks: Log Lock Notification

This approach will help you easily remember which files are accessible and which are not.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

December 1, 2020 by Thanh Chau Leave a Comment

One of the helpful features of IBM Planning Analytics is the ability to create explorations using asymmetric axes. This is useful when you have stacked column or row dimensions, and only want to display certain combinations of elements instead of all combinations of the stacked dimensions.

To do this in Planning Analytics Workspace (PAW), open a workbook in PAW and open an exploration. Click on the icon to make the row dimensions asymmetric or the icon for the column dimensions. Next, hold down the CTRL key and select the rows or columns you want to keep or hide.

IBM Planning Analytics Tips & Tricks: Asymmetric axis in PAW

Right-click on one of the selected columns and select “Keep” or “Hide.”

If you need to revert back to the normal view, right-click on any row or column and select “Unhide All.”

IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports

November 24, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) provides the ability to convert an existing view directly to a report in Excel? Without opening the view as an Exploration, you can start building your report directly from the Task Pane.

Just right-click on the view in the Task Pane to display the available options.

IBM Planning Analytics Tips & Tricks: Convert Existing View to Reports

You will see the following options by hovering over the Quick report, Dynamic report, and Custom report items:

How to convert existing views into reports in Planning Analytics

In this example, each of the items does the following:

On this sheet: This will open the existing Planning Analytics view as a Quick report on the current Excel sheet at cell $A$1.
On new sheet: This will open the view as a Quick report on a new sheet at cell $A$1.
At current location: This will open the view as a Quick report at the cell that is currently active.
At specified location: This will open a pop-up window that allows you to input the cell at which you would like the Quick report to appear. You can then enter the cell address and click OK to generate the Quick report, as shown in the following image.

Learn how to convert existing views to reports in Planning Analytics

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

November 17, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) automatically keeps track of the Planning Analytics objects you have open in an Excel workbook?

Simply click on the Workbook tab of your Task Pane to view the list of Dynamic reports, Action buttons, Explorations, and Quick reports that are currently in use.

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

These folders will be populated as you work with your Planning Analytics environment. Whether you manually add these items to a worksheet, or they are included in an existing view or report, they will appear here.

For example, clicking the Exploration button in the PAx ribbon will create an Exploration on a new worksheet.

The PAx task pane workbook tab in IBM Planning Analytics

This will also add an item to the Explorations folder on the Workbook tab of the Task Pane. When you right-click on the name of the new Exploration, you will see the following options:

Learn about the PAx task pane workbook tab in IBM Planning Analytics

Similar options appear for Dynamic reports, Action buttons, and Quick reports.

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

November 10, 2020 by Lee Lazarow Leave a Comment

In the early days of computing, printers often used paper that had alternating white and green areas which allowed the reader to easily follow a line of text across the page. This was known as “green bar” paper. While we no longer use this type of paper, the concept is still applicable for situations where your output contains many columns that are hard to follow.

You can create this approach by using alternate row formats within your Excel reports. This is done by combining two Excel formulas:

The ROW formula returns the row number for a cell reference. For example, ROW(K5) returns the number 5 since the cell is in the 5^th row of the spreadsheet.
The MOD formula returns the remainder of two numbers after division. For example, MOD(9,2) returns the number 1.

When combined, the following formula will result in either a 1 or a 0:

=MOD(ROW(cell),2)

From there, you can use conditional formatting to define the fill colors. If you are doing this in standard Excel, then you can copy the formula throughout the applicable area. If you are doing this within a dynamic report, then you can use it within the formatting area.

This approach allows you to make your wide reports easier to read. This also means that you can recreate the green bar format while you pull out your dot matrix printer and watch classic movies such as Wargames!

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

November 3, 2020 by Lee Lazarow Leave a Comment

Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding one side of the subset editor.

Here is an example of the subset editor which shows both the available members and the current set.

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

Each of the two sections has an option to minimize the area. This is done by clicking on the minus symbol at the top of the applicable section.

IBM Planning Analytics: Minimizing the Subset Area

Once clicked, the applicable area will compress and the other area will expand. Note that you can only minimize one side at a time. Below are examples of what each screen will look like when compressed.

Minimized Available Members:

IBM Planning Analytics Tips: Minimizing the Subsea Area

Minimized Current Set:

Minimizing the subset area in IBM Planning Analytics

This approach will allow you to further customize your subset editor screen to allow you to focus only on the area you want to see.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Maintaining Subset-Drive Consolidations

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

IBM Planning Analytics Tips & Tricks: Show Members

October 27, 2020 by Lee Lazarow Leave a Comment

Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here’s how you can do this:

Step 1: Select the dimension to be edited. This is done by either right clicking on a dimension and selecting the option to “Edit Dimension” or by dragging the dimension onto a sheet.

Step 2: Right click on an element and select the option to “Show Member.” You will then see two sub-options: one for Parents and one for Children.

IBM Planning Analytics Tips & Tricks: Show Members

If you select the option for Parents then you will see all of the parents associated with the selected element. In this example, there is only one parent within the dimension structure.

If you select the option for Children then you will see all of the children associated with the selected element. In this example, there are three elements in the consolidation.

How to show members in IBM Planning Analytics

Once defined, you can then perform dimension maintenance to each of the elements on your screen.

This approach allows you to easily traverse up or down your dimension while minimizing the amount of extra elements on the screen.

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

October 20, 2020 by Lee Lazarow Leave a Comment

Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to define elements within a dimension.

The example below shows the results of a subset that includes all descendants of Total Department. The subset was created by simply dragging Total Departments into the current set while having the member insertion defined as descendants.

Once created, I can see the MDX expression that is used by clicking the MDX button at the top, right corner of the screen. The resulting expression is:

However, this button is not only used to view your newly created MDX expressions. The button also allows you to edit the expression. In this case, I can change the root element to be Sales and Marketing by simply typing over the existing MDX expression.

After clicking the OK button, the elements in the current set are updated.

This approach can help you to learn the fundamentals of MDX expressions, which are helpful for many different components of Planning Analytics.

IBM Planning Analytics Workspace (PAW) Version 2.0.57 Release

October 16, 2020 by Lee Lazarow Leave a Comment

IBM recently released Version 2.0.57 of Planning Analytics Workspace (PAW). Version 2.0.57 is currently offered as a local-only release and will soon be available on the cloud (as version 2.0.58). This update contains many significant changes, including both new functionality and a different look and feel.

Some of these changes include:

Overall Interface

An updated Planning Analytics Workspace user interface provides a more consistent experience with other IBM products. This includes a new home page that is customized for your role within PAW and new icons that can be used to simplify the user experience.

Predictive Forecasting

The introduction of Predictive forecasting allows you to easily model trends, seasonality, and time dependence in your data. If you are familiar with time series modeling then you can view details associated with the model type, model parameters, and accuracy measures. If you are not familiar with time series modeling, then AI driven model selection and tuning will assist you. The resulting data will provide both forecasted values and confidence boundaries.

IBM Planning Analytics Workspace (PAW) v2.0.57

New Organizational Approaches

Applications help you easily group together PAW assets such as books, views, and websheets. This approach can be used to help you organize assets in ways related to the structure of your organization. This is like the legacy Applications folder that exists in TM1.

IBM releases Planning Analytics Workspace v2.0.57

New Workflow Approaches

Plans allow an administrator to create a step by step walk through of your business processes. This will help end users better understand and follow the steps within your process. This will also minimize the times for users to find their required reports and templates.

Learn about IBM Planning Analytics Workspace (PAW) v2.0.57

Book and Visualization Improvements

New properties and drag-and-drop approaches give you more control over the objects within a book while still offering an easy way to create each component. IBM has also expanded the available set of visualizations, including the addition of waterfall charts and multi-line column charts.

Get info on IBM Planning Analytics Workspace (PAW) v2.0.57

Updated Administration

An updated administration page allows you to quickly see an overview of your databases, users, and groups on a single page.

Understanding IBM Planning Analytics Workspace (PAW) v2.0.57

The Ability to Enable the New Features

Version 58 will allow administrators and users to preview the new features. Administrators will be able to enable preview mode and users will be able to “Return to Classic Experience.” Books created in the classic experience can be opened in the new experience and users can then use a “Save As” approach to update books with the new features.

Tech Bulletin: IBM Planning Analytics Workspace (PAW) v2.0.57

Further details about these new items can be found on IBM’s website.

If you have questions or would like to speak with us about these changes, please contact John Pra Sisto at jprasisto@revelwood.com.

IBM Planning Analytics Tips & Tricks: Log Lock Notification

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports

Read more IBM Planning Analytics Tips & Tricks posts:

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

Read more IBM Planning Analytics Tips & Tricks posts:

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

IBM Planning Analytics Tips & Tricks: Show Members

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

Read more IBM Planning Analytics Tips & Tricks: