Issue on PAX 44

Post Reply
Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Issue on PAX 44

Post by Bhavana » Thu Jun 25, 2020 12:21 pm

Hi Team,

User is unable to see servers under Open/Publish icons on IBM planning analytics for excel.

We tried resetting the IBM Cognos connection and also reinstalled PAX 44 twice but still issue persists.

The same set of servers are visible from our end but only causing issue with that user. Please suggest me if I can test any other methods to resolve this issue.

ascheevel
Community Contributor
Posts: 164
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Issue on PAX 44

Post by ascheevel » Thu Jun 25, 2020 12:48 pm

Have you confirmed the user can actually connect to TM1 server in PAX? Did you check the connection URLs and test the connections in the user's PAX options?

Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Re: Issue on PAX 44

Post by Bhavana » Thu Jun 25, 2020 1:10 pm

Yes user can able to connect to the paw URL and connections got succeeded as well.

It shows complete blank when user click on Open icon on PAX

ascheevel
Community Contributor
Posts: 164
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Issue on PAX 44

Post by ascheevel » Thu Jun 25, 2020 2:54 pm

Bhavana wrote:
Thu Jun 25, 2020 1:10 pm
It shows complete blank when user click on Open icon on PAX
Do they have any items to choose from in the dropdown "Select an IBM Connection..."? Are there any cubes visible in their task pane after establishing a connection?

User avatar
Steve Rowe
Site Admin
Posts: 2057
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Issue on PAX 44

Post by Steve Rowe » Thu Jun 25, 2020 3:19 pm

Isn't this the issue that happens if compatibility mode in the Excel options is not set (or unset can't remember which way round it needs to be!)

ascheevel
Community Contributor
Posts: 164
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Issue on PAX 44

Post by ascheevel » Thu Jun 25, 2020 3:23 pm

Not seeing cubes in the task pane is related to that issue, selecting "Optimize for Compatibility" fixes it. I wasn't able to replicate the open dialog with servers not visible when switching to "Optimize for best appearance", but it could be causing OP's issue.

Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Re: Issue on PAX 44

Post by Bhavana » Thu Jun 25, 2020 4:27 pm

Yes correct .. Optimize for compatibility is set when the task is blank. As a pre requisite we already set this option on the users machine.

But if we try to change to optimise for best apperance user will face blank task pane issue

Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Re: Issue on PAX 44

Post by Bhavana » Thu Jun 25, 2020 4:38 pm

Screenshot_20200625-220614__01.jpg
Screenshot of PAX
Screenshot_20200625-220614__01.jpg (413.11 KiB) Viewed 419 times
Have attached the screenshot from users machine

ascheevel
Community Contributor
Posts: 164
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Issue on PAX 44

Post by ascheevel » Thu Jun 25, 2020 5:09 pm

I see QA in the connection name. Have you confirmed the user is in the users list for the QA PAX environment? You could try having them log in through PAW in browser and see if they're able to get in. User list in PAW is different than }Clients dim on TM1 server.

Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Re: Issue on PAX 44

Post by Bhavana » Thu Jun 25, 2020 5:18 pm

Yes have checked the role of the user on QA PAW, he is having Analyst Role & also he can able to login into PAW from browser. Interesting part is user can able to view all kind of reports on PAX using qa pax connection the only issue is inside Open icon the server's list is missing

Also we have this PAX installed on Citrix servers where he can see the list under Open icon but in his local machine list is missing. I am not sure if something is wrong from his machine

ascheevel
Community Contributor
Posts: 164
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Issue on PAX 44

Post by ascheevel » Thu Jun 25, 2020 5:26 pm

Did you have the user enable logging and pull the PAX log files?

Bhavana
Posts: 10
Joined: Mon Jun 22, 2020 9:50 pm
OLAP Product: Planing Analytics
Version: 2.0.9
Excel Version: 32 bit

Re: Issue on PAX 44

Post by Bhavana » Wed Jul 08, 2020 10:53 am

We have raised PMR & IBM confirmed that this is due to network issue on user's machine. Hence we closed this case. As a workaround user is trying to access PAX via Citrix portal

Post Reply