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

Except statement Cognos Report Studio

Started by Revelator80, 29 Mar 2011 09:44:22 AM

Previous topic - Next topic

Revelator80

I have created a set of unmapped suppliers by identifiying the ID for them. I now want to create an additional set for all the other suppliers to group these into a Mapped set. I think it's going to need the except function but I don't really know how to utilise it - my first attempt just brought back all the individual names again.

the set expression for the unmapped suppliers is:
member([CPD_Cube].[All Suppliers].[All Suppliers].[Supplier Name] ->
  • , 'Unmap','Unmapped Suppliers',[CPD_Cube].[All Suppliers].[All Suppliers])

    Any help greatly appreciated.