Jedox Ideas

Let us know how we can make Jedox even better!

Add a new idea Subscribe
Status Not Planned
Workspace Jedox Platform
Categories Jedox Web Navigation
Created by Guest
Created on Apr 26, 2021

RELATED IDEAS

Expand number of columns possible in Jedox Web Spreadsheet from 256 to 1,000 (min)

In order to create web models, it is sometimes necessary to import excel files which have more than 256 columns (current Jedox limit). In many instances these "wide" data blocks are parts of arrays (which can not be broken up) and are needed for matrix multiplication.

  • ADMIN RESPONSE
    Jan 21, 2022

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.

    The larger the data area the more risk of introducing performance issues, so we carefully consider limitations such as this.

    If you have complex matrix calculations perhaps the use of an integrator job (triggered from an action button) could be a more scalable approach.

  • Guest
    Reply
    |     Feb 24, 2023

    I don't see how a web enabled model (which is how I would use Jedox) that calculates economic impacts on the fly could work using an ETL. While a datacube could be loaded with data and the function of MMULT replicated via rules (it is difficult to do) it is virtually impossible to replicate a MINVERSE function via rules and datacubes. The only way to solve a MINVERSE function on a large matrix would be to engage the excel functionality of Jedox....but again this can't be done if limited to 256 columns wide in a Jedox Web spreadsheet.