The cube contains dimensions 'Requesting Depot' and 'Warehouse', with Works Order measures. The dimensions are role-playing off a base DimWarehouse. A requesting depot can process its own works orders, or subcontract them out to a different warehouse.
Those members where the RQ depot isn't the same as the Warehouse are returned by this Named Set MDX :
FILTER( NonEmptyCrossJoin( [Requesting Depot].[Warehouses by Code].[Warehouse], [Workshop].[Warehouses by Code].[Warehouse] ) , [Requesting Depot].[Warehouses by Code].Properties('Name') <> [Workshop].[Warehouses by Code].Properties('Name') )
Can that be converted to a boolean Y/N for inclusion as a report filter called 'RQDepotEQWarehouse'?
Report Portal
Filtering by comparing dimension values
Posted - 10/15/2012 : 02:57:38
