TM1 Forum

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

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.

We are using CUBE

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).