Question Jacinto Busquets · Mar 20

Have anyone has a class that profiles a table? Example, total rows, total nulls, average, max , min for each column on th

I created a table profile dashboard on Power BI, but I wonder if is possible to do it in Iris by creating a class.

HealthShare Clinical Viewer 2022.2.2 Build: 1000 Adhoc: 23127 [HealthShare Modules: Core:24.0 + Clinical Viewer:24.0] - IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1 (Build 209_0_23127U) Mon Feb 12 2024 18:21:53 EST [Core:24.0|Clinical Viewer:24.0]

#HealthShare #Caché
3
0 64
Question Jacinto Busquets · Apr 6, 2023

I need to group two or more values into one. What is the right syntax ? WITH [DIMENSIONS].[GENDERCAL] AS [Gender].[H1].[Gender].Currentmember WHEN [Gender].[H1].[Gender].[F] THEN 'FEMALE' WHEN [G

How can I create a calculated member in Analyzer using MDX for the following logic?

WHEN 'F' THEN 'FEMALE'
WHEN 'Female' THEN 'FEMALE'
WHEN  'M' THEN 'MALE'
WHEN 'Male' THEN 'MALE'
WHEN 'U' THEN UNDIFFERENTIATED'
WHEN 'UN' THEN UNDIFFERENTIATED'
WHEN 'Undifferentiated' THEN UNDIFFERENTIATED'
ELSE 'OTHER'
END

#InterSystems IRIS BI (DeepSee) #Analyzer #MDX
2
0 304