hints for the performance oriented issues.

Post Reply
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

hints for the performance oriented issues.

Post 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.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: hints for the performance oriented issues.

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: hints for the performance oriented issues.

Post 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.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: hints for the performance oriented issues.

Post 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
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: hints for the performance oriented issues.

Post 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.
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: hints for the performance oriented issues.

Post by Christopher Kernahan »

Thanks Alan, I just spat my beer all over my laptop and now it's hungover too.
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Re: hints for the performance oriented issues.

Post by viswaraju »

thank you for your support.
Post Reply