If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data source duplication in Framework Manager.

Started by TheWatcher, 27 Aug 2008 11:48:26 AM

Previous topic - Next topic

TheWatcher

Hello all.
I've encountered an issue here with my Framework Manager.
When I look at the data source Query Subjects, all of the syntax is:
Select * from [dataSourceName].tableName
When I 'Test" the Query Subjects, I get all of the columns with the first 25 rows returned .. no mystery so far.

If I delete the above sql from the 'SQL' tab and expand the dataSourceName (+) in the 'Available database objects:' frame, to the origin of the tableName, then drag the table across to the 'SQL' frame, I get:

Select * from [dataSourceName1].tableName

Notice that there is now a 1 appended to the original datasourceName.
Where is that comming from??
I've not edited the dataSource that I'm aware of, and the original 'dataSourceName' would seem to be pointing at my Oracle target.
Any suggestions?
Thanks as always.
-D.

blom0344

Cognos adds a new datasource (increment) if you add objects in a additional session. Simply delete the newly added datasource and correct the expression.

non-official hint : modify the model.xml with a text-editor if you need to make many adjustments

Ty Clabbers

Basicly you get this if you don't have the schema name filled in your original framework "data source". If your data comes from one schema in your database i suggest you fill the property with that schema name. Is saves time. It also saves you from the need for synonyms and thus for potential errors (and I know forgetting to create a synonym is a common mistake).