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

 

Multifile Cubes-How to be notified that there is a new MDP being created

Started by goding, 31 Jul 2007 05:39:58 PM

Previous topic - Next topic

goding

Greetings,
     Many of our cubes take more than 2GB so we are using the  MultiFileCubeThreshold option in Trnsfrmr.Ini to create partitions. The challenge with this is that I have a server to build the cubes on (Server 02) and a different server on which Cognos 8 runs and serves up the data for the cubes to users (Server 01).
     We have in a production process one BAT file that builds the cube and a second BAT file that copies the cube files from  02 to 01 and then runs cubeswap. However, when a new partition (MDP) file is created, the BAT file will not know of it and not copy it to server 01. Then, after the cubeswap, the data source connection will fail when a user tries to access the cube.
     Any ideas on how to automate this so that as the cube grows, the BAT file would be able to be updated automatically or worst case, have me notified?
     Thanks in advance for any ideas.
Regards,
Gene

COGNOiSe administrator