Cube build on Windows 2003 Server

[senbi]

Hi All,

When building cubes on a Windows 2003 4 CPU dual server, it takes 2 1/2 hrs to build the cube. Out of 4 cpu's, only one cpu is running utilizing 13% of cpu usage. But I understand that the cube should be optimally built in .30 min/less. Please give your suggestions how I can improve my cube build time or if I need to change any settings in Windows/Cognos files. Thanks in advance.

Kind Regards,
Senkrish

[cognostechie]

That is a difficult thing to answer unless somebody looks at everything involved in making the cube.

Considering your CPU utilization is low, my best bet is..It is taking time to READ the data from your DB so you might want to look at your backend side/DB Server/DB tables, indexes itself.

[Darek]

There is no "optimal" build time. Sometimes it will take 5 minutes with small data, while it will take 12 hours to process 10GB. Transformer is a single CPU process, with optional separate data reader process during read from DB or flat files. Having multi/hyper-threaded CPUs allows Transformer (for some reason) to jump from one CPU to another, but it will not spread across all available.

To improve build time you can experiment with various cache settings. Read the docs.