CODEWITHSUNDEEP
cognoscognos-11
malval
malval

Reputation: 31

Cognos 11.2 data module - custom SQL table from an existing custom SQL table

I have a datamodule with some tables in it via a database connection. I created a custom SQL table "customSQLt1" querying one of the existing tables, all works as usual. Now i want to create another custom SQL table "customSQLt2, but this time I want to query the custom SQL table i created earlier - "customSQLt1", not the existing tables.

When i go to New->Custom SQL table and write

select * from customSQLt1

it gives me an expression error. Is what i want even possible in Cognos 11.2?

Thank you for any hints

Upvotes: 0

Views: 335

Answers (1)

Leon
Leon

Reputation: 11

In the datamodule you can click on the name of your custom table, then right-click to "show query information". On this screen, copy the code. Close the query information screen. Next create a "Table using SQL". Paste the copied query definition in here and modify the SQL to include all the new definitions you require, including links to other tables that are not yet part of your original definition.

Be careful to use the same syntax used by the original query when specifying table names or column names.

Upvotes: 0

Related Questions