TM1 Forum

Hello All,
I am trying to create a geneal TI process to copy data between identical cubes (same set of dimensions in the same order). For that in prolog I created 'View' and using it as datasource. when I ran the process, it failed because of the dimension mismatch.
To figure out the problem I 'asciiout' all the variables and found the order of the dimensions in my source view is all messed up.
The source cube is not optimized by cube optimizer(meaning I didn't reorder the dimensions). The order of variables from the source view doesn't make any sense. The cube has 7 dimensions(DIM1, DIM2,DIM3,DIM4,DIM5,DIM6,DIM7). The asciiout files shows me in the datasource dimensions in the order DIM1, DIM4, DIM3, 'value',DIM2,DIM6,DIM7.

If I hardcode the view instead of creating the view in the prolog, it works just fine. I just hate to create one process for each cube that we need to clone. Am i missing something, we are using 10.1.1 without the recent fixpack(3/13/2013)

Thanks for your help

Have you tried doing a search for this? I think you'll find this is a re-occuring issue and there have been many posts on it.

For example try: http://www.tm1forum.com/viewtopic.php?f=18&t=5284

Jim,
Thanks for your quick reply. Yes I already checked out that post, they have issues when the source cube dimensions are reordered with optimizer. In my case I didn't do anything like that, still it is not working.

If you read the thread it tells you how you can change the dimension to variable order to solve your problem,

Jim.

Sorry Jim, I should have paid more attention. I edited the .pro file and it works like magic. I am newbie to TM1 and still learning, so it didn't hit me the first time I read the post. Thanks for your help issue resolved.
Arul