Active Form showing wrong value

Post Reply
ofintm1
Posts: 8
Joined: Tue Jun 21, 2016 4:26 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Active Form showing wrong value

Post by ofintm1 » Thu Aug 02, 2018 6:27 pm

Dear experts,

I have a general active form budget template with a field to enter a margin. The margin is then multiplied by a volume to generate an income figure.

If the margin is say 3% and I type in 10% on top of the DBRW formula and then recalculate with shift f9 or f9 the margin changes back from 10% to 3%. Despite this it shows 10% when looking in the cube viewer immediately after entering it.

Is this expected behaviour? The only way the DBRW brings back the new 10% margin is if I rebuild the active form, which is a lot slower than a recalc. It is as if 3% is the cached value until a rebuild?
Thanks
Oli

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

Re: Active Form showing wrong value

Post by gtonkin » Sat Aug 04, 2018 2:42 pm

What does it show when you rebuild the AF with Alt+F9?

Post Reply