Transferring and Summing Data from cube to another

[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

[tomok]

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.

[ardi]

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.

[simon_pr3]

Invart1 has a total sum.

[simon_pr3]

Thank you all for your help, in the end a process made the most sence.