Cognos Analytics
![](https://quebit.com/askquebit/wp-content/uploads/2019/10/CompRef1-min.jpg)
Layout Component References in Cognos Reports Version 11.1.X
How to use a Layout Component Reference, and override components when necessary! One of the main struggles report authors face is the maintenance of production reports. It’s not enough to just create the report, one must also ensure the report is updated as changes are made to corporate privacy notifications, colors and logos. This is…
![](https://quebit.com/askquebit/wp-content/uploads/2019/10/TOC1-min.jpg)
Adding a Table of Contents in Cognos Reports Version 11.1.X
Don’t hunt and peck for your piece of the report, use a table of contents! A table of contents, sometimes headed as Contents or abbreviated informally as TOC, is a list usually found on the first page of a report. It includes section titles or brief descriptions with their corresponding page numbers. When running a…
![](https://quebit.com/askquebit/wp-content/uploads/2019/10/Custom-Controls1-min.jpg)
The Joy of Custom Controls in Cognos Reports Version 11.1.X
Here’s how to toggle between hiding and showing parts of a report Custom Controls, a new capability with release eleven, easily enables the report author to add Java Script to the report, thus providing an enhanced user experience when rendering the data in HTML. As long as the report is running in full interactive mode,…
![](https://quebit.com/askquebit/wp-content/uploads/2019/01/1-min.jpg)
Adding 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…
![](https://quebit.com/askquebit/wp-content/uploads/2018/11/CA11HF-min-1024x500.jpg)
What Can a List Header and Footer Do for you 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…
![](https://quebit.com/askquebit/wp-content/uploads/2018/06/DF1-1024x434.jpg)
Creating and Setting a Default Theme for Cognos Analytics 11.0.4+
Wow, branding on my Cognos Portal! Business Case: When using Cognos Analytics V11, there is a default theme which is quite nice, but not very brand friendly. The goal of this article is to show you how to go from this generic IBM theme …. To the customized portal screen below… As you can…
![](https://quebit.com/askquebit/wp-content/uploads/2018/09/DD1-min-1024x497.jpg)
Drill Through from a Dashboard! Cognos Analytics 11.0.10+
You’re kidding, I can now drill through to a report from a dashboard! One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report. Well, it can now be done. It is an easy task to author a drill-through that…
![](https://quebit.com/askquebit/wp-content/uploads/2018/08/Dash1-min-1024x497.jpg)
Interactive Dashboards in Cognos Analytics 11.0.0+
Let’s add additional visualizations and create an interactive workspace. In my last knowledge base article, “Creating a Simple Dashboard in Cognos Analytics 11.0.0+”, I covered how to easily create a single visualization depicting a key performance indicator (KPI). Taking this a step further, this article will show you how to add multiple visualizations to create…
![](https://quebit.com/askquebit/wp-content/uploads/2018/08/SDB1-min-1024x499.jpg)
Creating a Simple Dashboard in Cognos Analytics 11.0.0+
Let’s get started with Dashboard basics… It’s easy! Business Case: The City of Boston currently utilizes a “311 System”, which enables city residents or city workers to easily report non-emergency issues. Items such as broken streetlights or graffiti can be reported to the proper city services department via mobile phone applications, online, social media or…
![](https://quebit.com/askquebit/wp-content/uploads/2018/07/link2Welcome1-min.jpg)
Linking a website URL to my Cognos Analytics 11.0.4+ Welcome Page
Wow, now I can add a URL link to my Cognos Analytics (CA) Welcome Page! Business Case: In an earlier QueBIT Knowledge Base article, “Setting a Default Welcome Page in Cognos Analytics 11.0.4+”, you learned how to set up a custom welcome page in CA. In this article, we are going to add a URL…
![](https://quebit.com/askquebit/wp-content/plugins/bbpowerpack/modules/pp-content-grid/images/placeholder.jpg)
IBM Cognos Analytics Story Templates
The new IBM Cognos Analytics Story templates allow business analytics professionals to tell their businesses’ stories by combining Cognos data with pictures, video, charts, graphs, and prompts in a slide based, guided experience that dynamically, intuitively and automatically leads an audience through a tailored presentation.
Planning Analytics
![](https://quebit.com/askquebit/wp-content/plugins/bbpowerpack/modules/pp-content-grid/images/placeholder.jpg)
Planning Analytics and Transaction Log Management
Planning Analytics and Transaction Log Management If you are responsible for administrating IBM Planning Analytics, then the transaction log most likely has been queried regularly in an attempt to identify data changes (for example date and time of a change and name of the client that made the change) and – most Likely – the…
![](https://quebit.com/askquebit/wp-content/uploads/2021/05/fix1-min.jpg)
Demystifying the PA / PAfE / PAW / PASSL Install Files from IBM Fix Central
Finding the correct Planning Analytics download files from IBM Fix Central can be a confusing task. This guide will walk you through the steps necessary to identify the Planning Analytics [PA], Planning Analytics for Excel [PAfE], Planning Analytics Workspace [PAW], and Planning Analytics Spreadsheet Services [PASSL] files that you need for your system. 1 –…
![](https://quebit.com/askquebit/wp-content/uploads/2021/02/AW1-min-300x144.jpg)
A Database Administrator Approach to Building Cubes in IBM Planning Analytics Workspace
If you are more of a code-junkie at heart like me, or perhaps have come from a relational database background, you may want to think about the following concept. By now, you most likely understand how to build cubes using Planning Analytics Workspace (PAW). If not, you can have a look here. Similar to TM1…
![](https://quebit.com/askquebit/wp-content/uploads/2021/01/B1-min.jpg)
IBM Planning Analytics and PGP
Pretty Good Privacy (PGP) is an encryption program that provides cryptographic privacy and authentication for data communications. PGP is used for signing, encrypting, and decrypting texts, e-mails, files, directories, and whole disk partitions and to increase the security of e-mail communications. When you send a message using PGP, the message is converted into unreadable ciphertext on your device before it passes over the Internet. Only the recipient…
![](https://quebit.com/askquebit/wp-content/uploads/2021/01/p1-min.jpg)
Loading Data into a Cube using IBM Planning Analytics Workspace
IBM Planning Analytics stores data that you need for your planning, analysis, and other reporting in multidimensional cubes. Each cube typically has a specific purpose. A cube must have at least two dimensions. The number of dimensions that there are in a cube depends on the purpose of the cube. Loading a Cube Once you…
![](https://quebit.com/askquebit/wp-content/uploads/2021/01/data1-min.jpg)
Using Conditional Formatting & Calculations with IBM Planning Analytics Workspace
IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Planning Analytics. It delivers an interface to the data in planning analytics (TM1), providing ways to plan, create, and analyze your content by providing features such as conditional formatting and calculations. Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that…
![](https://quebit.com/askquebit/wp-content/uploads/2020/12/CO1-min.jpg)
IBM Planning Analytics: Control Objects – what are they and how to view them
Control objects are system-generated objects in Planning Analytics that can help perform tasks such as administer security, record attributes, and record performance statistics (if performance monitor is on). These will include cubes, processes, and dimensions that are all prefixed with the symbol }. Types of Control Objects Security Control Cubes There are several security control…
![](https://quebit.com/askquebit/wp-content/uploads/2020/10/U1-min-1024x413.jpg)
Using Multiple Architect Sessions for Development and Testing
Did you know that the Planning Analytics Architect desktop client allows for multiple instances to run simultaneously? This feature can be used to greatly improve efficiency during development, testing, and even day to day use. When to use multiple architect sessions? Long running processes can lock an Architect or Perspectives session until the process finishes.…
![](https://quebit.com/askquebit/wp-content/uploads/2020/05/PA1-min-1024x220.jpg)
Planning Analytics Workspace Security
Security for Planning Analytics Workspace (PAW) consists of three main parts: users, groups, and roles. It is important to realize that these three objects are PAW specific and just give access to PAW objects (books/views/dimension editors etc.) and these users will need to be set up in the Planning Analytics (PA or TM1) side first…
![](https://quebit.com/askquebit/wp-content/uploads/2020/09/one-min.jpg)
Data Spreading Shortcuts in IBM Planning Analytics Workspace
What do we typically mean when we say, “data spread”? Well, perhaps the simplest way to understand this concept is by thinking of it as the act of “applying data across a range” – say a period of time. Perhaps you expect expenses to total a certain amount for the year, but you need to…
![](https://quebit.com/askquebit/wp-content/uploads/2022/10/FLAT1-min.jpg)
Using a SharePoint site for IBM Planning Analytics flat file data sources
Technology executives and managers are always looking for ways to be more effective while at the same time reducing costs in maintenance hours, physical servers, processes, etc.— It’s always a balancing act. One way to accomplish both goals can be by leveraging existing technology investments that are tried and true. Microsoft’s SharePoint and OneDrive is…
![](https://quebit.com/askquebit/wp-content/uploads/2022/10/DB1-min.jpg)
Dashboards at a Glance in Planning Analytics Workspace
Much of analytics is trying to decrease the amount of time and effort for converting data into valuable insights. Planning Analytics is a tool that does this very well. Since you’re reading this post, you are probably already familiar with Planning Analytics and web and reporting environment called Planning Analytics Workspace (PAW). PAW is great…
![](https://quebit.com/askquebit/wp-content/uploads/2022/09/CL1-min.jpg)
Uploading data files to IBM Planning Analytics (Cloud)
Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file…
![](https://quebit.com/askquebit/wp-content/plugins/bbpowerpack/modules/pp-content-grid/images/placeholder.jpg)
Diagnosing PAfE Performance Issues
IBM Planning Analytics for Microsoft Excel – or PAfE (previously referred to as PAX) – is a Microsoft Excel-based tool that report authors use to build sophisticated, multiple-sheet, multiple-query reports against multiple databases, including Planning Analytics models. If you are a PAfE user, or support a group of PAfE users, you may eventually need to…
![](https://quebit.com/askquebit/wp-content/uploads/2022/09/P1-min.jpg)
Troubleshooting PAW Security
PAW (Planning Analytics Workspace) has four types of security: User Role, User Group, Folder Security, and Book Security. These security types are separated from the database security, such as cube security, element security and process security. A PAW administrator usually helps a user fix security issue in PAW. This article covers the common security issues…
![](https://quebit.com/askquebit/wp-content/uploads/2022/08/SF1-min-1.jpg)
Integrating Snowflake and IBM Planning Analytics
In another post I explored how easy it is to access cloud-based Snowflake, create a database, define and then load a table with data from a local file. In this post, I investigate the steps required to integrate some Snowflake data with IBM Planning Analytics (TM1). The steps will include: Configure an ODBC Data source…
![](https://quebit.com/askquebit/wp-content/uploads/2021/08/Pic1A-min.jpg)
Using Hash Values in Planning Analytics
When working with IBM Planning Analytics, it is not uncommon to source data from a relational data source. Typically, you will see a Data Warehouse or Data Lake where data is transformed and loaded on a schedule using an ETL tool. ETL, which stands for Extract, Transform and Load, extracts data from a source, modifies it in some…
![](https://quebit.com/askquebit/wp-content/uploads/2021/05/short1-min.jpg)
How to shorten the data-processing time using the RunProcess command
We process more and more data every day. Some processing tasks take a few minutes while others take more than a few hours. The length of processing time depends on the amount of data, the speed of hardware, and how we process data. The first two factors are usually fixed for a given scenario so…
![](https://quebit.com/askquebit/wp-content/uploads/2021/08/Feeder12-min.jpg)
IBM Planning Analytics – Create More Efficient Feeders with Conditional Feeders
One of IBM Planning Analytics (PA) biggest advantages over other applications is the ability to use feeders. When it comes to issues of sparsity within cubes, feeders improve performance by giving developers a way to prevent Planning Analytics from trying to look through millions of intersections to find all the data to consolidate. Essentially, feeders…
![](https://quebit.com/askquebit/wp-content/uploads/2021/08/ch1-min.jpg)
Using the SQL Server OFFSET-FETCH feature in IBM Planning Analytics
The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to skip before specifying how many rows you want to return in a SQL query. This can come in handy in a variety of ways such as returning results to the user one “slice” at a time…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/MAN1-min-1.jpg)
IBM Planning Analytics – Advanced Attribute Manipulation Part 1
As IBM Planning Analytics (PA/TM1) developers we often find ourselves in need to manipulate attributes in a dimension. This manipulation may be with the purpose of creating said attribute or populating it with data. We assume here the manipulation will be done via the Turbo Integrator (TI) tool. So, any manual interaction with attributes is…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/M1-min.jpg)
IBM Planning Analytics – Advanced Attribute Manipulation Part 2
This article is the second part of a 3-part series exploring attribute manipulations with Turbo Integrator (TI) processes. In Part 1 of the series, which can be found here, we saw how to check if an attribute exists and insert it and then how to check its type. We will now continue with a more…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/TRAP1-min.jpg)
IBM Planning Analytics – Advanced Attribute Manipulation Part 3
This article is Part 3 of a series called Advanced Attribute Manipulation. You can find Part 1 which describes a few functions used to check if attributes exists and how to check their type HERE. And Part 2 about useful functions that looping through an attribute dimension and perform tasks with a subset HERE. Our…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/RANK1-min.jpg)
Dynamic Ranking in IBM Planning Analytics Workspace
Ranking reports are simple, yet powerful end-user reporting tools. Providing the ability for a user to add a ranking to a report or view of data based upon criteria that they are specifically interested in without having to have a developer or application administrator involved can be invaluable. IBM Planning Analytics Workspace users can enhance their…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/pick1-min.jpg)
Understanding Picklists in IBM Planning Analytics
Picklists are not a new concept. They exist in many applications, including Web pages. Perhaps you know them as “selection lists” or “drop down lists”. As a refresher, a picklist is a list of valid values for a specific element or cube cell. When you define a picklist for an element or a cell, a…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/def1-min.jpg)
Using Default Views in IBM Planning Analytics
IBM defines a cube as “…the basic container for data…” and a cube view as “…the definition of how a cube’s dimensions are arranged…”. Planning Analytics cubes can each have multiple views defined and typically, each cube will have specific views designed to assist with common reporting needs. Common Views In addition to defining various…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/WB1-min.jpg)
Using the Modeling Workbench in Planning Analytics
The modeling workbench was introduced in IBM Planning Analytics and remains available as a beta feature (in 2.0.65). You can now open the modeling workbench from the Planning Analytics Workspace environment (in earlier versions entry was through a separate URL). You can use the workbench to do almost anything you need to do within a…
![](https://quebit.com/askquebit/wp-content/uploads/2022/06/TH1-min.jpg)
Using Custom Themes in IBM Planning Analytics Workspace
Did you know that you can override the standard Planning Analytics Workspace (PAW) theme with your own “custom theme” that reflects your corporate branding or culture? You can use a custom theme to: Modify the colors of the application bar Modify the colors of the navigation bar Set the corporate title that is shown on the home…
![](https://quebit.com/askquebit/wp-content/plugins/bbpowerpack/modules/pp-content-grid/images/placeholder.jpg)
Connecting Snowflake to IBM Planning Analytics (Cloud)
Snowflake is a data warehouse, and it has gained a lot of popularity in recent years. Organizations choose to store and process their data in Snowflake which is a great data platform. Most organizations also need an analytics platform to build their forecast, perform ad-hoc analysis, and create dashboards. IBM Planning Analytics (Cloud) is an…
![](https://quebit.com/askquebit/wp-content/uploads/2021/05/MDX1-min.jpg)
How to use one Title Dimension Selection to Control Another Dimension’s Subset in a PAW Cube View
A useful feature of building a cube view in Planning Analytics Workspace is the availability of using MDX to control dimension element selections. This functionality can be leveraged to use the selection made in one title element drive what element a separate dimension uses. In this article I have two examples. The first is using…
![](https://quebit.com/askquebit/wp-content/uploads/2020/10/P1-min-1024x184.jpg)
How to Add and Configure an Action Button
Adding an Action Button To add an action button, click on the cell where you want the button to be placed, then go to the TM1 ribbon, and click “Action Button” A button is created, and the action button properties window will open. Here you can define the button’s action properties. Action Button Actions: An…
![](https://quebit.com/askquebit/wp-content/uploads/2020/07/level1-min.jpg)
Creating Level-Based Row Indentation for Planning Analytics for Excel (PAfE) Reports
Level-based row indentation is a great way to add quick readability to your Planning Analytics for Excel (PAfE) reports. Instead of having a list of elements all left-aligned, we can add indentation based upon each member’s level to help report readers understand hierarchies within the dimension. Exploration Views, Quick Reports and Dynamic Reports all have…
![](https://quebit.com/askquebit/wp-content/uploads/2020/04/SU1-min-1024x222.jpg)
IBM Planning Analytics – Report Building Tips
What’s in a SUBNM? If you’re learning to build Excel based reports in IBM Planning Analytics, it’s important to understand the core FUNCTIONS and features that drive the report. Several of these functions can be customized to provide flexibility in both format and content. (i.e. TM1RPTVIEW, TM1RPTROW, SUBNM, MDX) Today, we will focus on the…
![](https://quebit.com/askquebit/wp-content/uploads/2019/02/1-min.jpg)
Dynamic 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…
![](https://quebit.com/askquebit/wp-content/uploads/2019/02/AutomatePA1-min-1024x429.jpg)
Automating 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…
![](https://quebit.com/askquebit/wp-content/uploads/2019/01/TDP.gif)
Quick 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…
![](https://quebit.com/askquebit/wp-content/uploads/2018/10/Pax1-min.jpg)
How Can I create an Exploration view in Planning Analytics for Excel (PAx)?
How Can I create an Exploration view in PAx (IBM Planning Analytics)? An Exploration View shows data in rows and columns. An Exploration View also has a context area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon: …
![](https://quebit.com/askquebit/wp-content/uploads/2018/10/Pax1-min-1.jpg)
How can I create a Quick Report in Planning Analytics for Excel?
A Quick Report shows data in rows and columns. A context area above the Quick Report shows the context members. You can create a Quick Report from an IBM Cognos TM1 Exploration View after you finish your analysis and want to present data by using more advanced cell-based features from Microsoft Excel. When you convert…
![](https://quebit.com/askquebit/wp-content/uploads/2018/10/1-min-1.jpg)
How do I create a List in Planning Analytics for Excel (PAx)?
When you create a list in PAx (Planning Analytics for Excel), you begin with a blank list and then drag items from the Task Pane onto the list. To create a list: 1. On the IBM Planning Analytics tab, click List. This will add the list object to your active worksheet. …
![Picture1 Picture1](https://quebit.com/askquebit/wp-content/uploads/2024/08/Picture1-1.png)
Planning Analytics for Microsoft Excel API for Macro Automation
Planning Analytics for Microsoft Excel API for Macro Automation It’s not uncommon to move an MS Excel workbook from Perspectives to Planning Analytics for Excel (PAfE) and find that there are buttons within the workbook that run macro(s) to perform automation tasks. If there are, you may encounter the following (or similar) error: “Cannot run…
![Picture1 Picture1](https://quebit.com/askquebit/wp-content/uploads/2024/08/Picture1.png)
Common PAW Administrator Tasks
Commom PAW Administrator Tasks Administering IBM Planning Analytics Workspace includes managing users, administering the database, migrating assets, as well as other “administrative type ”actions. You access the Administration page from the Administration tile on the Planning Analytics Workspace home page (shown below). If you are not an administrator, you cannot see the Administration tile on the Planning Analytics Workspace home page. Administration tile on the Planning Analytics…
![Picture1 Picture1](https://quebit.com/askquebit/wp-content/uploads/2024/06/Picture1-1.png)
Data Modeler or Data Analyst
Data Modeler or Data Analyst The act of data modeling can be challenging for a variety of reasons. Rapidly Evolving Business Needs – it is an uncommon thing today for a business to have a firm grasp on all its needs and if it does, rapid growth (or contraction) of the business can quickly change…
![Picture13 Picture13](https://quebit.com/askquebit/wp-content/uploads/2024/03/Picture13.png)
IBM Planning Analytics Process Synchronization
IBM Planning Analytics Process Synchronization Synchronization in Planning Analytics counter-intuitively does not ensure that TI processes run at the same time, in synchronization. Instead, it ensures that only one process with a given synchronized flag is allowed to run at a time. The main use cases for “synchronizing” processes in Planning Analytics by using the…
![good_model good_model](https://quebit.com/askquebit/wp-content/uploads/2024/03/good_model.bmp)
Characteristics of a “Good” Data Model in IBM Planning Analytics
IBM Planning Analytics – Characteristics of a “Good” data model Modeling Many “strategies” exist today for modelling (building a database) in IBM Planning Analytics. If you are a member of the IBM Community, you’ll find no shortage of opinions and recommendations – from informal blogs and discussions to more formalized courses and mentoring. In fact,…
![Picture2 Picture2](https://quebit.com/askquebit/wp-content/uploads/2024/02/Picture2.png)
PAfE Reporting Hints
IBM Planning Analytics for Microsoft Excel (or “PAfE”) is a Microsoft Excel-based tool that can be used to build complex, multiple-worksheet, multiple-query reports against multiple databases. You can use the information here as a quick start guide (and then a reference) providing helpful suggestions on using PAfE. If you haven’t yet installed PAfE and need help…
![](https://quebit.com/askquebit/wp-content/uploads/2023/06/Picture2-300x38.png)
KB – TI Process Debugger
Planning Analytics Workspace TurboIntegrator Process Debugger The highly anticipated TurboIntegrator (TI) Process Debugger is now available in Planning Analytics Workspace. This valuable functionality is included in the 2.0.84 release update, opening new possibilities for developers to investigate, diagnose, and resolve issues within their TurboIntegrator processes. In this article, we will dive into the core functionality…
![Featured Featured](https://quebit.com/askquebit/wp-content/uploads/2023/05/Featured-1024x768.jpg)
Leveraging Existing Planning Analytics Assets
At some point you may have developed and delivered some sort of financial model in TM1/Planning Analytics – perhaps starting with the reporting of financials – and have now been tasked to “add” planning and budgeting (or other) functionality to it. Before you even begin gathering requirements for the new functionality, it is recommended that…
![Featured Featured](https://quebit.com/askquebit/wp-content/uploads/2023/05/Featured-1024x768.jpg)
Building a Planning Analytics “Information Front Porch”
Building a Planning Analytics “Information Front Porch” Exchanging Information Most enterprise PLANNING ANLAYTICS applications will have bidirectional exchanges of information with external systems and sources. With PLANNING ANLAYTICS’s TurboIntegrator, you can consume files of data and even connect directly to (supported) data sources to load information directly into PLANNING ANLAYTICS objects at scheduled…
![](https://quebit.com/askquebit/wp-content/uploads/2023/01/Picture1-221x300.png)
5 Powerful MDX Functions to use in your IBM Planning Analytics Model
IBM Planning Analytics (PA) subsets can be made dynamic through multi-dimensional expressions (MDX). This reduces manual maintenance and ensures that subsets display the latest metadata and data available in the model. For example, when the Current Year of a model is modified, an MDX driven “Current Year Months” subset will be updated immediately. Today we…
![](https://quebit.com/askquebit/wp-content/plugins/bbpowerpack/modules/pp-content-grid/images/placeholder.jpg)
Planning Analytics Changes to MDX Subset Evaluation in 2.0.9
Planning Analytics Changes to MDX Subset Evaluation in 2.0.9 July 2020 UPDATE: IBM has reverted the change described in this article in release 2.0.9.2 of Planning Analytics (PA), which is now available to Local and IBM Cloud customers. Additional background and information about this issue, and the fix by IBM, can be found in this…
![](https://quebit.com/askquebit/wp-content/uploads/2019/08/PAX1j-min.jpg)
Dynamic Planning Analytics Server Names in PAX
The main difficultly when migrating a Planning Analytics for Excel (PAX) report or input template from one Planning Analytics (PA)/TM1 Server to another is making sure it will work across both servers. Every PAX function, like a DBRW or SUBNM, requires the cube name or dimension name be prefixed with the Server name that is…
![](https://quebit.com/askquebit/wp-content/uploads/2018/11/options.png)
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…
![](https://quebit.com/askquebit/wp-content/uploads/2023/04/Picture1-1-300x267.png)
TM1 SSL Certificates Fix
TM1 SSL Certificates Fix Issue: Can’t see any TM1 Servers in Server Explorer Resolution: Check to make sure the SSL Certificates have been updated Affects: TM1 versions prior to Planning Analytics, If client installs TM1 on a new server or client machine This blog entry is an update to our blog posted on Sept 27,…
![](https://quebit.com/askquebit/wp-content/uploads/2018/04/TM1-Server-wont-start-a-min.jpg)
TM1 Server won’t start
TM1 Server won’t start Issue: tm1s.log file may become corrupt Resolution: Rename existing tm1s.log and restart TM1 server. TM1 will create a new tm1s.log file. Tm1server.log file is located in the Logs folder. This will most likely be in the same location as your Data and Config folders. Rename tm1server.log to tm1serverold.log Restart TM1 server…
![loading loading](https://quebit.com/askquebit/wp-content/uploads/2024/02/loading.bmp)
Selecting, Copying and Loading Performance in IBM Planning Analytics
IBM Planning Analytics – Selecting, Copying and Loading Performance Selecting, Copying and Loading Moving data into, around, and “out of” a Planning Analytics model are examples of common operations and constitute essential practices. Loading usually involves executing database commands to select information from external data sources, perhaps from a transactional general ledger system or from…
![IBMID1 IBMID1](https://quebit.com/askquebit/wp-content/uploads/2023/11/IBMID1.png)
Do I Need an IBM ID?
Do I Need an IBM ID? If you are responsible for supporting IBM Planning Analytics (PA), are the “newly appointed” PA or Planning Analytics Workspace (PAW) administrator for your organization or simply a Planning Analytics “consumer”, at some point you will want to “interact” with IBM in respect to potential new offerings, version availability, downloads,…
![](https://quebit.com/askquebit/wp-content/uploads/2021/05/spark1-min.jpg)
Sparklines in Planning Analytics (without Excel)
A sparkline is a tiny chart that provides a visual representation of data. You can use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Sparklines are typically positioned near its data for greatest impact. Google search and you’ll most…
![](https://quebit.com/askquebit/wp-content/uploads/2020/03/Picklist-blog1-min.png)
How to Create TM1/IBM Planning Analytics Picklists with Dimension Attributes or with Rules
Picklists are a beloved feature in TM1/Planning Analytics (PA) as it helps prevent user input errors, by limiting the values that can be typed into a cell. How to Create a Picklist in TM1/PA using Attributes: Create an attribute off any given dimension and name it “Picklist.” Write the element attribute names. In this example,…
![](https://quebit.com/askquebit/wp-content/uploads/2018/11/PAW-Consistency_11.5.2018.gif)
Creating Professional PAW Dashboards
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…
![](https://quebit.com/askquebit/wp-content/uploads/2019/01/snap-command.jpg)
Use 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…
![](https://quebit.com/askquebit/wp-content/uploads/2018/10/PopUp-Text.gif)
Using Pop-Up Text in PAW
Using Pop-Up Text in PAW Space can sometimes be at a premium in Planning Analytics Workspace (PAW) dashboards and reports and using Pop-Up Text is a great way to preserve valuable real estate while still being able to provide users with any additional information or instructions needed to make your user interface as intuitive and…
Learn How Planning Analytics Improves Business Decision Making
Find out how data and planning analytics can transform the way your company makes crucial decision by reading our eBook 4 steps to better decision making and requesting a meeting with a Planning Analytics expert.
![QueBIT_healthcheck QueBIT_healthcheck](https://quebit.com/askquebit/wp-content/uploads/2023/05/QueBIT_healthcheck.png)
SPSS
![](https://quebit.com/askquebit/wp-content/uploads/2020/07/SPSSStream.jpg)
SPSS Modeler: Advanced Stream Automation
If you’re just starting scripting in modeler, please read the Basic Stream Automation article before this one! In this article, we’ll talk through three more advanced topics including: Setting properties of nodes Looping through nodes to set connection properties on multiple nodes at once These are extremely common use cases that can be combined to…
![](https://quebit.com/askquebit/wp-content/uploads/2020/07/SPSS1.jpg)
SPSS Modeler: Managing Streams using Collaboration and Deployment Services (C&DS)
IBM SPSS Collaboration and Deployment services, or C&DS, is a tool for managing SPSS content. This includes version control and job creation/stream automation. In this article, we’ll go through the SPSS Modeler interface for interacting with C&DS – storing streams, retrieving streams, and managing version control. Connecting to the C&DS Repository To connect to the…
![](https://quebit.com/askquebit/wp-content/uploads/2020/07/Basic1-min.jpg)
SPSS Modeler: Basic Stream Automation
Scripting in Modeler is an extremely powerful way to automate processes and execution of streams. Just about any action that you can perform manually can be automated using the Jython scripting API. This is convenient if you’re running the stream from within Modeler client, and extremely important if you’re running the stream outside of Modeler…