TI Process- View as source- order of Dimension issue

[arulvarman]

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

[jim wood]

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.

[jim wood]

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

[arulvarman]

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.

[jim wood]

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

Jim.

[arulvarman]

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