Minimized sql and performance

[consultantcareer]

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,
Thanks

[blom0344]

Minimized in the Cognos sense appears to only touch on tables and joins used. It does not involve the dynamic selection of only those object.columns that should be returned from the model.

The KB has a reference on this which reads (essence only):

When working with model query subjects, there are side effects to using relationships and determinants that you should consider:

The model query subject starts to function as a view, which overrides the As View or Minimized setting in the SQL Generation type for a query subject.

Which seems to only beg the question why they ever sought to implement the feature   :'(