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.

3 votes
Vote
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Jens Lorentz shared this idea  ·   ·  Admin →

0 comments

Sign in
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base