Active Reports ver 2.0.9 - data misaligned

Post Reply
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Active Reports ver 2.0.9 - data misaligned

Post by chewza »

Hi there

We are upgrading to 2.0.9 and many active reports do not seem to be working.
The first row returns data, but then the subsequent rows seem to be "mis-aligned".

So for example if the Columns are Division, Account, Cost Centre:
Row 1 returns Division1, Account1, Cost Centre1.
But then the other rows return Account1, Cost Centre 1, Division 1

Any idea why!
Really Would appreciate some help!!!

Many thx!!

Regards
Chris
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Active Reports ver 2.0.9 - data misaligned

Post by Mark RMBC »

Hi,

I have found that if the TM1RPTROW column order on the report does not follow the column order of the cube then it gets misaligned.
Appears to be a bug in later releases.

It should be noted that it does work ok on the web even if it doesn't work in excel.

If you do need to work within excel then the workaround is to make sure the TM1RPTROW columns order follow the cube order and have another set of columns (in the order you require) that reference these cube order columns. Then hide the ordered columns.

I had it in my mind that the bug had been fixed but maybe not.

If the above isn't your issue then no idea!

regards,

Mark
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Active Reports ver 2.0.9 - data misaligned

Post by chewza »

Hi Mark

Thx for your feedback. There is a fixpack which seems to address this issue. Will give it a bash and revert.

Many thx
Chris
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Active Reports ver 2.0.9 - data misaligned

Post by chewza »

applied the fix pack and worked fine.
Thx a million for your help!
This is a rather fundamental issue - pretty surprised to find it.
Post Reply