I have a report that has 60 odd members in the row of a crosstab . Each ahs been individually put there. Is it a recommended practice? The deal is if we go with sets then we would have to have multiple sets, fewer though
Personally I prefer working with sets. Sets and set functions are easier to work with and ensure the query is much less cluttered.
One of the annoying habits RS has is aliasing MUNs. That's when you drag a member into a function and it adds another item to the query. To fix that, go to Tools->Options->Report and make sure "Alias member unique names" is unchecked. Also uncheck "Always create extended data items for new reports".
Now, when you create a simple set, Cognos won't dump all of the members into the query.
My question for you is, why does each member need to be placed individually. Is there any logic you can use to place them there programatically?