Aramar
  • About Aramar
    • Meet The Team
    • Our People
    • Working at Aramar
    • News, Blogs and Events
  • How can we help?
  • IBM Business Analytics
    • IBM Cognos Controller
    • IBM Planning Analytics with Watson
    • IBM Cognos Analytics with Watson
    • IBM Legacy Software Support
    • Supporting Software
  • Services
    • Product Specialists
    • IBM Analytics & Cognos Licencing
    • Planning Analytics Cloud Migrations
    • Training Courses
    • IFRS-16 Lease Management Software
    • Quick Guide to IFRS-16
  • Support
  • Fast Financials
  • Knowledge Share
  • Book A Demo
Get in touch

Aramar Knowledge Share Documentation

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

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 optimisation 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

General

  • Aramar Tips: 5 Easy tips to consider when adding commentary to your financial reports 
  • Home
  • knowledge-share
  • IBM Planning Analytics
  • How to: Change the display row limit in Planning Analytics for Excel

How to: Change the display row limit in Planning Analytics for Excel

If you have cube view that has a lot of rows, by default Planning Analytics for Excel will limit how many rows can be displayed in Exploration, Quick Reports, or List Views. If you open a cube view where the rows exceed the limit, you will see an error message.  

If you need to change the row limit, you can configure it by following the steps below:  

  • On the IBM Planning Analytics tab within Excel, click the Options icon.  
  • In the navigation pane, click IBM Planning Analytics.  
  • Locate the Data display row limit under Exploration or list settings.  
  • Use the field to define a number.  
  • Click OK.  

Your reports, lists and explorations will now be able to display more rows 

 

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

How can we help?

Updated on May 9, 2023
How to: Mapping a CSV data source directory in IBM Planning Analytics on Cloud

Powered by BetterDocs

Aramar

We deliver expert services, supply software licences on behalf of IBM and offer training and technical support across the complete IBM Business Analytics suite.

Contact us today

Useful Links

  • About Aramar
  • How can we help?
  • IBM Business Analytics
  • Services
  • Training Courses
  • Case Studies

Contact Us

0330 1242797
contactus@aramar.co.uk

Registered Address:

124 City Road,

London,

EC1V 2NX

Stay Connected

Keep up to date with industry insights and latest news

© Aramar 2023.

Terms of use Privacy Policy

Marketing by Unity Online