Hi all,
I am building a cube (using architect as a datasource) in which the source table has nearly 5 million records. The number of dimensions used are 16 and the measures are 12.
All the dimension label,description,short name are getting refreshed when the categories are generated.
When i start the cube build, the transformer model hangs inbetween after processing certain number of records.
For eg, suppose there are 5090999 records the build is stopping at different positions say , 1860000 and at 3000333
There is no error messages also.
Some times the cube build is working fine and some time it is not.
I have made the readcachesize and the writecachesize to 32768 (32M) also but still facing the same problem. The temporary directory has considerable space. I dont know where exactly the problem is. Can anyone help me in sorting out this issue.
The problem is happening in the production system. Any quick response or suggestion will be greatly appreciated.
Thanks in advance.
Regards
Vivekh
I am building a cube (using architect as a datasource) in which the source table has nearly 5 million records. The number of dimensions used are 16 and the measures are 12.
All the dimension label,description,short name are getting refreshed when the categories are generated.
When i start the cube build, the transformer model hangs inbetween after processing certain number of records.
For eg, suppose there are 5090999 records the build is stopping at different positions say , 1860000 and at 3000333
There is no error messages also.
Some times the cube build is working fine and some time it is not.
I have made the readcachesize and the writecachesize to 32768 (32M) also but still facing the same problem. The temporary directory has considerable space. I dont know where exactly the problem is. Can anyone help me in sorting out this issue.
The problem is happening in the production system. Any quick response or suggestion will be greatly appreciated.
Thanks in advance.
Regards
Vivekh