Hi ,
I have a Active form which will be having data related to 2 cubes .
Example: Assume that i have 10 colums in the report .
8 columms belongs to one cube
2 columes belongs to other cube
i am getting the value in 8 columns , On the other 2 columes i am getting an erro "*KEY ERROR".
The 2nd cube has beed added newly into the Active form and the values are fetched using DBRW function , Intially it is working fine but now it is not.
Can any help on this issue
Regards
Ashok
Error in ACTIVE FORM
-
- Posts: 32
- Joined: Fri May 27, 2011 9:06 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- qml
- MVP
- Posts: 1096
- 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: Error in ACTIVE FORM
What are you using as the first parameter for the DBRW() function? Is it TM1RPTVIEW(), VIEW() or simply the cube name?
Also, you can use TM1Tools (available to download from this site) to help you trace your KEY_ERRs.
Also, you can use TM1Tools (available to download from this site) to help you trace your KEY_ERRs.
Kamil Arendt
-
- Posts: 32
- Joined: Fri May 27, 2011 9:06 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
Re: Error in ACTIVE FORM
We are using CUBE
-
- MVP
- Posts: 2836
- 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: Error in ACTIVE FORM
Well, unless you have a cell that has a range name of CUBE and in that cell there is either TM1RPTVIEW(), VIEW(), or a string value with the name of the cube then this isn't going to work. A DBRW function requires as it's first argument either TM1RPTVIEW(), VIEW(), or the name of a cube (or a reference to a cell that contains one of those).Acc_Moonwalk wrote:We are using CUBE