Help on Active Form

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Help on Active Form

Post by Jorge Rachid »

Hi everyone,

I have an active form and I bring the number on another excel cells, as the image "ActiveForm1". Until here it is ok. I bring the number 900 and 800.

But after I use "recalculate" I got "#REF" (image "ActiveForm2") on the cell that brings the number 800 of active form. Only the first row of the cube it is working.

Does anyone have any idea of what is happening?

Thanks in advance.

JR
Attachments
ActiveForm1.jpg
ActiveForm1.jpg (143.27 KiB) Viewed 2992 times
ActiveForm2.jpg
ActiveForm2.jpg (131.62 KiB) Viewed 2992 times
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Help on Active Form

Post by gtonkin »

Please post the formulas for Test1 and Test2.
Do they reference the cube or the TM1RptView cell?
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Help on Active Form

Post by Jorge Rachid »

Hi, find attached the images.

The cell refer to the active form, where is the DBRW rule.

Thanks.
Attachments
Img1.jpg
Img1.jpg (124.79 KiB) Viewed 2983 times
Img2.jpg
Img2.jpg (131.56 KiB) Viewed 2983 times
tomok
MVP
Posts: 2831
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: Help on Active Form

Post by tomok »

You can't directly reference a cell that is part of the active form because the active form rows are deleted and rebuilt each time you rebuild. This will kill any formula that directly references any part of the active form. Look into the OFFSET and/or INDIRECT formulas in Excel. This should solve your problem.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Help on Active Form

Post by Jorge Rachid »

Hi, the function offset solved the problem.

Thanks a lot for helping me.

Regards,

JR
Post Reply