Rules Created by Links are not allowing us to copy data from source version to target version
-
- 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
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
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
- 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
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
-
- 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
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
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
- 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
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?
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
-
- MVP
- Posts: 3667
- 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
My oh my. And how many dimensions does the cube have? And how long does the process take?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 );
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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
Hi lotsaram ,
Cube has 7 dimensions and the process took 30 sec to complete.
Regards,
Rajesh Dayaneni
Cube has 7 dimensions and the process took 30 sec to complete.
Regards,
Rajesh Dayaneni
-
- MVP
- Posts: 3128
- 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
Hello,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
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
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
-
- 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
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
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 (40.17 KiB) Viewed 8944 times
- 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
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.
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
-
- 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
Hi qml,
cTempViewTo is a target view.can i send the code written in TI Process.
Regards,
Rajesh Dayaneni
cTempViewTo is a target view.can i send the code written in TI Process.
Regards,
Rajesh Dayaneni
- 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
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.rajeshdayaneni wrote: ↑Fri Sep 22, 2017 10:26 am cTempViewTo is a target view.can i send the code written in TI Process.
Kamil Arendt
-
- MVP
- Posts: 3128
- 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
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
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
-
- 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
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
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 221 times
-
- Data.txt
- (17.73 KiB) Downloaded 232 times
-
- Prolog.txt
- (30.87 KiB) Downloaded 239 times
-
- MVP
- Posts: 2832
- 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
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.
-
- 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
Hi Tomok,
thanks for your suggestion.I am new to TM1.
Regards,
Rajesh Dayaneni
thanks for your suggestion.I am new to TM1.
Regards,
Rajesh Dayaneni
-
- MVP
- Posts: 3667
- 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
This is a mash up of a bedrock copy process. Why not just use the bedrock process?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
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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
You can test the work of your code yourself by asking the following questions and finding the answers to them!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 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