Sample Code to Copy Data to another cube in another model

[chewzauk]

Hi Guys

Does anyone perhaps have sample code to copy data from a cube in one model to a cube in another model?
Kind of like a replication thing...as far as possible anyway.

Many thx
Chris

[MariusWirtz]

Hi @chewzauk,

it's quite simple:

• connect to instance A
• Use the execute_mdx function or execute_view to read data from cube C.
• connect to instance B
• Use the write function to write to cube C

Things to consider

• parallelization
• transformations before writing to B
• use_ti=True in write function to increase performance
• skip_non_updateable=True in write function
• synchronize dimensions first before attempting to write

[chewzauk]

Thx Marius, much appreciated. Can you provide any advice on how to sync dimensions...?

…

On Thu, 26 Jan 2023, 12:46 Marius Wirtz, ***@***.***> wrote: Hi @chewzauk <https://github.com/chewzauk>, it's quite simple: - connect to instance A - Use the execute_mdx function or execute_view to read data from cube C. - connect to instance B - Use the write function to write to cube C Things to consider - parallelization - transformations before writing to B - use_ti=True in write function to increase performance - skip_non_updateable=True in write function - synchronize dimensions first before attempting to write — Reply to this email directly, view it on GitHub <#850 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5L67LEJ3KU57EYRGRYFTUDWUJW2PANCNFSM6AAAAAAUB3QPVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[MariusWirtz]

Sure:

• connect to instance A
• read the dimension D
• connect to instance B
• write/update the dimension D
• make sure to consider attributes values as well

[chewzauk]

Thanks!

…

On Thu, 26 Jan 2023, 13:02 Marius Wirtz, ***@***.***> wrote: Sure: - connect to instance A - read the dimension D - connect to instance B - write/update the dimension D - make sure to consider attributes values as well — Reply to this email directly, view it on GitHub <#850 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5L67LBQXNTSLQYBU64KO4LWUJYUTANCNFSM6AAAAAAUB3QPVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>