Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => Automation => Topic started by: davidsoc on 19 Sep 2005 08:40:51 AM

Title: Cognos 8 Automation
Post by: davidsoc on 19 Sep 2005 08:40:51 AM
Has anyone seen enough of Cognos 8 to know if there is any OLAP cube build automation built in?

By that i mean, back-up, build, verify, move to production etc. We are looking to develop this using a macro supplied on Cognos SupportLink but do not want to put too much effort into if we are upgrading in 6 months anyway.

Thanks for any help!

Chris
Title: Re: Cognos 8 Automation
Post by: sir_jeroen on 19 Sep 2005 05:29:45 PM
Have you looked on Cognos Support... There's already something there about series 8.
Title: Re: Cognos 8 Automation
Post by: davidsoc on 20 Sep 2005 02:51:51 AM
I've been looking for product documentation etc but can't find anything in the support area... can you point me in the right direction?

Thanks

Chris
Title: Re: Cognos 8 Automation
Post by: sir_jeroen on 20 Sep 2005 03:37:27 AM
Sorry.. but the Series 8 SDK Knowledge base is still empty :S
Sorry
Title: Re: Cognos 8 Automation
Post by: Darek on 27 Sep 2005 04:43:39 PM
You'll be using Series7 Transformer to build the cubes for Series8. Call it a vision if you'd like.  ::)
Title: Re: Cognos 8 Automation
Post by: Rozeta on 10 May 2008 01:24:41 PM
Hi Guys,

We are using Tranformer 8.3 to create cubes in Cognos Connection, does and of you know if we are still able to use Cognos Script 7.4 to automate the process of build cube, archive, copy,...

Thanks in advance
Rose
Title: Re: Cognos 8 Automation
Post by: biejorrun on 19 May 2008 06:14:36 AM
We use cubeSwap in Cognos8. I automated it thanks to a document on Cognos Support, right here: http://support.cognos.com/supported/tti/public/docs/cognos_pp_infrastructure_managing_powercubes_%5Bcubeswap%5D.zip?lid=cognos_pp_infrastructure_managing_powercubes_%5Bcubeswap%5D
Title: Re: Cognos 8 Automation
Post by: rblanquez on 19 May 2008 06:41:21 AM
Hello,

If you use Transformer 7.4, you can get it with Cognos Script Macro.
If you use Transformer 8.3, you need an MDL script, but this script allows you to generate the cube, but what happens if you need to create custom view associated to user class?
Title: Re: Cognos 8 Automation
Post by: Memphis on 04 Nov 2011 11:33:57 PM
Quote from: davidsoc on 19 Sep 2005 08:40:51 AM
Has anyone seen enough of Cognos 8 to know if there is any OLAP cube build automation built in?

By that i mean, back-up, build, verify, move to production etc. We are looking to develop this using a macro supplied on Cognos SupportLink but do not want to put too much effort into if we are upgrading in 6 months anyway.

Thanks for any help!

Chris

hi, i never seen OLAP cube build automation but what i know i heard there are 2 utilities available for Cognos 8 Cube automation.

a) CubeSwap Utility to swap the old and new cube
b) pcConn Utility which updates the Cube Data souce connection to the new cube.

Please let me know, which one is the best way to refresh the Cube in Cognos 8.3 environment.
Title: Re: Cognos 8 Automation
Post by: nmcdermaid on 15 Feb 2012 03:48:25 AM
Version 8.4 of Transformer contains something called 'deployments' which automatically publishes cubes up to the content store without requiering unwieldy cubeswap scripts.

You just need to call COGTR.EXE with the correct command line to build and publish your cube automagically.

Its all in the manual.

I have also attached a mor concise summary of it.

Please let me know if this document is useful.
Text only | Text with Images