Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Created by Guest
Created on Sep 1, 2021

Simplified expression for retrieving attribute value in In-Memory DB list

In Olap Lists, if you want to retrieve an attribute for a List block which uses a dynamic expression (e.g. reference to dimension in the View "POV"), you have to enter a formula-like expression which requires escaping quotes etc.

To simplify this for the common usecase of attribute retrieval, introduce a new possible syntax, such as:

${dimensionname|attribute}

When used, the attribute value of "attribute" for the element used in view for "dimensionname" is used when the List is calculated. This would allow looking up some element from an attribute (e.g. a "PreviousMonth" in a time dimension)

This is similar to already existing expressions like ${dimensionname - 1}

  • ADMIN RESPONSE
    Sep 22, 2022

    Thanks for the idea. We have recently shipped this in the latest release of Jedox. Please check it out and tell us what you think!