We have an oracle instance(Oracle 10g) and we have a Database in this instance for the Content Store.Now we are planning to install Metric Studio to our Cognos environment.So for the Metric Store,do we need to have a seperate database in the same instance or is it sufficient if we create a schema and use it as a metric store.
Please advice.
That doesn't matter. Both will work. Just make sure your character set is set to a unicode one. Otherwise it won't work.
Additionally, ensure you have the precise permission granted to the metric store user. As well, you schema must reside in an enterprise level oracle server. Oracle XE will not work with Metric Studio.