September 2024 Product Adoption Tip: Copy Dimension Members Between Cubes

CSP Discussions
1

Are you in the middle of creating a new cube and are hoping to copy the member structure from a dimension in an existing cube to your new cube without having to manually re-create them?

This is possible using the export dimension along with the import dimension process steps in process manager.

To achieve this:

  1. Run an export dimension on the dimension from the original cube you are trying to copy from. Ensure that the file is saved as .txt format, the “Include header line in file” is selected, and TAB is selected as the Delimiter

image
image806×308 24.1 KB

  1. Run an import dimension process in your new cube. In the source tab of this process step, choose the file exported from step 1

image
image777×247 18.8 KB

image
image959×213 18 KB

2

Surely make life easy :slight_smile:.

3

There is so much flexibility with Prophix to stop duplication of jobs - yet another example, thank you.

4

The Prophix Process is very easy to use.

5

I have done this. Highly recommend.

6

Thanks for sharing!!

7

I have done this, very easy and helpful

8

been a while, but I’m going to have to try this again

9

This makes the process easier.

10

I will have to use this next time. Thank you