Hey everyone. I am having trouble getting the MDX Filter statment to filter out cells from my cube in a Cube Calculation. Here's the calc definition:
CREATE
MEMBER CURRENTCUBE.[MEASURES].[Avg Dried Log Length - mm]AS
(Left([Dim Die].[Die Type Code].
),
[Measures].[Dried Log Length - mm]
)
/ [Measures].[Extrusion Process Record Count]
,
SUM( FILTER(
[Dim Die].[Die Type Code].[Die Type Code].Members,CurrentMember.member_caption, 5) <> "PURGE")
FORMAT_STRING
= "#,#.00",
NON_EMPTY_BEHAVIOR
= { [Extrusion Process Record Count] },
VISIBLE
= 1 ;
Basically, trying to compute the average of the [Measures].[Dried Log Length - mm] measure excluding any cells from the Die dimension that have a Die Type of "PURGE".
When we look at this data in Excel, the PURGE Die Type does have records associated with it.
Here's an associated calcuation that uses the one above. Do we need a FILTER on this calc as well? If so, what would the syntax be?
CREATE
MEMBER CURRENTCUBE.[MEASURES].[Extrusion Quality Factor % (Using Die Weight Actual)]AS IIF
(
[Measures].[Dry Weight Extruded - kg] = 0,
(([Measures].[Logs Out Of Dryer] *
[Measures].[Avg Dried Length - mm] *
[Measures].[Avg Die Weight Actual - g per mm]) / 1000)
/
[Measures].[Dry Weight Extruded - kg]
),
NULL,
FORMAT_STRING
= "Percent",
NON_EMPTY_BEHAVIOR
[Measures].[Extrusion Process Record Count]
},
= {
VISIBLE
= 1 ;
Thanks in advance for any help!