How can we improve Jedox Software?

Set a Variable by using a FieldTransform Function

For those People, who are not so familiar in coding groovy it will become a challenge setting a Variable in the ETL-Manager by scripting groovy.

So it would quite helpful to have a separate FieldTransform Function,
which enables the user to set a variable directly.

It would be also quite helpful, if the possible conflicts with datatypes could be solved with such a function..!

example:

There is an extract with 1 column and 1 row:

number of reords
4562156

Calculate anything with this number...

number of reords | records/50000 | counter | set_variable | get_variable |
4562156 | 91,24312 | 91 | | 91 |

In the column 'set_variable' the variable is set as the groovy function
API.setProperty("variable",counter) would do, if there weren't so much
possibilities to get conflicts with the DataTypes

In the column 'set_variable' the current variable is shown...

...end of example

5 votes
Vote
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Oliver Dammann shared this idea  ·   ·  Admin →
completed  ·  AdminJedox (Admin, Jedox AG) responded  · 

A FieldTransform is not the right place to define variable values
To achieve this you can:

Alternative 1:
- Create variable “number of records”
- Create new transform of type TableLoop with

  • Loop source: The extract with 1 column (named “number of records”) and 1 row
  • Data source: The source which uses this variable anywhere

Alternative 2:
- Create variable “number of records”
- Create new job of type eLoop with

  • Loop source: The extract with 1 column (named “number of records”) and 1 row
  • Execution type/name: A load or job which uses this variable anywhere

Handling of datatypes is a separate topic.

0 comments

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

Feedback and Knowledge Base