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: Create Subsets driven by another Dimension in Planning Analytics

How to: Create Subsets driven by another Dimension in Planning Analytics

IBM Planning Analytics allows us to create views that are built from sets or a selection of elements for each dimension in the cube #

This is a great way of showing just the data that the user wants to see. However, sometimes we want the subset to be driven by a value that is in another dimension of the cube. You can do this easily by using MDX code.  

 In the example below the Employee’s ‘Operational Input’ is a subset of current dates. On one day, there is an ‘Error’ on the input.  

However, as part of the Month End processing the user only wants to see lines where there is an error and not have to look through dates that are OK.

Well, IBM Planning Analytics allows us to make a cross-dimensional filter in MDX. In this case, we have added an additional FILTER command to the operational window subset. This allows us to identify just those dates that have an error.

 

{{{{FILTER({FILTER({TM1FILTERBYLEVEL(TM1SUBSETALL([T__Date]),0)},(T__Date.[Relative Day]>=-90 AND T__Date.[Relative Day] <= 10 ))}, [T__Tracker].([T__Tracker_Measures].[Error])< > 0)}}}}

 

IBM Planning Analytics handles the full dimensionality from the context bar. When we swap to a new employee, the dates subset brings up 3 dates that match the criteria.

 

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

How can we help?

Updated on May 3, 2023
How To: Investigating issues using the TM1 Server Log

Powered by BetterDocs

Table of Contents
  • IBM Planning Analytics allows us to create views that are built from sets or a selection of elements for each dimension in the cube
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