COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: cognostechie on 07 Jun 2006 11:58:55 PM

Title: Publish a cube from Ver 7.3 to Cognos 8
Post by: cognostechie on 07 Jun 2006 11:58:55 PM
I am sorry guys if this sounds a very trivial question.

I recently installed Cognos 8 Server and presently have Powerplay 7.3 and a ton of cubes in that. The installation is fine and I can logon to Cognos Connection. Question is - How do I publish my cubes (that have been made using Powerplay Transformer 7.3) to Cognos Connection. I believe that Analysis Studio is supposed to be used for the cubes. But how do I get my cubes in there? The documentation that came with Cognos 8 doesn't say that, or am I missing something?

Thanks in advance.

Title: Re: Publish a cube from Ver 7.3 to Cognos 8
Post by: JGirl on 09 Jun 2006 12:32:42 AM
Cubes now need to be created as Cognos Connection data sources, and published as packages from Framework Manager. 

Step 1:  Create a new data source for each cube file in cognos connection (choose the type as 'Cognos PowerCube', and enter the path to the *.mdc file)

Step 2:  Create a new framework manager project, create a namespace (call it something like 'Cubes').  Right click on this, and 'Run Metadata Wizard'.  Choose data source, and browse to the data source you created for the cube.  It will then ask you if you want to publish the package.  If you want to publish it now, do it, otherwise, do it later.

Step 3:  Repeat for all cubes...very long and tedious :)

Step 4:  Publish the packages.....

Step 5:  Open analysis studio, select the cube package, and enjoy.

J
Title: Re: Publish a cube from Ver 7.3 to Cognos 8
Post by: cognostechie on 09 Jun 2006 11:47:43 PM
WoW ! Thanks JGirl. I really appreciate the step-by-step help. I will try it.