Error :TM1-ERR-0061 [While running cognos BI reports]

[jasvarun]

Hello friends,

We are facing an issue while running report in the business insight advance. The source for the framework is a TM1 cube. The reports kept on running for 5-6 hours and in the end reports execution got failed with the attached error.

Please let me know if you have faced this kind of issue and what steps did you take to overcome.

Cheers,
Varun

[MFGF]

Hello friends,

We are facing an issue while running report in the business insight advance. The source for the framework is a TM1 cube. The reports kept on running for 5-6 hours and in the end reports execution got failed with the attached error.

Please let me know if you have faced this kind of issue and what steps did you take to overcome.

Cheers,
Varun

Hi,

The error seems to be pointing to the fact that TM1 doesn't have enough memory to process the request being sent to it. I'd take a look at how much available memory your server hosting TM1 has, and whether it's possible to either increase the memory or simplify the cube so it requires less memory.

MF.

[jasvarun]

Hi,

Thanks for the answer.

Unfortunately to re-size the cube /adding memory is not an option for now.
Is there any way where we can restrict the data in cognos bi to lets say 10,000 rows. e.g. if the user report is trying to fetch more data from TM1 cube only fist 10000 rows would appear. In this way we can provide atleast some data to the user.

Thanks for clarifying my doubt,
V

[MFGF]

Hi,

Thanks for the answer.

Unfortunately to re-size the cube /adding memory is not an option for now.
Is there any way where we can restrict the data in cognos bi to lets say 10,000 rows. e.g. if the user report is trying to fetch more data from TM1 cube only fist 10000 rows would appear. In this way we can provide atleast some data to the user.

Thanks for clarifying my doubt,
V

Hi,

TM1 isn't a row-based database, it's an in-memory OLAP technology. It loads members into memory as required and calculates the tuples it needs for whatever query you send to it. There's no concept of you saying "restrict processing to 10,000 rows" since there are no rows in play - only measures and members.

If you pick 1 member from the lowest level of each hierarchy and a single measure, in theory TM1 would need only those members and the one measure in memory to return the result. If you pick the members are from higher levels, TM1 will need to aggregate the measure values for these - presumably by loading into memory all the lower level members that belong to them, therefore using more memory...

MF.