Page 1 of 1

hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 1:48 am
by viswaraju
hi,
i have just finished my training on TM1,now i am into project. The project deal was to rectify the performance orientd issues like

1)It takes lot of time to open a view.
2)System gets hangover
3)Lot of dataentry, few like this.
The model is budgeting.
What i am trying to do is looking after feeders, idea about changing the model and.....


thanks and reagrds.

cognos TM1 9.5
excel 2007.
XP opsys.

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 2:06 am
by Alan Kirk
viswaraju wrote:hi,
i have just finished my training on TM1,now i am into project. The project deal was to rectify the performance orientd issues like

1)It takes lot of time to open a view.
Use fewer cells. Zero suppress. Use dynamic subsets to limit the views to the relevant data only.
viswaraju wrote:2)System gets hangover
Don't let the system drink as much each night. Ensure that it eats a meal with its beer.
viswaraju wrote:3)Lot of dataentry, few like this.
The model is budgeting.
Worth testing whether a multi-cube /micro-cube approach (separating input and output) would improve performance. This will vary according to the specific version that you deploy.

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 2:08 am
by Gregor Koch
This won't be really helpful but I just can't keep myself from saying:
I like issue 2) and proves yet again that alcohol won't improve performance.
Maybe you should introduce Random Breath Tests.

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 2:13 am
by Alan Kirk
Gregor Koch wrote:This won't be really helpful but I just can't keep myself from saying:
I like issue 2) and proves yet again that alcohol won't improve performance.
Maybe you should introduce Random Breath Tests.
Sorry, I beat you to that one. :D

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 7:23 am
by lotsaram
viswaraju wrote:hi,
i have just finished my training on TM1,now i am into project. The project deal was to rectify the performance orientd issues like

1)It takes lot of time to open a view.
2)System gets hangover
3)Lot of dataentry, few like this.
The model is budgeting.
What i am trying to do is looking after feeders, idea about changing the model and.....


thanks and reagrds.

cognos TM1 9.5
excel 2007.
XP opsys.
If you have just finished your training on TM1 then I hope you have someone (or preferably someones) with some significant experience as sorting out performance issues is an area where experience counts.

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 9:04 am
by Christopher Kernahan
Thanks Alan, I just spat my beer all over my laptop and now it's hungover too.

Re: hints for the performance oriented issues.

Posted: Wed Mar 23, 2011 9:44 am
by viswaraju
thank you for your support.