Help on Active Form

Post Reply
Jorge Rachid
Posts: 46
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 » Tue Oct 10, 2017 3:13 pm

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 206 times
ActiveForm2.jpg
ActiveForm2.jpg (131.62 KiB) Viewed 206 times

User avatar
gtonkin
MVP
Posts: 536
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Help on Active Form

Post by gtonkin » Tue Oct 10, 2017 3:57 pm

Please post the formulas for Test1 and Test2.
Do they reference the cube or the TM1RptView cell?

Jorge Rachid
Posts: 46
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 » Tue Oct 10, 2017 4:58 pm

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 197 times
Img2.jpg
Img2.jpg (131.56 KiB) Viewed 197 times

User avatar
tomok
MVP
Posts: 2357
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 » Tue Oct 10, 2017 5:52 pm

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: 46
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 » Tue Oct 10, 2017 6:23 pm

Hi, the function offset solved the problem.

Thanks a lot for helping me.

Regards,

JR

Post Reply