If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dimensional reporting

Started by cogcurious, 07 Sep 2011 04:05:07 PM

Previous topic - Next topic

cogcurious

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

CognosPaul

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?