Analytics Archives – Page 2 of 17 – Revelwood Knowledge Center
Analytics Archives – Page 2 of 17 – Revelwood Knowledge Center

This is a guest blog post from Revelwood’s Nina Gordy.  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 … Read More


Did you know that there are different ways to create selectors in IBM Planning Analytics Workspace (PAW)? TM1 Perspectives allows you to create selectors via the SUBNM formula. This approach offers an easy way to create a selectable list on a report or input template, but it requires some training to learn how to create and manipulate the formula. PAW allows users to more easily create selectors by simply dragging items onto the screen via a “selector widget.” This is … Read More


Each year BPM Partners releases its Business Performance Management (BPM) vendor landscape report. According to the firm, the purpose of the report is to “provide a point-in-time snapshot of all the core players, their status in the market, and the focus of their offerings.” This year’s report found “cloud momentum picked up with the vast majority of vendors seeing their cloud version account for the bulk of their sales.” The report also states that the “focus on the customer has … Read More


This is a guest blog post from Revelwood’s Shane Bethea. Did you know that you can use the IBM Planning Analytics for Excel (PAx) Set Editor to create dynamic sets to be used in a view? This can be accomplished by using the ‘Search available members’ bar in the set editor. I will use the bpmAccount dimension in this example. Start by opening the set editor in PAx. Right click the bpmAccount dimension (or click the drop down arrow by … Read More


CFOs in companies of all sizes are assessing how, when and where they should automate their finance functions and processes. One of our partners, Adaptive Insights, recently surveyed 160 CFOs across the globe for its most recent CFO Indicator Report, Full Steam Ahead: Finance on Board with Automation. Among other things, the survey found that 40% of them consider the biggest driver behind automation is the demand for faster, higher quality insights from executives and operational stakeholders. The report explains … Read More


Did you know that that way you write your rule could impact the performance of the model in IBM Planning Analytics? There are three parts to a rule. The area definition describes the section of the cube to which the rule will apply. The qualifier allows formulas to be restricted to base level numbers, consolidated, numbers or string values. And the formula defines how the components will be calculated. Sometimes I am asked about the best approach to use when … Read More


VIEW MORE ARTICLES >


‹ Previous123Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.