Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on May 8, 2020

Fetch distinct list of attribute values

In some scenarios, it could be helpful to get a list of distinct attribute values; for example, on a Products dimension with a "color" attribute, return a list of the colors, but each distinct color should appear only once in the result.

One possible implementation might be a new subset option, "Show duplicate attributes", default being true (compatible with current subset results); if false. the Subset would only return the first of elements with distinct attribute values (the first product with color "red", then the first product with attribute "blue" etc.), for the Attirbute selected as "Alias" in the subset. This would also allow showqing a list of distinct attrbute values simply for example in a combobox (by using the "Show Alias" option).


Feature: hide duplicate attributes in Subset

The subset editor has the option "show duplicates" which is checked by default. When unchecked, double elements (e.g. in parallel hierarchies) are hidden. There should be an extra checkbox underneath it, "Show duplicate attributes". By default, t...
almost 5 years ago in Jedox Platform / Other 0 Shipped