Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Delivered
Workspace Planning Analytics
Created by Guest
Created on Jul 3, 2019

PAW Cubeviewer: Asymmetric calculations

PAW cubeviewer introduced "on the fly" calculation within the cubeview. However these calculation only works in symetric mode which means that we can't cross specific elements of several dimensions to create calculation.

A simple example in financial data cube: We would like to calculate the difference between Budget 2019 and Restatement 2018 (Restatement is historical financial data that has been reworked to be comparable with the following year). In the cube, we have the YEAR dimension which stores 2018/2019 and the SCENARIO dimension which stores Budget/Restatement. The cubeviewer currently only allows [Budget].[2019] - [Budget].[2018] and [Restatement].[2019] - [Restatement].[2018] calc. We would like to be able to do [Budget].[2019] - [Restatement].[2018].

Furthermore TM1server accept asymetric request using Rest api MDX call. The following statement is actualy valid for TM1server:

"WITH MEMBER [YEAR].[YEARS].[ASYM_CALC] AS ([YEAR].[2020], [SCENARIO].[BUDGET_OFFICIAL]) - ([YEAR].[2019], [SCENARIO].[FLASH_RESTATED]) SELECT {{([YEAR].[2019], [SCENARIO].[FLASH_RESTATED])},{([YEAR].[2020], [SCENARIO].[BUDGET_OFFICIAL])},{([YEAR].[ASYM_CALC], [SCENARIO].[BUDGET_OFFICIAL])}} ON 0, HEAD({[BUSINESS_UNIT].[BUL620PU]}) ON 1 FROM [01A_PLPRODUCT] WHERE ([PERIOD].[M12] , [PRODUCT].[OGD99999] , [LOCAL_CURRENCY].[LOCAL] , [VALUE_TYPE].[VALUE] , [ORIGIN].[DIRECT_OG] , [PL_PRODUCT].[R00100AA] , [CUSTOMER].[CU999999])"

Workaround: There's none within the cubeview.

Proposed solution: Enable calculation within the cubeviewer "asymetric mode"

Benefit: In cube models with 10-20 dimensions, symetric calculations are often useless as data to be compared is often stored on asymetric locations. The benefit would be quite huge as asymetric views with asymetric calculations greatly simplifies end-user cube exploration and substancially inscrease his/her productivity.

I've attached a file with screenshots to further illustrate my request

Needed by Date Feb 1, 2020
  • Guest
    Reply
    |
    Jul 28, 2023

    Hi Stuart. Just wanted to check - are you sure that this particular request has been delivered in Workspace views? I understand that asymmetric calculations are now available, but I don't think the above is the type of asymmetric calculation that has been delivered.

    Asymmetric calculations available in Workspace allow users to add calculations to a part of a view, i.e. apply the calculation asymmetrically to certain elements of another dimension. However, it does not allow this calculation across 2 dimensions that is detailed above. This is a regular requirement in finance, and can currently only be done by:
    - Drafting MDX to achieve the calculation (using "With Member"), similar to example above

    - Build the report in Excel - not ideal when wanting users to work in Workspace

    - Duplicating data in cube (moving around data to new versions such as LY Actual or similar) - we'd like to avoid this.

    Please consider whether this idea should really be marked as delivered?

    2 replies
  • Admin
    Stuart King
    Reply
    |
    Jun 8, 2021

    Updated status to Delivered

3 MERGED

See and reuse PAW calculations

Merged
We have many calculations created in PAW views by admin or non-admin users. It would be useful for users to see existing calculations and re-use them.
over 5 years ago in Planning Analytics 0 Delivered
5 MERGED

asynchronous (or asymmetric) calculations in PA Workspace

Merged
asynchronous calculations in PA Workspace via the 'add calculation' feature
almost 8 years ago in Planning Analytics 1 Delivered