Error in ACTIVE FORM

Post Reply
Acc_Moonwalk
Posts: 32
Joined: Fri May 27, 2011 9:06 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Error in ACTIVE FORM

Post by Acc_Moonwalk »

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
User avatar
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

Post by qml »

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.
Kamil Arendt
Acc_Moonwalk
Posts: 32
Joined: Fri May 27, 2011 9:06 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Error in ACTIVE FORM

Post by Acc_Moonwalk »

We are using CUBE
tomok
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

Post by tomok »

Acc_Moonwalk wrote:We are using CUBE
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).
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply