If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cube Build Performance in 8.4 transformer

Started by snadgir30, 05 Feb 2010 09:54:12 AM

Previous topic - Next topic

snadgir30

Hi Gurus,

We are upgrading cubes from 7.4 to 8.4.

Test build in 8.4 enviornment takes more time compared to cube build time in 7.4.

Usage of below performance tuning parameters is increasing cube build time.
1.MaxTransactionNum - 800000
2.WorkFileSortBufferSize -9000000
3.WriteCacheSize -65536 MB

Cube build time in 8.4 approaches (even then 15-20 mins more) to 7.3 build time only when all of above the parameter values are kept default including WorkFileMaxSize =1500000000.
Can any one tell me what is the impact of these parameters on cube building performance?
and when to use it?

I have referred to cognos 8.4 Transformer documentation - Chapter 9 for this.
Transformer is installed on window server 2003.

Any help/pointers in this regard are highly appreciated.

Thanking you in advance.

Cheers
snadgir30



nmcdermaid

Transformer 8 automatically applies a group by to your queries where it can.

It would be best to take a look at the logs between environments and identofy which components are taking longer. For example you may find that for every query the OPRN phase takes longer but the READ phase is shorter.

Or you may find something totally different. Compare and post back.