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
Can someone help me how. ?
Asked
Active
Viewed 166 times
0
-
Where you are trying to Achieve ? SSMS or Any other Application like PowerBI? You are using Tabular/Multi Dimension cube ? – Roshan Nuvvula Aug 01 '22 at 03:10
-
I am using SSAS. and I confuse to do filter using the SSAS application – merry Aug 01 '22 at 03:32
-
I Know you are using SSAS. Which Model you are using Tabular/Multi Dimension Cube ? MDX or DAX ? – Roshan Nuvvula Aug 01 '22 at 03:35
-
Multidimensional,MDX – merry Aug 01 '22 at 03:37
-
You can use filter. Refer this link https://learn.microsoft.com/en-us/sql/mdx/filter-mdx?view=sql-server-ver16 – Roshan Nuvvula Aug 01 '22 at 03:42
1 Answers
0
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]
Roshan Nuvvula
- 803
- 1
- 8
- 28
-
it is possible I put it in the calculation in the SSAS ? can u show how? – merry Aug 01 '22 at 08:58
-
Hi its me again, I created the filter in the calculation into Cube SSAS but it return null. can u tell me why, or there are other option to do the filter? – merry Aug 08 '22 at 03:26