IBM
How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?
What Can a List Header and Footer Do for you in Cognos Analytics 11+ Just make your report look and read great! I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report. I tried using singleton’s and…
Read MoreHow Do I Create Professional-Looking Dashboards in IBM Planning Analytics Workspace (PAW)?
Are you looking for professional ways to display your organization’s data within Planning Analytics Workspace (PAW)? Well, you have come to the right place! When illustrating your complex operational and financial data, it helps to have a clean and consistent budgeting and forecasting presentation to drive planning efficiency. The tips below offer quick ways to…
Read MoreWhy 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 More