Revelwood

Your SUPER-powered WP Engine Site

Planning & Reporting

IBM Planning Analytics Tips & Tricks: Using Excel to get Client Information

by Leave a Comment

Did you know that you can now easily define your client version of Planning Analytics via an Excel formula?

There are many ways to determine your version of Planning Analytics. Some of these approaches include reviewing log files, right clicking on executable files, or simply clicking on a Help/About option. Planning Analytics version 2.0.0 introduces an easy approach get your client information via the use of an Excel formula.

The formula TM1INFO can be used to return information about your current TM1 client version.  The syntax of the formula is:

TM1INFO(parameter)

The formula allows for a series of parameters:

clientversion

Returns the full client version number.

clientversionmajor

Returns the major client version number.

clientversionminor

Returns the minor client version number.

clientversionpatch

Returns fix pack and hotfix number.

For example, the formula =TM1INFO(“clientversionmajor”) may give you a result of 11 whereas  =TM1INFO(“clientversion”) would give a more detailed result of 11.0.00200.

This new approach gives you an easy way to monitor your client version and help ensure consistency throughout your organization.

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 from the Revelwood team:

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets

IBM Planning Analytics Tips & Tricks: Creating Dynamic Sets in the PAx Set Editor

Home » Planning & Reporting » Page 16

IBM Planning Analytics Tips & Tricks: Compatibility of Views and Subsets

by Leave a Comment

Did you know that your parameters for VIEWCREATE and SUBSCREATE must be in sync?

Earlier this year we wrote a blog post about a new parameter that can be used with both the VIEWCREATE function and the SUBSETCREATE function. This new parameter allows TurboIntegrator to create temporary components that are deleted when the script closes.

There is, however, an important rule about the compatibility of the settings:

Temporary subsets cannot be assigned to permanent views.

Since a temporary subset is never saved, TM1 will not recognize it as an existing subset. If you attempt to insert a temporary subset into a permanent view then you will receive an error. The error will state that the subset is not found within the dimension and your process will fail.

The new parameter adds value by helping to clean-up your code and by potentially improving performance, but it’s important to ensure the compatibility of each component.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: New Parameters for TurboIntegrator

IBM Planning Analytics Tips & Tricks: Three Reserved Local Variables in TurboIntegrator

IBM Planning Analytics Tips & Tricks: TurboIntegrator Logging

Home » Planning & Reporting » Page 16

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

by Leave a Comment

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

Did you know there’s an easy way to create buttons that allow your users to switch sheets in IBM Planning Analytics Workspace (PAW)? For example, you’ve created multiple sheets in a PAW book and want to give your users the ability to switch back and forth between the different sheets. One simple way to do this is to create buttons on each sheet that point to other sheets.

To do this, click on the ‘create new button’ option at the top of your PAW window. This creates a new button on the sheet.

IBM Planning Analytics Tips & Tricks: Creating Buttons in PAW

Now you can use the Button properties menu at the top right of the PAW window to customize the button.

Learn how to create buttons in IBM Planning Analytics Workspace

You can edit the General style, such as the fill and border colors of the button.

How to create buttons in IBM Planning Analytics Workspace

You can edit Text properties, such as font style, size, and color.

IBM Planning Analytics Tips & Tricks: Learn how to create buttons in PAW

You can then edit the Button target, which will take the user to a sheet in the same book, a different book, or a hyperlink, such as your company’s intranet or some other website.

IBM Planning Analytics Tips & Tricks: Understanding how to create buttons in PAW

And finally, you can edit the Button text.

Creating buttons in IBM Planning Analytics Workspace

You now have a button on your sheet that points to another sheet in the same book. This approach can be used to easily link multiple sheets and to create easy-to-use navigation throughout your PAW environment.

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!

Get more IBM Planning Analytics Tips & Tricks:

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

IBM Planning Analytics Tips & Tricks: Customizing PAW Directory Server on Windows 2016

IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace (PAW)

Home » Planning & Reporting » Page 16

IBM Planning Analytics Tips & Tricks: Setting Default Members

by Leave a Comment

Did you know IBM Planning Analytics has a new function called “Default Members?” This is different from default subsets. Default members are what is used if you were to simply drag a dimension into a Planning Analytics for Excel (PAx) sheet or a Planning Analytics Workspace (PAW) book. Below is what it looks like when dragged into PAx:

Setting default members in Planning Analytics

The default members isn’t as simple as saving a subset, however. It is maintained in a Planning Analytics control cube called “}HierarchyProperties.” You simply pick the dimension that you wish to update, and update the “DefaultMember” for it.

Learn how to set default members in Planning Analytics
IBM Planning Analytics Tips & Tricks: Setting default members

However, if you immediately try to go back and refresh your PAx sheet, what you’ll see is the following:

Understanding default members in Planning Analytics

Nothing changed! There’s an additional step that is required to update the default member of a dimension. You can either:

  1. Restart the server
  2. Run a TI process with the new function called “REFRESHMDXHIERARCHY”

REFRESHMDXHIERARCHY can either be ran for a single dimension, as shown below, or can be run for all dimensions by simply not specifying a dimension.

IBM Planning Analytics: Setting default members

After running this TI process, you can then go back and update your PAx sheet or PAW book and receive the expected results.

Planning Analytics: Setting default members

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 on IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: String Feeders

IBM Planning Analytics Tips & Tricks: Using Attributes

IBM Planning Analytics Tips & Tricks: Conditional Feeders

Home » Planning & Reporting » Page 16

IBM Planning Analytics Tips & Tricks: Changes to Eight Planning Analytics Server Configuration Parameters

by Leave a Comment

This is a guest post from Revelwood’s Jay Apwah.

Did you know that since IBM Planning Analytics was released on the cloud, there have been changes to IBM Planning Analytics server configuration parameters? New parameters have been introduced, existing ones have had their default values changed, and the behavior upon changing has changed for some others. This blog post briefly describes the eight changes.

New Parameters:

There are a handful of new parameters that have been introduced. Here is one:

UseExcelSerialDate

Setting this parameter to T causes Planning Analytics functions to use Jan 1, 1900 as the initial serial date instead of Jan 1, 1960. Jan 1, 1900 is also the initial serial date that Microsoft Excel uses. The default value for this parameter is F. Set UseExcelSerialDate = T for Planning Analytics functions to use the Excel serial date scheme.

Changes to default value:

MTQ

In previous releases, the default value was F. The default value is now ALL. This parameter allows Planning Analytics to take advantage of multiple processor cores in order to split calculations into multiple parallel threads.

MDXSelectCalculatedMemberInputs

In previous releases, the default value was F. The default value is now T.  This parameter protects against unintended suppression of calculated members when the calculation components are not requested in the query results.

Changed from static to dynamic:

Some parameters are now dynamic, which means parameter values can be edited while the Planning Analytics server is running. It takes 60 seconds for the changed parameter value to take effect.

AuditLogOn

This is an optional parameter that enables and disables audit logging. To enable, set AuditLogOn = T

IntegratedSecurityMode

Although this parameter is dynamic, each user must be logged out of all Planning Analytics components it to take effect.

UseLocalCopiesforPublicDynamicSubsets

This parameter improves performance of public dynamic subsets by using local copies of the public subset instead of the public subset itself.

No longer used:

AuditLogMaxTempFileSize

A similar parameter still exists: AuditLogMaxFileSize. Use it to indicate the maximum audit log file size before a new one is created.

ParallelInteraction

This parameter was used for allowing read/write concurrency on the same cube object.

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 additional blog posts on IBM Planning Analytics Tips & Tricks:

Top 5 IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Using Attributes

IBM Planning Analytics Tips & Tricks: Upgrading from TM1

Home » Planning & Reporting » Page 16

New Performance Tune-Up Service for TM1 & IBM Planning Analytics Users

by Leave a Comment

In response to customer requests, we’ve been expanding our Customer Care program. The newest option is a Performance Tune-Up. Proper maintenance of your TM1/Planning Analytics environment is the key to overall good health and performance. Think of our team as your “mechanics” for your solution. You take your car to the auto shop for regular tune-ups. Why not do the same for TM1/Planning Analytics?

We’ve designed this service to make sure your system is running at its best. It is a recurring, scheduled maintenance program consisting of annual tune-ups and quarterly tune-ups. We’ll conduct interviews with your users and detailed technical reviews of your cube models, reports, business processes and the overall environment.

The Performance Tune-Up accomplishes many things, including:

  • Verifying that your TM1/Planning Analytics solution is maintaining peak performance levels and meeting your business and technical requirements
  • Confirming you are up-to-date with the latest IBM technology and leveraging new features and capabilities
  • Ensuring a positive end-user experience

We also offer other services for customer care. These include a subscription-based dedicated TM1/Planning Analytics Help Desk and a System Administration as a Service (SAaaS) offering. Our dedicated TM1 Planning Analytics Help Desk helps you diagnose, troubleshoot and resolve bugs and other issues related to your entire TM1/Planning Analytics environment – including all of your customizations and configurations. Our SAaaS solution is designed to free up your team from the labors of TM1 administration and comes in two options: fully out-sourced coverage and backup/supplemental coverage.

Let our expert team at Revelwood free up your time by taking advantage of our Customer Care program today!

Home » Planning & Reporting » Page 16

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

by Leave a Comment

Did you know that you can easily synchronize your selectors with your IBM Planning Analytics Workspace (PAW) components?

PAW allows you to synchronize your widgets to a selector or set of selectors. This ensures that a change in your selected elements impacts all of the widgets on your page. Synchronization is defined by clicking on the dashboard properties and selecting the option for “Synchronization scope.”

Synchronizing selectors in IBM Planning Analytics Workspace

You will be given the option to synchronize items for the selected sheet or throughout the entire book.

How to synchronize selectors in IBM Planning Analytics Workspace

Once selected, you can now define the dimensions you want to synchronize throughout the sheet or the book. This approach allows you to create powerful dashboards with live data that can be changed via a single selector.

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!

Home » Planning & Reporting » Page 16

Revelwood Launches Adaptive Insights Practice

by Leave a Comment

Since our founding in 1995, Revelwood has been fiercely committed to working with what we believe to be the absolute best-in-class analytics technologies on the market. Despite overtures from many vendors in the space, we’ve always held to certain principles that dictate the vendors we choose to work with.

When it comes to FP&A solutions, factors like ease-of-use, performance, breadth of functionality, scalability, vendor strength and product vision are paramount. We’re passionate about working with great products and want to share that enthusiasm with our clients. Your success in managing the FP&A process of your enterprise is our #1 objective.

Earlier this year Revelwood was invited to join the Adaptive Insights partner channel in North America. Adaptive Insights is a cloud-based FP&A solution with over 4,000 customers worldwide spanning just about every industry. After nearly a year of vetting a variety of vendors in the space, we excitedly accepted their invitation and are off to a fantastic start.

According to Mel Zeledon, VP of Global Channels and Alliances for Adaptive Insights…

“I am very proud to have Revelwood as part of the Adaptive Insights partner ecosystem. I have personally worked with Revelwood for over a decade, and they were the first prospective partner that I turned to when I joined the company. Revelwood’s reputation in the market is impeccable, driven by their passion to drive absolute customer success in every one of their engagements. Revelwood is not like any other consulting company – they truly focus on business strategy and business outcomes from the very beginning of the engagement. Every company that engages with Revelwood just becomes better. Grounded in very well-established company core values, they provide deep business knowledge, technological prowess and the ability to run large and complex projects. They are accountable, reliable and a partner for the long haul.”

Although Adaptive Insights is probably best known for its market-leading presence in the small and mid-market space (allowing Revelwood to address the below $100M market), it has steadily expanded its footprint in large enterprises, as well, with clients like Boston Scientific, P.F. Chang’s, Siemens, Domo, Papyrus, Harry’s and Toyota. Their development team has put a tremendous focus on scalability and performance to allow the product to support much larger models and user volumes. Perhaps most significantly, they were recently acquired by Workday for $25 billion as the cornerstone of Workday’s Business Planning suite.

While we continue to maintain our great partnership with IBM and support new and existing clients on its Planning Analytics and Cognos Analytics platforms, we’re equally excited to expand our portfolio and reach new markets and customers with Adaptive Insights and Workday.

If you have any questions about either of these market leaders (both of whom appear in Gartner’s upper right “Leaders” Quadrant in the July 2018 Magic Quadrant for Cloud Financial Planning and Analysis Solutions), please give us a call. Our success is predicated on your success.

Home » Planning & Reporting » Page 16

IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web

by Leave a Comment

Did you know there are a number of workarounds available for Excel functions that are not supported by TM1 Web? This blog post is the second in a series discussing these workarounds. Below, I’ll describe ways to accomplish the same results using functions that are compatible online.

Function: CELL

Description: Returns information about the formatting, location, or contents of a cell

Please note that workarounds only exist for some of the information supported by the CELL function.

 ABCD
1InputOriginalResultCompatible with TM1 Web
21CELL(“address”,A2)$A$2ADDRESS(2,1)
3 CELL(“col”,A2)1COLUMN(A2)
11 CELL(“row”,A2)2ROW(A2)

Function: ISLOGICAL

Description: Returns TRUE if the value is a logical value

 ABCD
1InputOriginalResultCompatible with TM1 Web
21ISLOGICAL(A2)FALSEIF(OR(A2=TRUE,TEXT(A2,””)=”FALSE”),TRUE,FALSE)

Function: N

Description: Returns a value converted to a number

 ABCD
1InputOriginalResultCompatible with TM1 Web
21/1/2018N(A2)43101VALUE(A2)
3   NUMBERVALUE(A2)

Function: QUOTIENT

Description: Returns the integer portion of a division

 ABCD
1InputOriginalResultCompatible with TM1 Web
25QUOTIENT(A1/A2)2FLOOR.MATH(A1/A2)
32   

Function: SQRTPI

Description: Returns the square root of (number * pi)

 ABCD
1InputOriginalResultCompatible with TM1 Web
24SQRTPI(A2)3.544907702SQRT(A2*PI())

IBM’s documentation on Excel functions that are not supported by TM1 Web can be found here.

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!

Home » Planning & Reporting » Page 16