IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Making Default Cube Views Dynamic with MDX
This is a guest post by Revelwood's Jay Apwah. Did you know you can easily update a cube value to control the period elements that will display in a subset used in views? In this blog post, I detail a scenario why you…
April 10, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New Configuration Setting for Dates
This is a guest post from Revelwood's Shane Bethea. Did you know IBM Planning Analytics 2.0 has a new feature that makes it easier to manipulate dates? Previously, when manipulating dates in IBM Planning Analytics / TM1, I always had to reach…
February 27, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video Demo: Hierarchies in Planning Analytics Workspace
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…
February 20, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Tips & Tricks: Asymmetrical Axis in PAx
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…
February 6, 2018
IBM Planning Analytics Tips & Tricks
Tips & Tricks: Installing Samples with Cognos Analytics
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…
January 30, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using MDX to Compare Dimension Hierarchies
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…
January 16, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Converting Reports to PAx
This is a guest blog post by Revelwood’s Nicole Frigo. Did you know you can easily convert existing Perspective reports to IBM Planning Analytics for Excel (PAx)? Converting reports and upgrading action buttons require just a few simple steps when transitioning to…
December 19, 2017
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Custom landing pages for TM1 Web
This is a guest blog post by Revelwood’s Susan Musselman. Did you know you can not only set up a landing page for IBM Cognos TM1 Web, but you can also set up custom landing pages for different groups of users? Here's…
December 12, 2017
IBM Planning Analytics Tips & Tricks
Tips & Tricks for Using TM1 – Variance Analysis in IBM Cognos TM1
This is a guest blog post by Revelwood's Susan Musselman. Did you know many companies find it beneficial to do a variance analysis to identify differences between the planned financial outcomes and the actual financial outcomes? Many clients prefer to store account…