TM1

Did you know IBM Planning Analytics Workspace allows you to add comments to your data set?

During both planning and reporting cycles, many clients often ask how they can add comments into their data set. After all, the goal of a Planning Analytics database is to have a single source of data … both numeric and text.

Planning Analytics Workspace allows you to insert comments into your explorations quickly and easily.

Step 1:

Right click on the cell where you want to insert the comment and select the option for “Comments”. As with all string values in Planning Analytics, comments can be added at either a base level or a consolidated level.

Step 2:

Click on “Add Comment”, enter your comment, and select the option to “Post”. You can enter multiple comments into a single data cell.

Step 3:

A blue triangle will now appear in the top, right corner. You can follow the tasks in step 1 to review the existing comments.

In addition to viewing the comments in PAW, the information is stored in a control cube called }CellAnnotations_CUBENAME. The data point contains a lot of metadata information to define the caption, the creator, the intersection, and other reference points. However, this data could easily be cleaned up and be included in reports.

IBM Planning Analytics 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!

Read more blog posts in the IBM Planning Analytics Tips & Tricks Series:

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace (PAW)

IBM Planning Analytics Tips & Tricks: Customizing Planning Analytics Workspace (PAW) Directory Installation on Windows Server 2016

IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace

Need more help? Learn about our Customer Care options for IBM Planning Analytics & TM1 users. 

This is a guest post from Revelwood’s Shane Bethea.

Did you know that you can quickly and easily create a new time dimension in the Planning Analytics Workspace (PAW) Dimension editor? The following steps will automatically create a time dimension with a standard hierarchy and pre-populated set of attributes in a matter of seconds.

To create your time dimension using the PAW Dimension editor, simply right click Dimensions in the left hand navigation tree and select Create dimension.

Enter a name for your new time dimension and then click Create.

Select the ‘Customize as Time’ button to open the time interface.

Select the start year, end year, and element granularity (Year, Quarter, or Month) and then click Create.

This will create a new time dimension, complete with a calendar year’s Year/Quarter/Month hierarchy and a standard set of attributes.

Once created, you can add or modify these attributes based on your reporting and analytics needs. Stay tuned for more entries covering more features and the other modeling widgets.

IBM Planning Analytics 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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Did you know there are several benefits to using hierarchies in IBM Planning Analytics?

Hierarchies are one of the additional features available in Planning Analytics. The main benefit of hierarchies is that they enable users to see alternative data rollups in the same view. There are several reasons to take advantage of this new approach to interacting with your data.

Hierarchies can improve query performance. Modeling attributes as hierarchies instead of dimensions can save memory space. This allows for cubes with fewer dimensions, while using hierarchies as virtual dimensions.

 Attributes can be turned into hierarchies. Hierarchies provide greater flexibility. Updating a hierarchy is as easy as updating an attribute. A single dimension can contain multiple hierarchies, and multiple hierarchies can be displayed in the same view.

 Hierarchies can be created and maintained manually or via TurboIntegrator process. This gives users flexibility to choose the method by which their hierarchies are maintained. Planning Analytics provides a user-friendly interface for manual maintenance, while TI processes can make automated maintenance fast and simple.

Planning Analytics hierarchies enable you to gain informative and flexible insight into your data, while utilizing fewer resources.

IBM Planning Analytics 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!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: GMT vs Local Time

IBM Planning Analytics Tips & Tricks: Captions

IBM Planning Analytics Tips & Tricks: Regions with Planning Analytics Rules

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.