TM1 Forum

Hi,

We are trying to copy data from source version to target version with in the same cube using TI.
For some of the cells data was not copied from source version to target version.
Here some of the cells in source version is feed by Link.we are suspecting that rules created by Link is not allowing to copy in Target version.
Could you please help me in resolving this.

we are using Performance Modeler.


Regards,
Rajesh

Hi Rajesh. The Cube View you are using as the data source for your TI needs to include rule-calculated cells. By default such cells are excluded, just as consolidations and zero values are. You can use the TI function ViewExtractSkipRuleValuesSet to set the flag appropriately.

Hi qml,

thank you for your reply.

we are using these functions in Prolog

ViewExtractSkipCalcsSet( pCube, cTempViewTo, 0 );
ViewExtractSkipRuleValuesSet( pCube, cTempViewTo, 0 );
ViewExtractSkipZeroesSet( pCube, cTempViewTo, 0 );

Regards,
Rajesh Dayaneni

Is cTempViewTo your source view?

Also, typically you would not want to include consolidations or zero values because the view can become very large and usually there is no point in copying such values. Or even a place to store them. Are you perhaps trying to copy some C-level rule-calculated values?

rajeshdayaneni wrote: ↑Thu Sep 21, 2017 2:49 pm we are using these functions in Prolog

ViewExtractSkipCalcsSet( pCube, cTempViewTo, 0 );
ViewExtractSkipRuleValuesSet( pCube, cTempViewTo, 0 );
ViewExtractSkipZeroesSet( pCube, cTempViewTo, 0 );

My oh my. And how many dimensions does the cube have? And how long does the process take?

Hi lotsaram ,

Cube has 7 dimensions and the process took 30 sec to complete.



Regards,
Rajesh Dayaneni

rajeshdayaneni wrote: ↑Fri Sep 22, 2017 6:07 am Hi lotsaram ,

Cube has 7 dimensions and the process took 30 sec to complete.

Regards,
Rajesh Dayaneni

Hello,

This seems rather unlikely and points to the fact that from and to view have been messed up or interchanged.

Hi Wim,

Thank you for your reply.

i don't think so,because our TI is able to copy data from current version to final version for some of the cells .please see the attachment.Highlighted cell is not transferring data.



Regards,
Rajesh Dayaneni

I will ask again, because it seems very important here:

Is cTempViewTo your source view?

The name suggests that this is your target (ZeroOut) view, not the source. That would explain why the ViewExtractSkip functions are not having the expected result.

Hi qml,

cTempViewTo is a target view.can i send the code written in TI Process.



Regards,
Rajesh Dayaneni

rajeshdayaneni wrote: ↑Fri Sep 22, 2017 10:26 am cTempViewTo is a target view.can i send the code written in TI Process.

While normally posting your actual code is highly encouraged (ideally in the first post of the thread), it looks to me like in this case we have painstakingly amassed enough information to conclude that you need to include rule-calculated values (but probably not zeroes or consolidations) in your source view. In other words, use the ViewExtractSkipRuleValuesSet function in the Prolog, but on your source view, not your target view.

Also, have a look at whether the source cells, if rules-calculated, are fed or not.

Hi qml/Wim,

thank you for your suggestion.

we are using
ViewExtractSkipRuleValuesSet( pCube, cTempViewFrom, 0 );

in prolog ,but still data is not copied to some of the cells in target version.
attached my TI Process code.


Regards,
Rajesh Dayaneni

Based on your skill level, as demonstrated in your posts, and the hideously complex TI code you posted I am going to go out on a limb and say you did not write this TI process. I suggest you contact the consultant who wrote this process and pay them to debug your issue. I doubt anyone here is going to be willing to give you, for free, the amount of time it's going to take to debug your problem considering how many loops you have going on. It could literally be anything.

Hi Tomok,

thanks for your suggestion.I am new to TM1.


Regards,
Rajesh Dayaneni

rajeshdayaneni wrote: ↑Fri Sep 22, 2017 10:52 am Hi qml/Wim,

thank you for your suggestion.

we are using
ViewExtractSkipRuleValuesSet( pCube, cTempViewFrom, 0 );

in prolog ,but still data is not copied to some of the cells in target version.
attached my TI Process code.


Regards,
Rajesh Dayaneni

This is a mash up of a bedrock copy process. Why not just use the bedrock process?

rajeshdayaneni wrote: ↑Fri Sep 22, 2017 9:22 am Hi Wim,

Thank you for your reply.

i don't think so,because our TI is able to copy data from current version to final version for some of the cells .please see the attachment.Highlighted cell is not transferring data.



Regards,
Rajesh Dayaneni

You can test the work of your code yourself by asking the following questions and finding the answers to them!
You check your rule on Final Version(maybe uses STET)?
Your ti process uses CellIsUpdateable() on final version?
You check your temp view uses Customer DC code?
and etc