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

Post Reply
rajeshdayaneni
Posts: 15
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 » Thu Sep 21, 2017 12:06 pm

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: 1042
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1
Version: 10.2.2
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 » Thu Sep 21, 2017 2:21 pm

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: 15
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 » Thu Sep 21, 2017 2:49 pm

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: 1042
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1
Version: 10.2.2
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 » Thu Sep 21, 2017 2:54 pm

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: 2998
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

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

Post by lotsaram » Thu Sep 21, 2017 6:22 pm

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: 15
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 » Fri Sep 22, 2017 6:07 am

Hi lotsaram ,

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



Regards,
Rajesh Dayaneni

Wim Gielis
MVP
Posts: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
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 » Fri Sep 22, 2017 6:36 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

rajeshdayaneni
Posts: 15
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 » 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
Attachments
Data_Transfer.JPG
Data_Transfer.JPG (40.17 KiB) Viewed 327 times

User avatar
qml
MVP
Posts: 1042
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1
Version: 10.2.2
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 » Fri Sep 22, 2017 10:07 am

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: 15
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 » Fri Sep 22, 2017 10:26 am

Hi qml,

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



Regards,
Rajesh Dayaneni

User avatar
qml
MVP
Posts: 1042
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1
Version: 10.2.2
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 » Fri Sep 22, 2017 10:34 am

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: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
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 » Fri Sep 22, 2017 10:37 am

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

rajeshdayaneni
Posts: 15
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 » 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
Attachments
Epilog.txt
(9.27 KiB) Downloaded 9 times
Data.txt
(17.73 KiB) Downloaded 11 times
Prolog.txt
(30.87 KiB) Downloaded 14 times

User avatar
tomok
MVP
Posts: 2335
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 » Fri Sep 22, 2017 1:01 pm

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.

rajeshdayaneni
Posts: 15
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 » Fri Sep 22, 2017 1:11 pm

Hi Tomok,

thanks for your suggestion.I am new to TM1.


Regards,
Rajesh Dayaneni

lotsaram
MVP
Posts: 2998
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

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

Post by lotsaram » Fri Sep 22, 2017 1:53 pm

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
Posts: 62
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 » Mon Sep 25, 2017 7:19 am

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