Rules Created by Links are not allowing us to copy data from source version to target version

Post Reply
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

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
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by qml »

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.
Kamil Arendt
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

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
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by qml »

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?
Kamil Arendt
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: Rules Created by Links are not allowing us to copy data from source version to target version

Post by lotsaram »

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?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

Hi lotsaram ,

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



Regards,
Rajesh Dayaneni
Wim Gielis
MVP
Posts: 3103
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: Rules Created by Links are not allowing us to copy data from source version to target version

Post by Wim Gielis »

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.
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
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

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
Attachments
Data_Transfer.JPG
Data_Transfer.JPG (40.17 KiB) Viewed 8596 times
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by qml »

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.
Kamil Arendt
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

Hi qml,

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



Regards,
Rajesh Dayaneni
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by qml »

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.
Kamil Arendt
Wim Gielis
MVP
Posts: 3103
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: Rules Created by Links are not allowing us to copy data from source version to target version

Post by Wim Gielis »

Also, have a look at whether the source cells, if rules-calculated, are fed or not.
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
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

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
Attachments
Epilog.txt
(9.27 KiB) Downloaded 196 times
Data.txt
(17.73 KiB) Downloaded 211 times
Prolog.txt
(30.87 KiB) Downloaded 217 times
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by rajeshdayaneni »

Hi Tomok,

thanks for your suggestion.I am new to TM1.


Regards,
Rajesh Dayaneni
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: Rules Created by Links are not allowing us to copy data from source version to target version

Post by lotsaram »

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?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Post by Drg »

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
Post Reply