IBM
Why are my PAx Options blank?
Why are my PAx (Planning Analytics) Options blank? You’ve just installed PAX opened the Options screen and there is nothing there. This is a known issue that can effect some users with multiple displays. Resolving the issue is quite easy. Open Microsoft Excel and navigate to the Options >> General >> User Interface Options section…
Read MoreAdding an Overall Header and Footer in Cognos Analytics Report 11.0+
Use an overall footer to add a high-level summary data set to the end of your report. Unlike a “List Page Header and Footer” which appears at the top or bottom of every page respectively in which list data appears, an “Overall Header and Footer” only appears once at the top or bottom of the…
Read MoreDrag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)
Planning Analytics Workspace (PAW) is a lot more than just a pretty face – it’s the primary tool for developing and maintaining Planning Analytics models. It can be used for everything from building structures, to writing rules or TI processes, and even maintaining security. Development and prototyping in PAW is a lot faster and easier…
Read MoreDrag and Drop Cube Load in Planning Analytics Workspace (PAW)
In another #AskQueBIT article (Drag and Drop a File to Create a Dimension in PAW), we demonstrated how easy it is to build a dimension by dragging and dropping a file into the dimension editor in PAW (Planning Analytics Workspace) . In this article, we’ll take our prototyping one step further by loading data into…
Read MoreMigrating Planning Analytics Workspace (PAW) Content
So, you’ve built a suite of beautiful input templates, reports, and dashboards in the PAW development environment, and now you want to deploy them to production. Migrating books and views can be done quickly and easily by following these steps: Click your name in the upper right corner of the PAW screen and select Administer.…
Read MoreCreate 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 More