Uploading data from source cube to target cube with the source cube bigger in dimensionality

Post Reply
i.iescone
Posts: 2
Joined: Sun Jan 15, 2023 5:24 pm
OLAP Product: TM1
Version: 2.0.9.12
Excel Version: excel365

Uploading data from source cube to target cube with the source cube bigger in dimensionality

Post by i.iescone »

Hello everyone!

I am a starter in TI processes and I am now stuck :(
The goal is to copy data in two unique cubes that differ in two dimensions.
Aftern running the process, the message that occurs is: 'Wrong Number of Dimension Elements'.

What I think might be the problem is this difference in dimensionality, however after researching, I do not have the solution yet.
Is there anything which allows to skip the read of certain dimensions in the data source? Or in general what is the logic to follow in this cases?

However the problem can be something else! I'd be glad to get in touch with more experienced people :)
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Uploading data from source cube to target cube with the source cube bigger in dimensionality

Post by Wim Gielis »

Please post your code.

In the Data tab of the process, consider using the CellIncrementN function. Like that, you can accumulate data in the target cube with its 2 dimensions less.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
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: Uploading data from source cube to target cube with the source cube bigger in dimensionality

Post by Elessar »

If you are using the Architect TI process constructor and not writing code from scratch, you should select "Element" role only for the variables matching your target cube's elements + Data. The other variables (which are in source cube and are not in target cube) should be "Other". Also make sure you've selected "Accumulate values".
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Uploading data from source cube to target cube with the source cube bigger in dimensionality

Post by lotsaram »

There is a bedrock process which can do this task without writing any code. }bedrock.cube.data.copy.intercube
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply