Blog

  • Home
  • Cognos
  • Create a project from multiple databases in Cognos

Create a project from multiple databases in Cognos

  • (4.0)
  • | 1339 Ratings

Multi database access (Unique to the Cognos):

Multi database access is one of the unique features, you get to find in Cognos. Its establishment can be done as shown in the below steps:

Enroll for LIVE, Instructor LED ONLINE COGNOS TRAINING
  • Cognos 10 BI supports to create a single project from multiple databases
  • The database can be homogeneous/ heterogeneous
  • Select BUSINESS VIEWS folder
  • Right click
  • Click on namespace
  • Rename the namespace as RETAILERS
  • Select the RETAILERS namespace
  • Right click
  • Click on run metadata wizard
  • Select the metadata source as data source
  • Select go retailers data source
  • Click on Next
  • Select Tables
  • Click on Next
  • Leave the defaults to generate relationships between query subjects
  • Click on Import
  • Click on Finish
  • From MODEL expand the SALES namespace
  • Expand order_header query subject
  • Select RETAILERS name
  • Click Ctrl+Click
  • Expand the RETAILERS namespace
  • Expand retailer query subject
  • Subject company_name query item and right click
  • Select on Create
  • Click on Relationships
  • Click on OK and from toolbar, click on SALES

HTTP://BIT.LY/1T6KYBR

Frequently Asked Cognos Interview Questions & Answers


Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close