Jedox Feature Voting Tool

Dear Jedox User,

in our continuous strive to improve our services, features and to help you gain your share of this ever growing market we are introducing the Jedox Feature Voting System.
This new service is currently exclusively available for you, our Users and Partners.

What is this Jedox Feature Voting System?
It is a tool that provides you with the options to create and vote on Feature request, Ideas and any other general Feedback.
This in return provides us with the necessary Information to react and provide you with the things you need.

We invite you to browse this Page, create and vote on new Features, Ideas and requests!

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Rule template on System dimensions

    Allow queries on System dimensions, for instance #_GROUP_, to be able to define dynamic right rules (e.g. in #_GROUP_CELL_DATA_<cube>)

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Jedox In-Memory Database (OLAP)  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add monitor log filter option for custom script debugging

    As ETL-developer/Integrator you can write custom debug within (Groovy) scripts to show specific info in monitoring/logging. Long and complex ETL-processes return many pages of log info, most not interesting for debugging custom scripts. Please add an additional log method filter (for example: UINF (LOG.uinf) and an extra filter option (tag?) in the integration monitoring to filter user based debugging. makes

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. LDAP groups nesting support to better and simplified user rights management

    Please, consider this simple example:

    LDAP Groups:
    - CONTROLLERS
    - CONTROLLERS_CZ
    - CONTROLLERS_DE
    - CONTROLLERS_PL

    LDAP Users :
    - Controller_CZ
    - Controller_DE
    - Controller_PL

    LDAP Users in LDAP Group(s):
    - Controller_CZ / CONTROLLERS_CZ
    - Controller_DE / CONTROLLERS_DE
    - Controller_PL / CONTROLLERS_PL

    LDAP Groups in LDAP Group(s):
    - CONTROLLERS_CZ / CONTROLLERS
    - CONTROLLERS_DE / CONTROLLERS
    - CONTROLLERS_PL / CONTROLLERS

    In Jedox:
    1) some common and general functionalities (reports access, data forms access, spliting of data functionality, etc.) will be assigned to LDAP group "CONTROLLERS" (all users can access specified objects/functionalities)
    2) Data access will be manageged by exactly specified groups CONTROLLERS_<XX>.…

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  System  ·  Flag idea as inappropriate…  ·  Admin →
  4. Right-To-Left Text Direction (Critical !)

    It is very important for right-to-left languages to have the Right-To-Left Text Direction like in any MS office application.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Web  ·  Flag idea as inappropriate…  ·  Admin →
  5. Layout sheet Right-To-Left

    Option to change web spreadsheet layout to Right-To-Left like in MS Excel.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Web  ·  Flag idea as inappropriate…  ·  Admin →
  6. Initial roles and groups in DXP file

    Allow to export specific roles and groups when exporting a JDXP file.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Models  ·  Flag idea as inappropriate…  ·  Admin →
  7. Excel / Spreadsheets: paste relative or fixed formulas

    Please consider an enhancement to Jedox Paste data function and Paste view.
    This would allow the user to select whether the Excel formula would be relative or fixed before pasting into a spreadsheet.
    This would help in building spreadsheet and web models. It is available in TM1.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Jedox Office Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. graphs label in Jedox web

    Labels in Jedox web graph are displaying with a white font and it's not best looking. It should be the same display than in Excel.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Web  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide more models related to Insurance and pharmaceuticals Industry

    It would be a great help if we get models related to more Variety industry like Insurance, Pharmaceutical Domain to showcase the customer a variety of models.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Models  ·  Flag idea as inappropriate…  ·  Admin →
  10. Built-In Scalar Dimension

    Scalar1 for instance would be a dimension with predefined values from 0-100. You could assign meaningful names to each value using an alias. The benefit would be that rules requiring a previous or next value would not require a "lookup" for what the previous or next value is. This is important in nested rules. For instance in occupational modelling where next year, next age is a function of previous year, previous age.

    NEXT_YEAR, NEXT_AGE = PALO.DATA("XXXDatabase","CCCube",PALO.EPREV("XXXDatabase","XXDimension",!'XXDimension'),PALO.EPREV("XXDatabase","YYDimension",!'YYDimension'),…) * …

    This could be replaced with NEXT_YEAR, NEXT_AGE = PALO.DATA("XXXDatabase","CCCube",PREVIOUS("XXDimension"),PREVIOUS("YYDimension"),,…) *

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Jedox In-Memory Database (OLAP)  ·  Flag idea as inappropriate…  ·  Admin →
  11. Option not to display 0 value Label in a pie Grap

    In Excel, there is an Option to select what should be done with empty cells but not in Jedox web.
    It should be great to have this option in graphs Jedox web.
    Please find attached an Excel exemple.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Web  ·  Flag idea as inappropriate…  ·  Admin →
  12. Drill history should drill down to base level automatically

    Drill History Right now only delivers values when all dimensions are set to base Elements. So users can only see the history of a cell when all base Elements are known. That is very unlikely and is in contradiction to the usage of the flexible cube layout when only relevant Dimensions are given in PALO.DATA using PALO.EL()

    Drill History should rather work in the same way as drill thru and drill down C-Elements automatically.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox In-Memory Database (OLAP)  ·  Flag idea as inappropriate…  ·  Admin →
  13. NEW Active Directory mode, that combine the "Authentication" and "Authorization" mode.

    Currently it is neither possible in "Authentication" mode nor in "Authorization" mode to automatically create/login the users via the AD* and subsequently assign several additional groups to the user.
    Either you have to create them manually and assign the additional groups or you can only become the assigned groups in the AD.

    Due to its needed in more projects I´m really looking forward for a combination of both modes.

    *Active Directory

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  System  ·  Flag idea as inappropriate…  ·  Admin →
  14. Extend DB Script generation (cube+related dimensions, select multiple db objects)

    The option to generate DB scripts is really great!
    But currently you can only create scripts for single db objects (dimensions, cubes) or for the whole db in total.

    It would be great if Jedox would offer some options to save time.

    1.
    when I create a db script for a cube, I would need the option to
    also create scripts for the related dimensions

    2.
    in general it would be great if I could select multiple cubes and/or dimensions from a list to generate the scripts for them

    Thanks

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox In-Memory Database (OLAP)  ·  Flag idea as inappropriate…  ·  Admin →
  15. NULL check for FieldTransform functions (ISNULL/default value)

    In FieldTransform functions we need the option to define a default value for inputs and outputs which contain NULL values / invalid values.

    Why?:
    FieldTransform functions work well, if you have valid inputs.

    But sometimes you have invalid inputs or null inputs.
    Then the field transform can obviously not provide a valid output and you will get <<null>> as result.
    Furthermore you get a warning in the log.

    You can solve this with additional Switch functions to check the values, but this gets very clumsy and confusing.

    Example:
    You have a DateDuration function to calculate the duration between
    2 dates.…

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. 1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. Subset data filter based on multiple cubes

    Example: you have two cubes - one with P&L data based on year/month (two separate dimensions), other one with P&L data based on rolling month (rolling from previous month)

    The report needs to show P&L from current month + rolling column (which starts from previous month). It would be super useful to configure data filter to show Cost Points where are values in both cubes.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Web  ·  Flag idea as inappropriate…  ·  Admin →

    Since version 7.0, PALO.SUBSET formula supports specifying multiple DFILTER expressions. the formula has to be edited manually – the Subset Editor doesn’t support multiple DFILTER expressions. Please check the description in the Jedox Knowldge Base to see if this is sufficient for your requirement.

  18. Attributes / Flags for Rules

    Hi Jedox team,

    currently we only have a comment section to add additional information to a rule.
    But especially for automated processing of rules via ETL it would be great to be able to mark/flag certain rules in a more structured way.

    In the first step just one additional field would be enough.
    (name could be "Tag")

    Maybe later it could be extended to something similar to the attributes for dimension elements.

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox In-Memory Database (OLAP)  ·  Flag idea as inappropriate…  ·  Admin →
  19. Shortcut for Data Preview

    A shortcut for Data Preview in the ETL would be quite useful, and I think not so complicated to develop

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. Window functions in ETL

    This would be great to add window functions capabilities in the ETL, maybe as a new function. Window function allow to do aggregations within a query, on the query itself. For instance:
    id | Value | Sum
    X | 1000 | 6000
    Y | 3000 | 6000
    Z | 2000 | 6000

    the third column is the result of a window function (this can also be avg, max...)

    this is present in some relational systems, see here : http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf

    at the present time to do that in the ETL you have to get an aggregation component, and lookup on it…

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base