Hello Cognos Gurus,
I am trying to Union columns Ao,Bo,Co,Do and Eo from oracle data set and As,Bs,Cs,Ds,Es from sql server dataset.
I want to create a union of these two.Au,Bu,Cu,Du,Eu.
Requirement for that Union is that it should create union for just the fields it was asked for.
I mean if you access just the Au then result set should do the union of just Ao and As.
That's what I expected that minimzed sql would do.
instead it first creates union set with all fields..Au,Bu,Cu,Du and Eu and then selects Au after that.
My expectation was that would happen if I chose sql setting to be 'As View' .
Intersting thing is it would not let me change sql setting any more for query set. It says its minimized..but doesn't act like one.
Oracle is 10g and sql server is 2000.
Any inputs/insights would be appreciated
Minimized SQL refers to the set of tables and joins involved in the SQL generated. It does not seem to effect that Cognos uses an inline view to retrieve all possible fields and then just selects the asked one in the outer select.
In our experience this setting is not well implemented (even to the extent that Cognos introduces unneccesary joins even with minimized SQL)