Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing DB links depending on the selected parameter

Status
Not open for further replies.
Manish02

Manish02

Programmer
Nov 11, 2010
1
US
I have a scenario where i am connecting to a Data source 'A' from cognos connection. In 'A' database, i created 2 database links 'B' and 'C'. Both B and C databases have the same table structure. When i run the report I pass region parameter, depending on the region, I wanted to change the database link.
My report is built off of a sql query.

Is there a way to change database link depending on the selected region? We are using Cognos8.4
 
Status
Not open for further replies.

Similar threads

Magnus_03
  • Locked
  • Question
Cognos 10.2.2 Workspace Advanced Errors (Failed...request, the report server..., and annotation...)
Replies
0
Views
164
Magnus_03
Magnus_03
sruthi2016
  • Locked
  • Question
Help on cognos javascript to pass parameter from one report to another dynamically
Replies
0
Views
78
sruthi2016
sruthi2016
dredden2
  • Locked
  • Question
COGNOS Script to modify date ranges on a Dimension
Replies
0
Views
158
dredden2
dredden2
sandippk
  • Locked
  • Question
FM create detail filter with parameter which will be provided in Report Studio
Replies
0
Views
63
sandippk
sandippk
Gucha
  • Locked
  • Question
Cognos aggregation (summary on multiple measures on different hierarchy levels)
Replies
0
Views
107
Gucha
Gucha

Part and Inventory Search

Sponsor

Back
Top