Active Form Issue

[Acc_Moonwalk]

Hi ,

I have an active form which is having huge data which need to be displayed .

After uploading the file into the system.

When i tried to open i am getting an error KEY_ERR , But when i clicke on fx icon to check the formula it is showing the data .

Is there anything that i can use in the excel to avoid this error .

For sure this error is due to large data.

waiting for your replies .

Regards
Ashok

[tomok]

Hi ,

I have an active form which is having huge data which need to be displayed .

After uploading the file into the system.

When i tried to open i am getting an error KEY_ERR , But when i clicke on fx icon to check the formula it is showing the data .

Is there anything that i can use in the excel to avoid this error .

For sure this error is due to large data.

waiting for your replies .

Regards
Ashok

Based on your question, it is obvious you are just a TM1 user, and not the developr of this report. My advice is you go back to the developer of the report and ask them to fix it.

[Acc_Moonwalk]

Hi ,

You are right i have not developed but , I am maintaince guy who will support this application . so i have to fix this .

[tomok]

You are right i have not developed but , I am maintaince guy who will support this application . so i have to fix this .

How are you going to support when you barely know how to use it? If you knew TM1 you would realize there could literally be dozens of things wrong with your report to cause a KEY_ERR. My recommendation is that you spend some time with the manuals, especially the section about Active Forms and learn how they are structured. Then read about the DBRW formula and learn the proper syntax. The KEY_ERR means you are either 1) not connected to the TM1 server in question or 2) you are not supplying the right parameters to the DBRW formula. I'm going to guess it is #2 but I would have absolutely no idea why because I've never seen your report.

[Michel Zijlema]

When i tried to open i am getting an error KEY_ERR , But when i clicke on fx icon to check the formula it is showing the data.

As Tomok mentioned there are multiple reasons that could cause a KEY_ERR message.
A typical cause for the behaviour you're describing is that the DBRW formula is referencing another DBRW formula - this could cause 'sync' errors where the outer DBRW is calculated before the inner DBRW is calculated. If you're indeed referencing the result of a DBRW in another DBRW you should change the inner DBRW function to a DBR function - this will force the inner formula to be calculated before the outer formula is calculated.

Michel