IBM
Why Are My Planning Analytics for Excel (PAX) Options Blank and How Do I Fix It?
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 MoreHow Do I Add an Overall Header and Footer in a Cognos Analytics 11.0 Report to Show Summary Information Once?
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 MoreHow Do I Drag 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 MoreHow Do I Use Drag-and-Drop to Load Data into a Cube 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 MoreHow Do I Migrate Planning Analytics Workspace (PAW) Content Between Environments?
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 MoreHow Do I Create Dynamic Views Using MDX in IBM Planning Analytics?
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 MoreHow Do I Organize and Distribute PAW Content Using Folders in IBM Planning Analytics Workspace?
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 MoreWhat Are PAW Hierarchies (Virtual Dimensions) and How Do I Use Them in Planning Analytics Workspace?
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 MoreHow Do I Use TurboIntegrator to Maintain and Update Hierarchies in Planning Analytics Workspace (PAW)?
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 MoreHow Do I Use Snap Commands in Planning Analytics Workspace to Run 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