Aramar
  • About Aramar
    • Meet The Team
    • Working at Aramar
    • News, Blogs and Events
  • How can we help?
  • IBM Analytics
    • IBM Cognos Controller
    • IBM Planning Analytics with Watson
    • IBM Cognos Analytics with Watson
    • IBM Legacy Software Support
    • Supporting Software
  • Services
    • Product Specialists
    • IBM Software Licencing
    • Cognos Analytics Cloud Migrations
    • Training Courses
    • IFRS 16
  • Support
  • Fast Financials
  • Knowledge Share
Get in touch

Aramar Knowledge Share Documentatation

IBM Planning Analytics

  • How to: Change the display row limit in Planning Analytics for Excel
  • How to: Mapping a CSV data source directory in 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 (TI) in 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 in 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

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, which is a great way of showing just the data that the user wants to see. This works very well, but 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, and this shows the one day where 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 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, so when we swap to a new employee the dates subset brings up 3 dates that match the criteria.

 

 

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

How can we help?

Updated on July 5, 2022
How to: Using the While statement (TI) in Planning AnalyticsAramar Tips: Creating documentation IBM Planning Analytics

Powered by BetterDocs

Aramar

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

Contact us today

Useful Links

  • About Aramar
  • How can we help?
  • IBM Analytics Suite
  • 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 2022.

Terms of use Privacy Policy

Marketing by Unity Online