How can we improve Jedox Software?

ETL: Initialize variables via PALO.Data / OLAPData function

Thanks for extending the definition of variable default values
by groovy script and Jedox settings.

But it would be much more helpful to initialize variables directly via a cube lookup (PALO.Data / OlapData function).

We have several configuration cubes where settings are maintained.

It is currently very clumsy and annoying to initialize the variables based on the confiuration cubes.
You need a LoopJob or TableLoop, a ConstantTable Extract, and a Field Transform with OLAPData to simply set one value. (see attached example)

The structures you need to build for variable initialization are sometimes more complex than the process itself.
This is bloating the flow chart and reduces maintainability and transparency.

2 votes
Sign in Sign in with Jedox AG
Signed in as (Sign out)

We’ll send you updates on this idea

Jens Lorentz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Starting with 2019.1, Groovy Origin variables can reference values from a Global Connection, such as Jedox Cube or relational connection. This is useful if you need to retrieve stored connection variables, such as tokens, when you connect via REST.


Sign in Sign in with Jedox AG
Signed in as (Sign out)
An error occurred while saving the comment

Feedback and Knowledge Base