| T O P I C R E V I E W |
| dbooth |
Posted - 10/15/2012 : 02:57:38
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'? |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 10/15/2012 : 03:48:23
Yes, you should be able to create a calculated member bases on your MDX expression and SUM or Aggregate MDX functions like:
Aggregate(
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')
)
)
Help on Calculated Members
http://www.reportportal.com/help/olap/calculated.htm
|
|
|
Report Portal
