Hi, I am attempting to transfer data from cube with 2 dimensions: Product, Amount into cube with one extra dimension: Months. I know how to do this, but I was told there is another way using sub-process. I would like to try that but dont know exactly how. I would appreciate any pointers.
For more info:
Source Cube: 2 Dimensions: Product, Amount
Target Cube: 3 Dimensions: Product, Months, Amount
I am attempting to transfer data about Amount from Source Cube to Target Cube using Main Process and Sub-process and I am not interested in any other solutions to this problem at this time. Thanks.
Using subprocess to load data between cubes with different number of dimensions
- Elessar
- Community Contributor
- Posts: 331
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Using subprocess to load data between cubes with different number of dimensions
You are stubborn! =)
Only one way comes to mind:
Subprocess - copies one month
Process - has "Month" dimension as a datasource, and "RunProcess" Subproecss in Metadata tab
Compared to all examples described in previous topic:
Only one way comes to mind:
Subprocess - copies one month
Process - has "Month" dimension as a datasource, and "RunProcess" Subproecss in Metadata tab
Compared to all examples described in previous topic:
- If you have large data volumes, you can parallel this. But ensure that you have 12 CPU cores for this.
- If not, it's better to use while or cellproportionalspread
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 47
- Joined: Sun Jan 24, 2021 5:55 pm
- OLAP Product: IBM Planning analytics
- Version: 2.0.9.3
- Excel Version: 2019
Re: Using subprocess to load data between cubes with different number of dimensions
Ahh, desperation, stubbornness, one thing leads to another... Anyway thanks for the reply.
So if I understand this, I should write subprocess with CellGetN using the Source Cube as Source to get the Amount.
And then use the Main process using Months as Source to do...what exactly besides running the Subprocess in the metadata?
So if I understand this, I should write subprocess with CellGetN using the Source Cube as Source to get the Amount.
And then use the Main process using Months as Source to do...what exactly besides running the Subprocess in the metadata?
- Elessar
- Community Contributor
- Posts: 331
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Using subprocess to load data between cubes with different number of dimensions
- no, the subprocess uses the Source cube as a datasource. And does CellPutN to the target cube to one month (The Month should be specified in parameter "pMonth")
- nothing. The main process here replaces the while loop. Running a subprocess in a "metadata" tab means that the subprocess will be run for each record of a data source (in our example - for each month).
The month should be passed through subprocess "pMonth" parameter
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 47
- Joined: Sun Jan 24, 2021 5:55 pm
- OLAP Product: IBM Planning analytics
- Version: 2.0.9.3
- Excel Version: 2019
Re: Using subprocess to load data between cubes with different number of dimensions
It worked, Thanks a lot for the patience