TM1 Forum

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

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

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

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