Thursday, June 9, 2011

Publishing Package from a Cube


Using Framework Manager, we can publish a package which could either be sourced from a database or a cube. Here we will be discussing on how to publish a package in Framework Manager, with cube as a source. Below listed are the steps to be followed in the process:

1. Create a cube (.mdc file) and save it in any location in the server.

2. Open Framework Manager and click on “Create a New Project”.

3. Give the name and location for your project and click “OK”.

4. Select the language for your project and click “OK”.

5. Now, you will get the “Metadata Wizard” with options to “Select Metadata Source”.

6. Click on “Data Sources” and “Next” to create a new data source for connecting our cube.

7. Click on “New” for creating a new data source and click “Next”.

8. Specify a name for the new data source to be created and click on “Next”.

9. Now, select the “Type” for the new data source connection. Select “Cognos PowerCube” for type.

10. Now, specify the location of the cube (.mdc file) and click on “Test the connection”.

11. Click on “Finish” to complete the creation of the data source connection to the cube.

12. Select the created data source and click on “Next” to complete the import process and then click on “Finish”.

13. The “Create Package” window will be displayed. Enter the name for the package and click on “Finish”.

14. Now, you will get the “Publish Wizard”; specify the publish location. Click “Next” and then click on “Publish”.

Your cube is now published in the portal. Do note that you cannot make any changes to the metadata while publishing the cube.

No comments:

Post a Comment