Aramar
  • About Us
  • Our Team
  • Join the Team
  • News & Events
  • Contact
  • IBM Business Analytics
    • IBM Business Analytics Software.

      • IBM Planning Analytics
      • IBM Controller
      • IBM Cognos Analytics
      • Fast Financials
      • Lease16
      • Supporting Software
      • IBM Planning Analytics.

        IBM Planning Analytics is business performance management software that combines budgeting and AI-enhanced forecasting with intuitive analysis, reporting and workflows.

      • IBM Controller

        IBM Controller delivers accurate, fully auditable financial results, a guided period close user experience, and automatic consolidation and reporting.

      • IBM Cognos Analytics

        IBM Cognos Analytics is infused with AI and offers an intuitive and user-friendly experience.

      • Fast Financials

        IBM Planning Analytics models are traditionally built from scratch but with Fast Financials we have created a solution that offers a different approach.

      • Lease16

        Lease16 is our off-the-shelf accounting IFRS 16 Lease management software solution which allows Organisations to easily manage leasing obligations in full compliance with the IFRS 16 Lease accounting standards.

      • Supporting Software.

        The team at Aramar have been working with Cognos products for many years and have a wealth of experience in implementing, developing and supporting Cognos products.

    • IBM Planning Analytics
    • IBM Controller
    • IBM Cognos Analytics
    • Fast Financials
    • Lease-16
    • Supporting Software
  • IBM watsonx
    • IBM watsonx.

      • watsonx.ai
      • watsonx.data
      • watsonx.governance
      • watsonx Assistant
      • watsonx Orchestrate
      • watsonx.ai

        Train, validate, tune and deploy AI models

      • watsonx.data

        Scale AI workloads, for all your data, anywhere

      • watsonx.governance

        Enable responsible, transparent and explainable data and AI workflows

      • watsonx Assistant

        Conversational AI for fast and friendly interaction

      • watsonx Orchestrate

        Get more time back for things that matter

    • watsonx Orchestrate
    • watsonx.governance
    • watsonx.ai
    • watsonx.data
    • watsonx Assistant
  • IBM Envizi
    • IBM Envizi.

      • IBM Envizi
      • IBM Envizi

        Fully managed platform that simplifies the collection, consolidation, management, reporting and analysis of diverse ESG data sources.

    • IBM Envizi
  • Customer Success
    • Customer Success.

      • Customer Success Programme
      • Customer Stories
      • Customer Success Programme

        All our customers join our success program.

      • Customer Stories

        Don’t just take our word for it…

    • Customer Success Programme
    • Customer Success
  • Services
    • Services.

      • Implementation and Development
      • Cloud Migration
      • Support
      • IBM Licensing
      • Knowledge Centre
      • Implementation and Development

        From practical, hands-on development through to strategic guidance, our team of specialists is here to help.

      • Cloud Migration

        We have unrivalled experience in helping customers migrate their Business Analytics installations to the Cloud and helping them to take advantage of all IBM SaaS has to offer.

      • Support

        We are proud of our dedicated, friendly support desk, providing IBM Certified support and application support.

      • IBM Licensing

        As an Gold IBM partner, Aramar are able to negotiate the best terms with IBM on software licences and can provide wrap-around support to help you get the best from the products you have purchased.

      • Knowledge Centre

        Got a question? Explore the articles in our Knowledge Centre and find the answers that you are looking for.

    • Implementation and Development
    • IBM Cloud Migrations
    • Support
    • IBM Licensing
    • Knowledge Centre
  • Solutions
    • Solutions.

      • Financial Planning and Analysis
      • Financial Reporting
      • Lease Accounting
      • Strategic Workforce Planning
      • Supply Chain Planning
      • Marketing Planning
      • Group Financial Consolidation
      • Financial Planning and Analysis

        Planning Analytics addresses all the traditional problems inherent in spreadsheet models such as the lack of scalability, model fragility, and formulae errors.

      • Financial Reporting

        Reporting can cover Profit & Loss, Balance Sheet, Cashflow, sales analysis, working capital, capital expenditure.

      • Lease Accounting

        Lease16 is our off-the-shelf accounting IFRS 16 Lease management software solution which allows Organisations to easily manage leasing obligations in full compliance with the IFRS 16 Lease accounting standards.

      • Strategic Workforce Planning

        Workforce, headcount and salary planning models built with IBM Planning Analytics are able to meet the needs of both Operations, who are focused on the resources needed to achieve targets, and of Human Resources, who need to balance the demand for resourcing at the corporate level.

      • Supply Chain Planning

        IBM Planning Analytics helps organisations to optimise their supply chain by presenting a single source of truth, unified across inventory management, demand planning, marketing, sales, operations, and logistics.

      • Marketing Planning

        Organisations that use IBM Planning Analytics as the central platform for their marketing plans are able to integrate all their disparate data into a single source of the truth to create a comprehensive view of marketing spend, targets and plans across the organisation.

      • Group Financial Consolidation

        IBM Controller is globally proven across all industries and enterprise sizes to overcome the technical challenges of transforming disparate data into uniform and coherent information needed to produce consolidated financial statements.

    • Financial Planning and Analysis Use Case
    • Financial Reporting Used Cases
    • Lease Accounting
    • Workforce Planning Use Case
    • Supply Chain Planning Use Case
    • Marketing Planning Use Case
    • Group Financial Consolidation
    • Business Intelligence
  • About Us
  • Our Team
  • Join the Team
  • News & Events
  • Contact

Knowledge Centre

IBM Planning Analytics

  • How to: Change the display row limit in Planning Analytics for Excel
  • How to: Mapping a CSV data source directory in IBM Planning Analytics on Cloud
  • How to: Checking whether a Dimension exists in Planning Analytics
  • How to: Change maximum login attempts to Planning Analytics on Cloud
  • How to: Mapping a Network Drive between Live and Development Environments in Planning Analytics on Cloud
  • Aramar Tips: Moving Databases in Planning Analytics
  • How to: Change a Dimension Element Weight in Planning Analytics via TI process
  • How to: Using the While statement Turbo Integrator Process in IBM Planning Analytics
  • How To: Investigating issues using the TM1 Server Log
  • How to: Create Subsets driven by another Dimension in Planning Analytics
  • Aramar Tips: Creating documentation IBM Planning Analytics
  • Aramar Tips: Checking your parameters with a Planning Analytics TI Process
  • Aramar Tips: Using PowerShell in Planning Analytics
  • Fundamentals: Feeders in IBM Planning Analytics
  • Fundamentals: Cube Viewer in Planning Analytics for Excel
  • Fundamentals: DBRW in Planning Analytics
  • Aramar Tips: Analysing Data in IBM Planning Analytics for Excel
  • How to: Create a Dimension in IBM Planning Analytics
  • Fundamentals: What are Dimensions in IBM Planning Analytics?
  • How to: Edit Dimensions in IBM Planning Analytics
  • How to: Create a Cube in IBM Planning Analytics
  • How to: Add a new Element to an existing Dimension in IBM Planning Analytics
  • How To: Resolve ODBC error ‘unable to open connection to database’ in IBM Planning Analytics 
  • Aramar Tips: Working with Subsets in IBM Planning Analytics
  • How to: Check the Security of a Dimension in IBM Planning Analytics
  • How To: Check the version of IBM Planning Analytics for Excel
  • How to: Check and manage your IBM Planning Analytics licence usage vs. your licence entitlement
  • How To: Set up Inactivity Timeout Sessions in IBM Planning Analytics
  • How To: Install Planning Analytics for Excel (PAfE)
  • How to: Find out your Planning Analytics Version using Remote Desktop (Planning Analytics on Cloud)
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller
  • How To: Find out your Planning Analytics Version using Workbench (Planning Analytics on Cloud)
  • How To: Create a simple hierarchy in Planning Analytics

IBM Cognos Analytics

  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller

IBM Cognos Controller

  • How to: Change the reporting currency belonging to a local subsidiary (or reporting entity) in IBM Cognos Controller
  • How to: Change the reporting currency belonging to the group consolidation in IBM Cognos Controller
  • How to: Effectively structure user security in IBM Cognos Controller
  • How to: Run an internal database optimise in IBM Cognos Controller
  • How to: Schedule an internal optimise in IBM Cognos Controller
  • How to: Check currency translation using a standard report in IBM Cognos Controller
  • How to: Audit the Licenced Number of Controller Users
  • How to: Improve your Controller Excel Report Performance
  • How to: When Does the FAP Publish Client from Controller Need Updating?
  • How to: Drill Data within Cognos Controller
  • How To: Change the method of translation applied to the P&L statement, or create different P&L translation views from the same source data in IBM Cognos Controller
  • Aramar Tips: The Benefits of Using IBM Cognos Controller Web for Data Import via Import Specifications
  • How to: Check when a Company was last updated (and by who) from within IBM Cognos Controller Web
  • How to: Reconcile Data by Company in IBM Controller Web
  • How to: Consolidating a Submission in IBM Cognos Controller Web
  • How To: Fix the Intercompany button not appearing in IBM Cognos Controller
  • How To: Interrogate the backend SQL table using IBM Cognos Controller
  • How To: Log into Citrix for the first time using IBM Cognos Controller on Cloud
  • How to: Check the size of your IBM Cognos Controller database
  • How to: Clear the local cache within Cognos Controller
  • Fundamentals: What are the differences between IBM Controller Web and IBM Controller Classic?
  • How to: Navigate the Backend SQL tables within IBM Controller
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller

General

  • Aramar Tips: 5 Easy tips to consider when adding commentary to your financial reports 
  • How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller
View Categories
  • Home
  • knowledge-share
  • IBM Planning Analytics
  • How To: Install Planning Analytics for Excel (PAfE)

How To: Install Planning Analytics for Excel (PAfE)

4 min read

IBM Planning Analytics for Excel (PafE) is an Excel add-in that enables you to interact with data and perform powerful planning, budgeting, and forecasting activities using IBM Planning Analytics with Watson, a fast and flexible multidimensional functional database.

You can use IBM® Planning Analytics for Excel to access data from the TM1® Server on your IBM Planning Analytics system.

To use Planning Analytics for Excel with Planning Analytics, you first need to download, install, and configure the application.

Administrators can either download PAfE from Fix Central or from within their Planning Analytics environment. As the file is a .xll file, no typical installation is required.

You will need a copy of your Planning Analytics Welcome kit for the Excel URL but generally, it’s of this format:

https://<<your environment name>>. planning-analytics.cloud.ibm.com e.g. acme-inc.planning-analytics.com

Download via Planning Analytics #

  • Log into Planning Analytics as an Administrator. On the Planning Analytics WorkspaceHome page, click the Administration
  • On the Administration page, click Excel and Customizations.
  • Select the version of Planning Analytics for Microsoft Excelyou want to download. The three most recent versions are available for selection.
  • Click Download Update.

The installation is saved in your Downloads directory as a zip file, named Integration<version>.zip.

  • Extract the zip.

Once the zip file is extracted the resultant file will be named IBM PAfE_<version>.xll.

  • Rename the file by removing the version number at the end, this will make updating to newer versions easier in the future.

Uninstall the existing version #

If there is an existing version of PAfE installed on the machine with a version extension you may want to remove this first

  • Navigate to the location you saved the add-in to, typically: C:\Users\<username>\AppData\Roaming\Microsoft\AddIns
  • Delete the existing version, you may find that upon opening Excel, you may receive an error message displaying it cannot find the add-in.

Associate Excel with the PAfE Add-in #

  • Copy the file into your users ‘Addin’s’ folder, typically this would be like this: C:\Users\<username>\AppData\Roaming\Microsoft\AddIns
  • Open Excel and point to the location of the .xll file.
  • Select, File -> Options -> ‘Add-Ins’.

  • At the bottom of the ‘Add-Ins’ screen, confirm the ‘Manage’ drop down is showing ‘Excel Add-ins’, then click on the ‘Go’ button.

  • Click ‘Browse’, navigate to the saved .xll file.
  • Select the .xll file and click OK.

The .xll will now appear in the ‘Add-ins’ box as ‘IBM Planning Analytics for Excel Addin’:

  • Click on OK to confirm the Addin and close the dialogue box.

The IBM Planning Analytics tab will now be available within Excel on the ribbon bar when Excel is opened.

Set up a Connection to Planning Analytics #

  • Click on IBM Planning Analytics in the ribbon bar.
  • Click on Connect and from the resultant drop down, select ‘New Connection’:

A blank default Connection box will appear which will need to be populated with the Connection URL, this can be found under the heading, Planning Analytics for Microsoft Excel supplied in your Planning Analytics Welcome Kit.

  • Add in the Connection URL and a Friendly name and click on ‘Save’ when completed.

The new entry will now be available under the ‘Connect’ drop-down on the ‘IBM Planning Analytics’ tab.

  • To make a connection, click on the Friendly Name entered above.

You will be asked to log in using your IBMid, once completed, and depending on your environment, you will be presented with a choice of databases to connect with.

  • Select the database you wish to connect to, click on OK, and you will now be connected to your Planning Analytics environment.

Blank Task Pane window #

Some users may see a blank Task Pane window (as below), this may be due to an Incompatibility with Excel and the screen(s) being used

To resolve this, open Excel.

  • Under ‘File’ – > ‘Options’, in the ‘General’ tab select the ‘Optimise for compatibility’ radio button.
  • Close and restart Excel and the Task Pane Window will now show as populated.

You can find more information about PAfE in the IBM Documentation:

For Planning Analytics Local

For Planning Analytics on Cloud 

What are your Feelings
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on March 8, 2024
How to: Mapping a CSV data source directory in IBM Planning Analytics on Cloud

Powered by BetterDocs

Table of Contents
  • Download via Planning Analytics
  • Uninstall the existing version
  • Associate Excel with the PAfE Add-in
  • Set up a Connection to Planning Analytics
  • Blank Task Pane window

Our Accreditations and Partners

Aramar works with customers of all sizes, from a range of industries helping them with Business Analytics, Business Process, Sustainability and AI solutions using IBMs leading software solutions.

email contactus@aramar.co.uk

  • LinkedIn
  • YouTube

Registered Address:
124 City Road,
London,
EC1V 2NX

© Aramar 2025. All Rights Reserved.

Terms of use Privacy Policy

Website and Marketing by Unity Online