How to Show data into Single Table when multiple rows getting generated by Model
Hi ALL ,
I have just started working on my first dashboard :
Background :
I have Three Agg Tables with different granularity
Table 1:
Column (DIM) : A,B ,C,D, E,F,G,H
Measure :M1
Table 2:
A,B,M3,M4,M5
Table 3:
A,B ,C,M6,M7,M8
I had synthetic key generation so to solve it I did following:
Table 1:
A|B|C|D|E as Tab_1_Key;
A|B as Tab_2_Key
A|B|C as Tab 3_Key
M1
Table 2:
A|B|C|NULL|NULL as Tab_1_Key;
A|B as Tab_2_Key
A|B|NULL as Tab 3_Key
M3,M4,M5
Table 3:
A|B|C|NULL|NULL as Tab_1_Key;
A|B as Tab_2_Key
A|B|C as Tab 3_Key
M6,M7,M8
LINK :
Tab_1_Key,Tab_2_Key,Tab 3_Key,D, E,F,G,H From Table 1
Concat
Tab_1_Key,Tab_2_Key,Tab 3_Key,A,B from Table 2
Concat
Tab_1_Key,Tab_2_Key,Tab 3_Key,A,B,C from Table 3
This Solved My Issue of Key and I have perfect Link table created .
Issue : I am trying to give users Report where by clicking box they can select Dim and Measure in Chart Table so based on selection Table will form automatically .
Issue is that whenever I select D,E,F column with other measures from Table 2 ; There are two rows coming One with NULL as D and other with actual value . Same goes for E and F . I understand this is because of the Tab_1_Key formed at Table 2 .
I need help to display only one row in Chart table , can someone please guide how to get this .
