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.
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
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).