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
Active Reports ver 2.0.9 - data misaligned
-
- 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
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
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
Re: Active Reports ver 2.0.9 - data misaligned
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
Thx for your feedback. There is a fixpack which seems to address this issue. Will give it a bash and revert.
Many thx
Chris
Re: Active Reports ver 2.0.9 - data misaligned
applied the fix pack and worked fine.
Thx a million for your help!
This is a rather fundamental issue - pretty surprised to find it.
Thx a million for your help!
This is a rather fundamental issue - pretty surprised to find it.