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
Created by Guest
Created on Jul 2, 2019

Aggregate lists of elements for each dimension in PALO.DATA functions instead of single.

A PALO.DATA function refers to single base or consolidated elements for aggregation. It would be fine to be able to define subsets of elements to get a sum of these,
  • Guest
    Reply
    |
    Oct 6, 2022

    this would be really helpful. Currently you have to use a palo.datav and sum up the result (delegating the sum to the client, whereas the sum could be done by the olap server)

  • Guest
    Reply
    |
    Jul 2, 2019
    As part of that feature the user will be able to select a subset (or more than one element) at a "filer" dimension(s)
  • Guest
    Reply
    |
    Jul 2, 2019
    I don't think that the answer of the Jedox Admin fit's to the request. I think the intention of the requester and the voters was the following: It should be possible to get an aggregated total of a subset out of a single PALO.DATA formula, like this: PALO.DATA ("myDB","ProductCube",PALO.SUBSET(), ...) instead of only PALO.DATA ("myDB","ProductCube","ProductGroupA", ...) To my knowledge to refer to a subset inside of a PALO.DATA formula is still not possible in Jedox6. Therefore I think this request is not completed at all. (Correct me if I am wrong) BR Jens