PAx not fully recalculating

Post Reply
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

PAx not fully recalculating

Post by Loki419 »

Hi Guys

I've just started with a new customer using PAx and i am seeing some unfamiliar behavior. A user slices a report and shares it with another user. The other user connects to TM1, opens the sliced report and only a portion of the cells recalculate with the others showing #Value!. Here is where it gets interesting. Highlight one of the cells with #Value!, place your cursor in the formula bar and click the green check mark to the left and that cell recalculates. Hitting F9 or rebuild sheet does not fix the issue. We're waiting to hear back from IBM but I wanted to check here to see if anyone has seen this before. I have admin rights and were are using IBM Planning Analytics 2.0

Excel is Office 365
Using IBM Cloud


Thanks
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: PAx not fully recalculating

Post by Steve Rowe »

If you are talking about DBRWs / custom report then you need to check the force recalc on f9 option in the PAx options to get f9 working. If you don't (I think) normal excel calcs take over and only cells that have a dependency that has changed will be refreshed.
Technical Director
www.infocat.co.uk
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

Re: PAx not fully recalculating

Post by Loki419 »

Steve, thank you sir !!. That seems to have eliminated the problem on my machine. I'll check with my users and see if this works for them as well. Very much appreciate your rapid response. This is my go to place for Tm1 info

Thanks again
Loki
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

Re: PAx not fully recalculating

Post by Loki419 »

Looks like my excitement was premature. Last night I made the suggested change and it worked perfect. Get into the office this morning and when hard wired to the network and hit F9 then every cell goes #VALUE!. Restarted my box and connected via wireless and hitting F9 only made some cells return values. I am therefore assuming I have a network issue so will look to get my IT talking to IBM.

If anyone has ideas about any other settings I should / should not have set in PAx I would very much appreciate your comments/insights/suggestions.
Thanks
Loki
jorelb
Posts: 71
Joined: Fri Feb 13, 2009 1:41 am
OLAP Product: IBM Planning Analytics Cloud
Version: 2.0.9 IF (2)
Excel Version: 2016

Re: PAx not fully recalculating

Post by jorelb »

Try
[Ctrl]+[Shift]+[Alt]+[F9]
See if it works
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

Re: PAx not fully recalculating

Post by Loki419 »

Unfortunately same result as hitting F9.

Another wrinkle. We have three environments in the IBM Cloud. Connecting to Test the file works perfect. Dev and Prd are the ones producing the errors.

Thanks again for all suggestions
Loki
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

Re: PAx not fully recalculating

Post by Loki419 »

Hi All

We worked with IBM and while not able to specifically identify the root cause, they rebooted the web server and that seems to have corrected everything for now. We have requested more details about the root cause but I wanted to post this follow up and say thanks again to all who jumped in to assist. If/when I get additional information I'll be sure to post.

Thanks again
Loki
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: PAx not fully recalculating

Post by Steve Rowe »

Hi Loki, Might be worth posting detailed version numbers
Technical Director
www.infocat.co.uk
Loki419
Posts: 15
Joined: Sat Dec 10, 2016 10:32 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007 2010 O365

Re: PAx not fully recalculating

Post by Loki419 »

Hi,

Here is what I found in the Help section of PAX

CORREDIST_name=IBM Planning Analytics for Excel
COI_version=COI-AW32-ML-RTM-11.0.32.6-0

IBM has indicated they need to increase the memory on the web server but still waiting for an answer regarding the root cause.

Thanks again
Loki
Post Reply