Page 1 of 1
Transferring and Summing Data from cube to another
Posted: Thu Oct 12, 2023 1:27 pm
by simon_pr3
Hi Everyone,
A quick explanation of what I want to do:
I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube.
I understand I need to use a process to do so, is that correct?
Or is there al although a way with a rule?
I just want to start in the right direction.
BR Simon
Re: Transferring and Summing Data from cube to another
Posted: Thu Oct 12, 2023 2:12 pm
by tomok
simon_pr3 wrote: ↑Thu Oct 12, 2023 1:27 pm
Hi Everyone,
A quick explanation of what I want to do:
I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube.
I understand I need to use a process to do so, is that correct?
Or is there al although a way with a rule?
I just want to start in the right direction.
BR Simon
The answer to this question depends on whether or not you need the summarization to be "on the fly" (which means rules) or the cubes are not similar enough which means rules might be difficult or impossible to write for this linkage. It all depends on the circumstances as to which one is better.
Re: Transferring and Summing Data from cube to another
Posted: Thu Oct 12, 2023 3:28 pm
by ardi
simon_pr3 wrote: ↑Thu Oct 12, 2023 1:27 pm
Hi Everyone,
A quick explanation of what I want to do:
I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube.
I understand I need to use a process to do so, is that correct?
Or is there al although a way with a rule?
I just want to start in the right direction.
BR Simon
Does this Invart1 dimension have a Total Element? As Tom mentioned, it all depends on the situation (cube structures and also requirement). I usually prefer to use TI and then introduce an Action Button to the users in order to transfer the data, or schedule a process to run periodically.
Re: Transferring and Summing Data from cube to another
Posted: Tue Oct 17, 2023 11:33 am
by simon_pr3
Invart1 has a total sum.
Re: Transferring and Summing Data from cube to another
Posted: Mon Nov 06, 2023 11:16 am
by simon_pr3
Thank you all for your help, in the end a process made the most sence.