emptySet

Returns an empty member set for "hierarchy". This is most often used as a placeholder during development or with dynamic report design (either with the IBM® Cognos® Software Development Kit or via report design). By creating a data item that contains the emptyset function, it is possible to build complex expressions that can later be revised by redefining the emptyset data item.

Syntax

emptySet ( hierarchy )

Example

except ( [great_outdoors_company].[Products].[Products].[Product 
line] , emptySet ( [great_outdoors_company].[Products].[Products] ) )

Result

Returns the Product line set and an empty set for the Products set.

Result data

Camping Equipment
Golf Equipment
Mountaineering Equipment
Outdoor Protection
Personal Accessories