Hello everyone,
I haven't found a thread so far covering this subject and haven't really found a solution in the knowledge base either.
Say I have a only a file of line items (i.e. seperate entries to the account) to all P&L accounts and want to get the aggregation done via integrator.
How would I achieve this, since the aggregation function in the field transform aggregates accross columns but not accross lines, or am I just too blind to see it?
And I cannot use the "add" in cube load, just the "insert", because the provided files always contains all periods of the year. And they should always be overwritten.
Let's assume the data looks something like this:
the intended result that should be written to the cube would be this:
IMORTANT: Should be still applicable to Jedox 6.0 SR3
Thanks a lot in advance for any hints and help.
BR
Bjoern
I haven't found a thread so far covering this subject and haven't really found a solution in the knowledge base either.
Say I have a only a file of line items (i.e. seperate entries to the account) to all P&L accounts and want to get the aggregation done via integrator.
How would I achieve this, since the aggregation function in the field transform aggregates accross columns but not accross lines, or am I just too blind to see it?
And I cannot use the "add" in cube load, just the "insert", because the provided files always contains all periods of the year. And they should always be overwritten.
Let's assume the data looks something like this:
Period | Account | Cost center | #Value |
11.2017 | 43200000 | 10004000 | -2000 |
11.2017 | 43200000 | 10004000 | -500 |
11.2017 | 43200000 | 10005000 | -60 |
11.2017 | 43200000 | 10005000 | -40 |
11.2017 | 43400005 | 10004000 | -1000 |
11.2017 | 43400005 | 10005000 | -100 |
the intended result that should be written to the cube would be this:
Period | Account | Cost center | #Value |
11.2017 | 43200000 | 10004000 | -2500 |
11.2017 | 43200000 | 10005000 | -100 |
11.2017 | 43400005 | 10004000 | -1000 |
11.2017 | 43400005 | 10005000 | -100 |
IMORTANT: Should be still applicable to Jedox 6.0 SR3
Thanks a lot in advance for any hints and help.
BR
Bjoern