COGNOiSe.com - The IBM Cognos Community

Scorecarding and Dashboard Software => COGNOS Metrics Manager => Topic started by: rajwarrier on 10 Feb 2011 11:35:46 AM

Title: bcp utility in metric studio
Post by: rajwarrier on 10 Feb 2011 11:35:46 AM
We have metric server component installed correctly in our distributed cognos 8.4 installation.
the doubt we have is
  Do we need bcp-utility on any of the app server boxes or content machine box or the webserver box ?
If a user installs metric designer tool on his machine, will he need the sql bcp utility on his machine ?
How does bcp play a role in Metric studio/designer ??
thank you all !
Title: Re: bcp utility in metric studio
Post by: RobsWalker68 on 10 Feb 2011 12:23:41 PM
Hi,

Metric designer doesn't need a bcp utility as it acts upon existing Cognos data sources i.e framework packages, cubes etc. You can then either execute the job on Metric Designer to transfer the data to the staging tables in the Metric Store or more commontly create a job on the Cognos server that can be scheduled.

As you mention using a bcp utility do you therefore need to  load data from a non cognos source(s)?

Rgds

Rob