• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Analytics

Workday Adaptive Planning Tips & Tricks: Data Integration and the Planning Data Source

August 17, 2022 by Marc Assenza Leave a Comment

Did you know that Workday Adaptive Planning integrations can use the metadata in Adaptive Planning as a part of the integration?

It’s true! The process requires setting up the credential and setting up a data source for Adaptive Planning. You must have the proper credentials yourself within Adaptive Planning to set this up.

To set up the credential you will need to do the following:

From the Workday navigation button, go to Integration🡪Design Integrations

Graphical user interface, application

Description automatically generated

You will arrive at the following screen. Under the Component Library section click on the Credentials option.

Graphical user interface, text, application, Word

Description automatically generated

From the list that is presented, the first option is to Create a new Credential, select this.

Graphical user interface

Description automatically generated with medium confidence

Once clicked, the following list will be presented, select Planning Credential, and give it a name. Giving it a name that is meaningful matters, Adaptive certainly fits the bill here.

Graphical user interface, application

Description automatically generated

Once created, you will see that your credential exists under credentials in the Component Pane, but no access to the data source has been granted yet because no authorized user has been assigned. To assign an authorized user (a user with the rights to perform all these steps) to the credentials, you follow the on-screen instructions and click “Authorize” under the Actions panel.

Graphical user interface, application

Description automatically generated

When you click authorize, the following appears, enter the credentials in the pop-up screen and click “Authorize” on the lower right-hand portion of the screen.

Graphical user interface, text, application, email

Description automatically generated

Next you will want to click the Save button to save the login information with the credential.

Graphical user interface, application

Description automatically generated

The next step will be to Test the connection. This is done by clicking on “Test Connection” under the Actions pane. A pop-up window will display, click on “Test.” If the login credentials are valid, the following window will appear and the credential is all set up.

Graphical user interface, application

Description automatically generated

To set up the data source, you will need to do the following:

Under the Component Library, click on Data Sources.

Graphical user interface, text, application, Word

Description automatically generated

Click on the option “Create New Data Source.”

Graphical user interface, text, application, table, email

Description automatically generated

Here again select Planning Data Source and give it a meaningful name, keeping the name the same in this example and calling it Adaptive.

Graphical user interface, application

Description automatically generated

Once the Data Source is created, the following screen will appear. Here you will assign the Data Source the Credential that was created in step 1 and save it.

Graphical user interface, application, Teams

Description automatically generated
A picture containing Word

Description automatically generated

You will notice that no tables have appeared. That is because we have not defined them yet.

Graphical user interface, text, application, email

Description automatically generated

On the left-hand side under Actions, click on “Manage Sources.”

Graphical user interface, text, application, email

Description automatically generated

The following popup window will appear, click on the sources folder first, then click on the Add button.

Graphical user interface, text, application, email

Description automatically generated

You will now see a list; in the example we will import metadata about Accounts and Levels. Those two will be selected.

Graphical user interface, application

Description automatically generated

You have the option to rename the source, so Accounts and Levels will be used in place of the default name.

Graphical user interface, application

Description automatically generated
Graphical user interface, text, application

Description automatically generated

No tables are in the Data Source yet because the Data Source needs to be saved and the structure needs to be imported. Click the Save option first followed by “Import Structure.”

Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application

Description automatically generated

The table structures are now present as seen below.

Graphical user interface, text, application

Description automatically generated

The next step is to import the data, this is done by clicking “Import Data” under the Actions pane.

Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application

Description automatically generated

That’s all it takes to set up the credential and the Adaptive Data Source, now you’re ready to utilize it in the Staging area for integration however you see fit!

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Revenue Cohort Modeling

Workday Adaptive Planning Tips & Tricks: Check Boxes in Modeled Sheets

Workday Adaptive Planning Tips & Tricks: Show Actuals for Linked Accounts

Home » Analytics

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, Analytics, Financial Performance Management, Planning & Forecasting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: Change Element Type in PAW

December 22, 2020 by Thanh Chau Leave a Comment

Most users of IBM Planning Analytics Workspace (PAW) are familiar with the dashboarding and reporting capabilities for front-end users. However, IBM has built-in features that allow administrators to manage their models from PAW as well. Managing the dimension structure is one such feature. Though most of it is intuitive, updating the element type is a bit hidden.

To access the dimension editor, first open a workbook in PAW. Then in the left navigation pane, expand the “Dimensions” node to find the dimension that you would like to edit.

IBM Planning Analytics Tips & Tricks: Change Element in PAW

Drag the dimension to the work area pane on the right. You’ll see a warning stating that any changes will apply instantly unless you have reserved the dimension. Reserving the dimension locks the dimension so that no one else can make changes.

IBM Planning Analytics Tips: Change Element Type in PAW

In the PAW dimension editor, click on the paw iconicon to show the properties window. Select a member to show or change its properties. Please note that PAW doesn’t have “Consolidated” as a selectable type in the dropdown. PAW will automatically convert an element to a consolidation when you add children to it.  Conversely, it will change a consolidation to a simple element when you remove all children.

IBM Planning Analytics Tricks: Change Element Type in PAW

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

IBM Planning Analytics Tips & Tricks: Change Connection used by Quick Report

IBM Planning Analytics Tips & Tricks: Edit Action Button

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning Analytics tips, Planning Analytics Tips & Tricks, Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Log Lock Notification

December 8, 2020 by Lee Lazarow Leave a Comment

Have you ever tried to move or download log files and then realize that some of the files cannot be modified since they are in use? IBM Planning Analytics Workspace (PAW) recognizes this and now offers notifications to let you know which files are locked.

You can download log files by first selecting the PA Administration button at the top of your screen.

IBM Planning Analytics Tips & Tricks: Log Lock Notification

One inside the administration area, you can view the logs by clicking on the three dots at the top, right corner of your server and selecting the option called “Download logs.”

IBM Planning Analytics Tips: Log Lock Notification

From there, you can simply select the logs that you want to download and then select the “download” button at the bottom of the screen. Any locked log files will show the word “locked” on the screen and will also prevent you from selecting that log. The example below shows the tm1server.log file checked and shows the tm1s.log file as locked.

IBM Planning Analytics Tricks: Log Lock Notification

This approach will help you easily remember which files are accessible and which are not.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

IBM Planning Analytics Tips & Tricks: Show Members

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening Your MDX Skills

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning Analytics tips, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW

December 1, 2020 by Thanh Chau Leave a Comment

One of the helpful features of IBM Planning Analytics is the ability to create explorations using asymmetric axes. This is useful when you have stacked column or row dimensions, and only want to display certain combinations of elements instead of all combinations of the stacked dimensions.

To do this in Planning Analytics Workspace (PAW), open a workbook in PAW and open an exploration. Click on the Icon in PAW icon to make the row dimensions asymmetric or the icon in PAW_2 icon for the column dimensions. Next, hold down the CTRL key and select the rows or columns you want to keep or hide.

IBM Planning Analytics Tips & Tricks: Asymmetric axis in PAW

Right-click on one of the selected columns and select “Keep” or “Hide.”

Asymmetric axis in PAW

If you need to revert back to the normal view, right-click on any row or column and select “Unhide All.”

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters. You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Pass Context

IBM Planning Analytics Tips & Tricks: The Collect Feature in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Navigating Back to the Source

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Workspace, Planning Analytics tips, Planning Analytics Tips & Tricks, Planning Analytics Workspace, TM1

IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports

November 24, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) provides the ability to convert an existing view directly to a report in Excel? Without opening the view as an Exploration, you can start building your report directly from the Task Pane.

Just right-click on the view in the Task Pane to display the available options.

IBM Planning Analytics Tips & Tricks: Convert Existing View to Reports

You will see the following options by hovering over the Quick report, Dynamic report, and Custom report items:

How to convert existing views into reports in Planning Analytics

In this example, each of the items does the following:

  • On this sheet: This will open the existing Planning Analytics view as a Quick report on the current Excel sheet at cell $A$1.
  • On new sheet: This will open the view as a Quick report on a new sheet at cell $A$1.
  • At current location: This will open the view as a Quick report at the cell that is currently active.
  • At specified location: This will open a pop-up window that allows you to input the cell at which you would like the Quick report to appear. You can then enter the cell address and click OK to generate the Quick report, as shown in the following image.
Learn how to convert existing views to reports in Planning Analytics

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks posts:

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

IBM Planning Analytics Tips & Tricks: PAx Control Objects

IBM Planning Analytics Tips & Tricks Video: Using Drag & Drop to Change Selector Elements in PAx Reports

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Nina Gordy, Planning & Forecasting, Planning & Reporting, Planning Analytics tips, Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

November 17, 2020 by Nina Inverso Leave a Comment

Did you know that Planning Analytics for Excel (PAx) automatically keeps track of the Planning Analytics objects you have open in an Excel workbook?

Simply click on the Workbook tab of your Task Pane to view the list of Dynamic reports, Action buttons, Explorations, and Quick reports that are currently in use.

IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab

These folders will be populated as you work with your Planning Analytics environment. Whether you manually add these items to a worksheet, or they are included in an existing view or report, they will appear here.

For example, clicking the Exploration button in the PAx ribbon will create an Exploration on a new worksheet.

The PAx task pane workbook tab in IBM Planning Analytics

This will also add an item to the Explorations folder on the Workbook tab of the Task Pane. When you right-click on the name of the new Exploration, you will see the following options:

Learn about the PAx task pane workbook tab in IBM Planning Analytics

Similar options appear for Dynamic reports, Action buttons, and Quick reports.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAx Control Objects

IBM Planning Analytics Tips & Tricks: New PAx Features – Double Click

IBM Planning Analytics Tips & Tricks Video: Using Drag and Drop to Change Selector Elements in PAx Reports

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Nina Gordy, PAx, Planning & Forecasting, Planning & Reporting, Planning Analytics for Excel, Planning Analytics Tips & Tricks, TM1

FP&A Done Right: Five Tips for Budgeting in the Age of COVID

November 13, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins explains why traditional budgeting is not a fit for the volatility, complexity and uncertain times businesses face today.

The pandemic is causing boards of directors and C-suite executives to take a new look at net cash flow. Traditional budgeting is simply too slow and too rigid to keep up with the rapidly changing business environment caused by COVID-19. There is too much volatility, complexity, and uncertainty right now.

Gone are the days when budgets could be one-and-done—tied to a fixed point in time and too inflexible to adjust to quickly changing business opportunities and challenges. In today’s world, a startup can be up and running and profitable in three months and disrupt its competitors. Consider Uber and Airbnb as examples. If your company takes nearly as long to create an annual budget, which is typically out-of-date a few months later, it will be extremely difficult to fight off the upstarts or keep up with your established competitors.

The solution? A flexible and continuous budgeting and forecasting process, often referred to as a rolling financial forecast, that helps you anticipate change and focus on outcomes rather than outputs and that is derived from the drivers to determine planned spending.

Here are five tips to modernize your budget process:

1. Just say no to one-and-done

Now more than ever, December’s fiscal year-end numbers often bear little resemblance to July’s realities—meaning budgets and forecasts must become more streamlined, accurate, and responsive. Annual budgeting won’t go away, but spending weeks and months processing data and reconciling spreadsheets that are out of date soon after the consolidated master budget is published doesn’t cut it anymore.

Modern budget solution:

  • Increase the frequency of budgets and forecasts to reflect shifting business conditions
  • Make decisions and plans based on data-backed insights rather than old and stale information
  • Change how resources, employees, and assets are allocated throughout the year and how the budget incorporates real-time opportunities and challenges

2. Focus on business drivers, not cost centers

Traditional budgeting focuses on allocating resources to cost centers, but business objectives (projects, products, and service lines) result from end-to-end cross-functional processes across the org chart. So if you determine the level of resources and spend based on forecast demand, then budgets and rolling forecasts can reflect performance that is company-wide rather than specific to a cost-center department.

Modern budget solution:

  • Enable organization-wide access to reports and data, allowing everyone to have visibility into the enterprise’s performance, including into individual departments
  • Review forecasts against budgets to eliminate confusion among competing departments
  • Provide real-time information for the needed insights to support better decision-making at all levels of the organization
  • Use drivers to determine the level of needed capacity (i.e., types and numbers of employees) to match your supply of capacity with demand

3. Create rolling financial forecasts

More than ever, fluctuating market conditions make accurate forecasts of future demand load (e.g., customer orders and sales) extremely challenging. Rolling financial forecasts help manage investments or financing determined by cash flow. They provide visibility into business performance using time horizons that reflect the speed of your business.

Modern budget solution:

  • Generate rolling financial forecasts that accommodate real-time shifts in market conditions
  • Enable self-service reporting so everyone in the organization can measure their performance against company-wide KPIs
  • Help everyone in the organization understand the downstream effects of their resource allocation decisions

4. Look forward, not back

Most budgets and forecasts are outdated before you push “publish” or soon after. And some factors are impossible to take into account (natural disasters, pandemics, broken supply chains, work stoppages). The rearview-mirror orientation of traditional budgeting (e.g., last year’s actuals create this year’s budgets) often results in increased “actuals” as managers exhibit “use-it-or-lose-it” behavior by spending needlessly to attain their prior fiscal year budget. Traditional budgets can’t keep up with the speed of modern business. One needs to look forward through the windshield.

Modern budget solution:

  • Respond faster to shifts in market conditions with real-time access to financials
  • Adjust outdated budgets and forecasts as change occurs
  • Move leadership discussions toward insight, planning, and action, rather than using the budget as a cost control mechanism to punish those with unfavorable cost variances

5. Use the right tools for the job

Creating a budget process that keeps up with the pace of today’s business requires a comprehensive, collaborative, and continuous planning platform—one that gives you robust, accessible reporting and modeling capabilities; dashboards with indicators and their targets that provide visibility into overall company performance; and automated tools that streamline budgeting and forecasting processes.

Modern budget solution:

  • Enable comprehensive planning that aligns the actions and priorities of everyone across the organization around common KPIs
  • Create opportunities for collaboration by giving everyone access to the data they need and deserve
  • Adjust and update budgets and forecasts on a continuous basis so you can navigate volatile market conditions in real time

Don’t let traditional budgeting lock you into outdated assumptions and fixed targets. Those outdated targets handcuff managers when the organization changes directions. Some managers view the fiscal year budget as a “contract” that they will not deviate from to minimize unfavorable variances from their allotted cost center budget expenses. This short-term focus jeopardizes the longer-term view. The modern FP&A professional knows the truth: Aligning budgets and rolling financial forecasts with comprehensive plans lays the groundwork for proactive rather than reactive planning—a significant strategic advantage in today’s highly competitive environment.

This blog post was originally published by Workday Adaptive Planning and appeared here.

Read more guest blog posts from Workday Adaptive Planning:

FP&A Done Right: Three Driver-Based Budgeting Tips for CFOs When Change is Imminent

FP&A Done Right: Three Words for a COVID-19 World – “Flexible Budget Variance”

FP&A Done Right: Planning for What’s Next in Uncertain Times

Home » Analytics

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, Rolling Forecasts, Workday Adaptive Planning

Workday Adaptive Planning Tips & Tricks: CAPEX Planning – Your Tool for Growth

November 11, 2020 by Mary Luchs Leave a Comment

CAPEX (capital expenditures) planning is a key feature in Workday Adaptive Planning and gives the Office of Finance and senior executives greater visibility into the company’s financial risk, while also providing a tool for measuring corporate growth. Before we go into the specifics of CAPEX in Adaptive Planning, let’s take a step back and get an understanding of CAPEX.

Capital Expenditures: Overview

Capital expenditures are expenditures within a company that are not expensed on the income statement. They are considered to be investments into the company. Companies with higher capital expenditures are said to be investing more heavily into the future of their organizations.

CAPEX to Operating Cash Ratio

The CAPEX to operating cash ratio analyzes a company’s ability to acquire long term assets using cash flows. In other words, it indicates how much of a company’s cash flows is going towards capital expenditures. It is a great tool for measuring a company’s emphasis on growth. A higher CAPEX to operating cash ratio is an indicator of high growth in a company. A company whose ratio is too high could be taking on too much financial risk. While it is beneficial to invest in CAPEX, overspending in this area can compromise a company’s ability to pay off debts or cover other operating expenses. It is vital for the Office of Finance to have accurate, up to date visibility into CAPEX data in order to assess the company’s level of risk and make appropriate adjustments.

CAPEX and Depreciation

Depreciation is important to consider for asset management, especially for companies who are putting a lot of money towards their assets in the form of capital expenditures. A company must consider how their CAPEX depreciates when looking at their assets. This is a helpful tool to consider:

CAPEX > Depreciation → Growing assets

CAPEX < Depreciation → Shrinking assets

Accumulated depreciation of capital expenditures is indicated on the Balance Sheet, so it is important to consider how this impacts the net income of the company. Depreciation reduces the taxable income of a company, which is impactful especially for companies in a high growth phase who are investing heavily in capital. In addition to the CAPEX to operating cash ratio, depreciation can also be considered when analyzing a company’s growth.

Capex Planning in Workday Adaptive Planning

In addition to having a basic balance sheet and a P&L sheet, you should create a CAPEX sheet in Adaptive Planning. The CAPEX sheet offers a more specific look at capital expenditures than the balance sheet and the P&L sheet, allowing for more targeted analysis. Generating a CAPEX sheet also allows you to drill into expenses and depreciation for budgeting and forecasting purposes on a more granular level.

CAPEX Planning in Workday Adaptive Planning

In conjunction with the balance sheet, the CAPEX sheet is important for budgeting cash and analyzing capital investments. In Adaptive Planning, the CAPEX model consists of calculated accounts in a modeled sheet. These calculated accounts include capital values and their coinciding depreciation accounts. Each modeled account is performing the same calculation based on the asset class selected by the user. Asset class is a text selector column based on the categories of capital expenditures that are specific to your business. Companies vary greatly in the ways that they calculate capital value and depreciation, but all businesses can benefit from CAPEX planning.

How to do CAPEX planning in Workday Adaptive Planning

Adding a CAPEX sheet to your Adaptive Planning implementation gives you a powerful tool for understanding the investments in your company. When you can analyze this data at a granular level, you can better assess if your company has too much financial risk, or if you are invested at an appropriate level.

The team at Revelwood has been recognized by Workday Adaptive Planning for our thought leadership in the space, commitment to our Workday Adaptive Planning practice, and our rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Override Formulas in Sheets

Workday Adaptive Planning Tips & Tricks: Templates

Workday Adaptive Planning Tips & Tricks: Alternate Time Tree

Home » Analytics

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Budgeting, Budgeting Planning & Forecasting, CAPEX, enterprise performance management, Financial Performance Management, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

November 3, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding one side of the subset editor.

Here is an example of the subset editor which shows both the available members and the current set.

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

Each of the two sections has an option to minimize the area. This is done by clicking on the minus symbol at the top of the applicable section.

IBM Planning Analytics: Minimizing the Subset Area

Once clicked, the applicable area will compress and the other area will expand. Note that you can only minimize one side at a time. Below are examples of what each screen will look like when compressed.

Minimized Available Members:

IBM Planning Analytics Tips: Minimizing the Subsea Area

Minimized Current Set:

Minimizing the subset area in IBM Planning Analytics

This approach will allow you to further customize your subset editor screen to allow you to focus only on the area you want to see.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Maintaining Subset-Drive Consolidations

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

Home » Analytics

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 27
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

Contact:

25B Vreeland Road, Suite 111 Florham Park, NJ 07932
201.984.3030
info@revelwood.com

Copyright © 2023 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.