Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/
If you want to use a formula that reads from a cube to supply an element name to another formula that reads from a cube, the first one must be a DBR, not a DBRW.The W in DBRW does not stand for "write" as some suppose, it stands for "Wide Area Network". DBRWs are read and written in batches to improve performance. Consequently if you have a DBRW formula which relies on another DBRW formula, then both will be evaluated at the same time. That means that the first one has no idea what the second one's value is at the time of calculation, which means that it doesn't know which elements to read, which means that you get a KEY_ERR error.myimyoona wrote:Hi every body i want to be studious. i can use dbrw to dbrw in perspective? why? it tm1 version 10.2.2 and excel 2010.
please expend to me.
thank a lot.Alan Kirk wrote:If you want to use a formula that reads from a cube to supply an element name to another formula that reads from a cube, the first one must be a DBR, not a DBRW.The W in DBRW does not stand for "write" as some suppose, it stands for "Wide Area Network". DBRWs are read and written in batches to improve performance. Consequently if you have a DBRW formula which relies on another DBRW formula, then both will be evaluated at the same time. That means that the first one has no idea what the second one's value is at the time of calculation, which means that it doesn't know which elements to read, which means that you get a KEY_ERR error.myimyoona wrote:Hi every body i want to be studious. i can use dbrw to dbrw in perspective? why? it tm1 version 10.2.2 and excel 2010.
please expend to me.
DBRs are read and written individually, so those are done before the DBRWs. That means that the DBR will be evaluated and return the element name to the DBRW, which can then retrieve the appropriate value.