Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Categories In-Memory DB Views
Created by Guest
Created on Nov 30, 2023

Filter virtual dimension elements in Views / Charts

A virtual dimension always has a certain structure.

- <attribute name>
-- Total <attribute name>
--- <attribute value>
---- <base element>
-- No <attribute name>
--- <base element>

While this is good enough for data analysis within the Views table, for a Chart you typically only want elements from the same element level (PALO.ELEVEL), so you don't mix up consolidations and their children in the same series.

That's why for a chart you would expect that there is some way of only showing the "<attribute value>" and the "No <attribute name>" elements, for example "Black", "Red", "Green" and "No color", if the attribute name was "color".

Since there is no way to create and use subsets in virtual dimensions, there is right now no way of accomplishing this in a dynamic way, but only through manual selection. Manual selection means you would always have to check the dimension again to see if there are new attribute values in the meantime, and then select them additionally.