Page 1 of 1

A wrapper process around Bedrock export, clear, import data

Posted: Sun Feb 02, 2025 1:20 am
by Wim Gielis
Hello all,

Here is a blog article on a new wrapper process around key data manipulations with Bedrock:
  • Exporting data
  • Clearing data
  • Importing data
  • Copying data
This can be done for any selection of cubes, allowing for a Bedrock filter of the dimensions AND allowing for 5 dimensions to be sliced.
For instance import data from text files into 3 cubes on 4 years and 12 months and 2 scenarios.

The typical use case is turning rules-calculated values into hard values by exporting to flat file, clearing stetting cells and importing again.
Many other use cases can be given too.

Email notifications of where you are in the chain can be triggered.

https://community.ibm.com/community/use ... out-coding

Reply below or in the PA community thread what you think of this process and in case of questions/errors. Have fun !

Re: A wrapper process around Bedrock export, clear, import data

Posted: Mon Feb 03, 2025 1:38 am
by Wim Gielis
Here are the processes, that accompany the text in the blog post.
WG_CUBE_lookup_dimensions_in_cube.txt
(21.75 KiB) Downloaded 413 times
TECH_sliced cube export clear import.txt
(112.59 KiB) Downloaded 428 times

Re: A wrapper process around Bedrock export, clear, import data

Posted: Mon Feb 03, 2025 8:57 am
by gtonkin
Thanks for sharing Wim!