Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: goding on 31 Jul 2007 05:39:58 PM

Title: Multifile Cubes-How to be notified that there is a new MDP being created
Post by: goding on 31 Jul 2007 05:39:58 PM
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
Title: Re: Multifile Cubes-How to be notified that there is a new MDP being created
Post by: COGNOiSe administrator on 24 Aug 2007 12:43:35 PM
Copy cubeName*.md? doesn't work for you?
Text only | Text with Images