Create a project from multiple databases in Cognos

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

124 Enrolled

2665 Enrolled

350 Enrolled

134 Enrolled

1283 Enrolled

120 Enrolled

132 Enrolled

870 Enrolled

1622 Enrolled

280 Enrolled

241 Enrolled

180 Enrolled

1026 Enrolled

1241 Enrolled

750 Enrolled

1406 Enrolled

250 Enrolled

190 Enrolled

237 Enrolled

135 Enrolled

274 Enrolled

170 Enrolled

1151 Enrolled

180 Enrolled

128 Enrolled

245 Enrolled

176 Enrolled

180 Enrolled

350 Enrolled

104 Enrolled

243 Enrolled

1280 Enrolled

683 Enrolled

218 Enrolled

1559 Enrolled

1568 Enrolled

940 Enrolled

786 Enrolled

227 Enrolled

1660 Enrolled

158 Enrolled

145 Enrolled

180 Enrolled

346 Enrolled

895 Enrolled

972 Enrolled

141 Enrolled

852 Enrolled

1043 Enrolled

631 Enrolled

385 Enrolled

154 Enrolled

1890 Enrolled

532 Enrolled

212 Enrolled

120 Enrolled

120 Enrolled

1524 Enrolled

231 Enrolled

2256 Enrolled

125 Enrolled

213 Enrolled

1942 Enrolled

324 Enrolled

170 Enrolled

210 Enrolled

246 Enrolled

180 Enrolled

1905 Enrolled

120 Enrolled

226 Enrolled

1603 Enrolled

105 Enrolled

184 Enrolled

807 Enrolled

2430 Enrolled

125 Enrolled

238 Enrolled

1270 Enrolled

1578 Enrolled

1365 Enrolled

278 Enrolled

166 Enrolled

156 Enrolled

1209 Enrolled

150 Enrolled

1851 Enrolled

962 Enrolled

1358 Enrolled

210 Enrolled

214 Enrolled

849 Enrolled

115 Enrolled

196 Enrolled

140 Enrolled

186 Enrolled

125 Enrolled

120 Enrolled

160 Enrolled

342 Enrolled

1432 Enrolled

1453 Enrolled

1058 Enrolled

1270 Enrolled

365 Enrolled

1204 Enrolled

1358 Enrolled

621 Enrolled

1253 Enrolled

185 Enrolled

360 Enrolled

153 Enrolled

220 Enrolled

1203 Enrolled

1489 Enrolled

108 Enrolled

356 Enrolled

1860 Enrolled

1254 Enrolled

1431 Enrolled

1232 Enrolled

1383 Enrolled

1370 Enrolled

2230 Enrolled

790 Enrolled

156 Enrolled

156 Enrolled

1350 Enrolled

890 Enrolled

985 Enrolled

146 Enrolled

180 Enrolled

152 Enrolled

164 Enrolled

270 Enrolled

124 Enrolled

1240 Enrolled

247 Enrolled

156 Enrolled

196 Enrolled

156 Enrolled

225 Enrolled

180 Enrolled

1755 Enrolled

150 Enrolled

850 Enrolled

120 Enrolled

1590 Enrolled

894 Enrolled

154 Enrolled

2311 Enrolled

210 Enrolled

125 Enrolled

1782 Enrolled

158 Enrolled

125 Enrolled

232 Enrolled

107 Enrolled

1209 Enrolled

1620 Enrolled

2079 Enrolled

164 Enrolled

1186 Enrolled

153 Enrolled

809 Enrolled

1452 Enrolled

1310 Enrolled

312 Enrolled

135 Enrolled

1380 Enrolled

1495 Enrolled

1344 Enrolled

1201 Enrolled

2425 Enrolled

1245 Enrolled

321 Enrolled

728 Enrolled

1280 Enrolled

1802 Enrolled

256 Enrolled

463 Enrolled

1268 Enrolled

215 Enrolled

188 Enrolled

1100 Enrolled

234 Enrolled

1107 Enrolled

1304 Enrolled

160 Enrolled

320 Enrolled

995 Enrolled

2391 Enrolled

1394 Enrolled

1284 Enrolled

106 Enrolled

970 Enrolled

1854 Enrolled

186 Enrolled

1460 Enrolled

1870 Enrolled

153 Enrolled

120 Enrolled

141 Enrolled

145 Enrolled

156 Enrolled

3012 Enrolled

124 Enrolled

154 Enrolled

135 Enrolled

1564 Enrolled

1605 Enrolled

127 Enrolled

149 Enrolled

120 Enrolled

2147 Enrolled

1360 Enrolled

1354 Enrolled

120 Enrolled

1209 Enrolled

594 Enrolled

226 Enrolled

145 Enrolled

124 Enrolled

1121 Enrolled

1280 Enrolled

245 Enrolled

110 Enrolled

342 Enrolled

1206 Enrolled

348 Enrolled

163 Enrolled

158 Enrolled

321 Enrolled

120 Enrolled

288 Enrolled

859 Enrolled

130 Enrolled

126 Enrolled

128 Enrolled

126 Enrolled

270 Enrolled

145 Enrolled

2164 Enrolled

1252 Enrolled

1283 Enrolled

205 Enrolled

1775 Enrolled

985 Enrolled

135 Enrolled

248 Enrolled

120 Enrolled

209 Enrolled

173 Enrolled

1456 Enrolled

205 Enrolled

1520 Enrolled

1483 Enrolled

164 Enrolled

120 Enrolled

192 Enrolled

831 Enrolled

1854 Enrolled

180 Enrolled

1820 Enrolled

1511 Enrolled

894 Enrolled

233 Enrolled

1234 Enrolled

920 Enrolled

155 Enrolled

211 Enrolled

243 Enrolled

120 Enrolled

175 Enrolled

1281 Enrolled

260 Enrolled

590 Enrolled

120 Enrolled

1790 Enrolled

120 Enrolled

171 Enrolled

1503 Enrolled

1856 Enrolled

1486 Enrolled

327 Enrolled

1264 Enrolled

234 Enrolled

115 Enrolled

195 Enrolled

105 Enrolled

950 Enrolled

1692 Enrolled

178 Enrolled

1068 Enrolled

247 Enrolled

962 Enrolled

1374 Enrolled

142 Enrolled

230 Enrolled

3721 Enrolled

1321 Enrolled

135 Enrolled

256 Enrolled

1121 Enrolled

130 Enrolled

145 Enrolled

859 Enrolled

120 Enrolled

1768 Enrolled

150 Enrolled

320 Enrolled

156 Enrolled

1782 Enrolled

265 Enrolled

1390 Enrolled

340 Enrolled

267 Enrolled

693 Enrolled

1860 Enrolled

995 Enrolled

256 Enrolled

1751 Enrolled

124 Enrolled

1590 Enrolled

288 Enrolled

136 Enrolled

152 Enrolled

1378 Enrolled

2106 Enrolled

120 Enrolled

213 Enrolled

260 Enrolled

1202 Enrolled

1602 Enrolled

2596 Enrolled

1285 Enrolled

952 Enrolled

145 Enrolled

311 Enrolled

1759 Enrolled

1411 Enrolled

340 Enrolled

245 Enrolled

1053 Enrolled

257 Enrolled

256 Enrolled

236 Enrolled

1850 Enrolled

1249 Enrolled

164 Enrolled

141 Enrolled

896 Enrolled

186 Enrolled

1546 Enrolled

426 Enrolled

340 Enrolled

255 Enrolled

1208 Enrolled

185 Enrolled

300 Enrolled

132 Enrolled

258 Enrolled

1850 Enrolled

914 Enrolled

1326 Enrolled

160 Enrolled

1406 Enrolled

1809 Enrolled

134 Enrolled

726 Enrolled

731 Enrolled

182 Enrolled

1850 Enrolled

554 Enrolled

120 Enrolled

190 Enrolled

Blog

Create a project from multiple databases in Cognos

Social Share

RELATED COURSES