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