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.
[Perspective]Can use DBRW Link from DBRW?
-
Alan Kirk
- Site Admin
- Posts: 6654
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: [Perspective]Can use DBRW Link from DBRW?
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
myimyoona
- Posts: 7
- Joined: Thu Jul 16, 2015 2:43 am
- OLAP Product: cognos TM1
- Version: 10.2.0
- Excel Version: 2007
Re: [Perspective]Can use DBRW Link from DBRW?
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.