A wrapper process around Bedrock export, clear, import data

[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 !

[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 131 times

TECH_sliced cube export clear import.txt

(112.59 KiB) Downloaded 122 times

[gtonkin]

Thanks for sharing Wim!