QR Reports - Multiple Server - Java CPU not Release

Post Reply
dharav9
Posts: 34
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

QR Reports - Multiple Server - Java CPU not Release

Post by dharav9 » Fri Feb 08, 2019 5:19 am

Hi, All

We found increase in CPU spike after rendering quick reports from TWO different tm1 cube server, where both views having 2 same dimension name but different elements. E.g.: One cube server view has dimension called TIME having elements Year=>Q1=>Jan,Feb,Mar. Second, cube server view has dimension TIME having elements FY2019=>JAN FY2019, FEB FY2019, Mar FY2019 till Dec FY2019.
When we rendering quick reports from two different tm1 cube server, where both view does not have any common dimension name involve or having same name and same elements then QR renders flawless and no CPU spike observed.

In TM1 server log (In cube server where a view render having same dimension as extracted QR from different cube server), we receive the error called "TM1.MDX.Interface TM1 BadTuple Position Error".

QR renders the view even though it throws an error but performance lag is quite long. instead of 12 seconds, it takes 2-3 minutes.

Based on my Testing experience, it seems once we extract the quick report, all information must be hold somewhere in cache memory. When we click on different view having same dimension name but different elements in another cube server, it tries to re-call cache memory and tries to find out same elements. When it does not found in the memory cache, it must be doing following.
1) Throws bad tuple error - as elements are not same
2) when it does not found it from cache memory - it tries to get information from the server and retrieves view. This process may lead to performance lag.

May I know is there any feature to release the cache on client (PAX)? EXCEPT CLEAR CACHE in options=>IBM=> Clear Cache

This issue has been logged with IBM (PMR).

Thank You
Dharav

dharav9
Posts: 34
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Re: QR Reports - Multiple Server - Java CPU not Release

Post by dharav9 » Fri Feb 08, 2019 4:45 pm

Hi, All

Its resolved.

CognosOfficeAutomationObject.ClearCache() BEFORE going to next worksheet.

Thank You

Dharav

Post Reply