My data model is Start Schma and these Keys are the Keys in my Fact Table. These Keys have n-n Relation.
The Key_C tied to anothe field in the dimesion table, Context_C and Context_C_Type. Context_C have the field values of Key_X or Key_Y or Key_Z. and Context_C_Type have the filed Name.
When user select Key_C, I need to show the values matching Context_C with Key_X or Key_Y or Key_Z. Please find the below Sample Data.
FACT TABLE SAMPLE DATA:
Key_X
Key_Y
Key_Z
Key_A
Key_B
Key_C
Key_D
a
b
c
d
e
f
g
t
y
u
d
o
p
K
we
df
rg
d
o
fs
kj
Key_C Dimension Table Data:
Key_C
Context_C
Context_C_Type
f
a
Key_X
p
t
Key_Y
fs
rg
Key_Z
When User select the value "f" in the Key_C, I want see only first row only because the Context_C value is "a" and Type is Key_X.
