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 » Tue Jan 08, 2019 9:27 pm

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: 1836
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: PAx not fully recalculating

Post by Steve Rowe » Tue Jan 08, 2019 10:05 pm

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.

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 » Tue Jan 08, 2019 11:56 pm

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 » Wed Jan 09, 2019 2:16 pm

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: 62
Joined: Fri Feb 13, 2009 1:41 am
OLAP Product: IBM Planning Analytics Cloud
Version: 2.0.5
Excel Version: 2013 - 2016

Re: PAx not fully recalculating

Post by jorelb » Wed Jan 09, 2019 3:16 pm

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 » Wed Jan 09, 2019 3:25 pm

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 » Thu Jan 10, 2019 6:05 pm

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: 1836
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: PAx not fully recalculating

Post by Steve Rowe » Fri Jan 11, 2019 9:32 am

Hi Loki, Might be worth posting detailed version numbers

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 » Fri Jan 11, 2019 9:23 pm

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