Posts by agoddard
Create Dynamic Views with MDX
Planning Analytics (PA) sets and views can be created using multi-dimensional expression (MDX) language to make them dynamic and help to automate PA applications. One simple way to harness the power of MDX in your PA application is to create a “Current Time Period” set that can be used to make any view dynamically show…
Read MoreOrganizing and Distributing PAW Content with Folders
Planning Analytics Workspace (PAW) administrators should plan how they would like to manage and distribute their content before users access it. In PAW, books and views can be grouped into folders, which save valuable screen real estate, improve the user experience, and simplify security administration. Screen Real Estate is Valuable. Screen real estate is highly…
Read MoreIntro to PAW Hierarchies, aka “Virtual Dimensions”
In another #AskQueBIT (Drag and Drop Cube Load in Planning Analytics Workspace (PAW)) article, we showed you how to load data to a cube by dragging and dropping a .csv file onto the workspace. The cube that we used is relatively simple, with only 3 dimensions: Award Year Person Award However, both the Person and…
Read MoreMaintaining PAW Hierarchies with TurboIntegrator
In a previous article, we reviewed how to manually create Planning Analytics Workspace (PAW) hierarchies based on attributes. This allows you to create “virtual dimensions” based on these attributes that can be used for further analysis…but what happens when the attribute values change? Today, we’ll show you how to use TurboIntegrator (TI) to maintain your…
Read MoreUse Snap Commands for Natural Language Queries
Planning Analytics Workspace (PAW) has many new features that enhance the user experience and make accessing and analyzing data easier than ever. The new Snap Command feature in PAW allows users to use natural language commands to manipulate explorations and other visualizations – this can be a huge time-saver! The Snap Command feature can be…
Read MoreQuick and Easy Top-Down Planning in PAW
So, you’ve spent some long hours painstakingly gathering inputs from all department heads to build up your highly detailed, bottoms-up forecast in Planning Analytics and now the CFO wants to make some high-level (top-down) adjustments. All the previous data spreading options (repeat, proportional, growth, etc.) are still available by right-clicking a cell and selecting data…
Read MoreAutomating Planning Analytics Report Distribution, or Where is My Print Report?
With the move from Perspectives to the new-and-improved Planning Analytics for Excel – many people are asking “Where is my Print Report?” For those of you who’ve never experienced Print Report in all of its glory, it was an amazing feature in Perspectives that allowed users to generate reports with multiple sheets or books driven…
Read MoreDynamic sub-totals when hierarchies are not available
In any given TM1 model developers make use of attributes in a dimension. These attributes can have a multitude of uses, i.e. driving calculations or serve as reference in a report or sometimes they drive hierarchy structures and many others. The use case we will discuss in this instance is the use of attributes to…
Read MoreImprove Performance and Create an Image Repository in PAW with Data URIs
During the recent IBM Think 2019 conference in San Francisco, CA, I went to the “Planning Analytics Workspace for Power Users” session led by the PAW developers. They shared a lot of exciting new features that we can expect in upcoming PAW releases, along with some advanced tips and tricks that are already available today.…
Read MoreUtilizing Groups and Roles with Security in Cognos Analytics 11.0.XX
Business Case: One key to an easily managed security structure and tailored data portal in IBM Cognos Analytics is to utilize groups and roles. If you are using the roles that are predefined or created in the Cognos namespace, you can customize themes, home pages, and report parameters that are unique to each function area. …
Read More