Mindmajix

Create a project from multiple databases

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:

  • 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

Screenshot_20

Screenshot_21

Screenshot_22

Screenshot_23Screenshot_24

Screenshot_25

Screenshot_26

Screenshot_27

Screenshot_28

Screenshot_29

Screenshot_30

Screenshot_31

Screenshot_32

Screenshot_33

Screenshot_34

Screenshot_35

Screenshot_36

http://bit.ly/1T6kYbR

 

Enroll for LIVE, Instructor LED ONLINE COGNOS TRAINING

0 Responses on Create a project from multiple databases"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.