Revelwood, Author at Revelwood Knowledge Center – Page 6 of 8
Revelwood, Author at Revelwood Knowledge Center – Page 6 of 8

This is a guest post and video by Revelwood’s Jay Apwah. Did you know IBM Planning Analytics Workspace enables you to perform analysis on data in attribute-based hierarchies? Hierarchies are commonly used for analysis, but can also be used for filtering as well. Watch this short video for an overview and demo of attribute-based hierarchies in Planning Analytics Workspace and you’ll learn: What hierarchies are Why you’ll want to use hierarchies How easy it is to create hierarchies, input data, … Read More


This is a guest blog post by Revelwood’s Nicole Frigo. Did you know that 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 … Read More


This is a guest blog post by Revelwood’s Jay Apwah. Did you know you there are many sample files available for Cognos Analytics? In order to better experience and understand new features in releases of Cognos Analytics, it is recommended that you install the sample databases, models, dashboards and reports. Installing the samples involves the following four steps: Installing the samples Importing the sample content from its archive Restoring the sample databases from backups Creating data source connections in Cognos … Read More


This is a guest post by Revelwood’s Nina Gordy.  Did you know 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. To do this, simply insert a TM1RPTFILTER formula into a cell on the … Read More


This is a guest post by Revelwood’s Shane Bethea.  Did you know you can use MDX to compare dimension hierarchies? IBM Cognos TM1 dimensions often have multiple hierarchies that should all roll up to the same total.  Said another way, these separate hierarchies should all contain the same set of n-level elements below them.  For example, a customer dimension may have a hierarchy for rolling up the ‘All Customers – by Type’ and another for ‘All Customers – by Region.’  … Read More


This is a guest post and video by Revelwood’s Shane Bethea.  Did you know IBM Cognos TM1 has a unique implementation of MDX, with TM1-specific functions and expressions? MDX, which stands for multidimensional expressions and is similar to SQL, is for multidimensional data in OLAP cubes. It is used by many different vendors for their OLAP solutions, but TM1 uses it in some product-specific ways. Watch this short demo I’ve created and you’ll learn: what MDX is, and how to … Read More


VIEW MORE ARTICLES >


« First‹ Previous567Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.