ssasmdxcubeanalysisservicesmultidimensional-cube

SSAS : Filter Cube

I have dimension and fact table. The dimension is PATIENTDBOID meanwhile the fact table is Total_Admissions. Now, I want to filter for Patient that Admission >1

enter image description here

Can someone help me how. ?

Solution

  • You Can use Filter Function to Apply filter on Measures with Logical Expression.

    Since I don't know Exact Dimension Name, You can try something like below.

    0 - Represents COLUMNS

    1 - Represents Rows

    SELECT [Measures].[Total_Admissions] ON 0,

FILTER(
  [Patient].[Patient].[PatientDBOID].MEMBERS
, [Measures].[Total_Admissions]>1)
ON 1

FROM [Cube Name]