Skip to main content

persona_pattern

Bridge cube that normalises the many-to-many relationship between personas and analytical patterns. Each row represents one persona-and-pattern pair, derived by splitting the DOMINANT_ANALYTICAL_PATTERNS comma-separated column in MASTER.PERSONA. PATTERN_RANK preserves the original order of codes as listed for each persona (1 = first/primary pattern). Always query persona counts through distinct_personas on the persona cube to avoid fan-out double-counting.

Joins

Dimensions

Measures