Hi,
I have above 2 tables. Parent Child mapping & simple fact table with data at parent level for each date. I would like to see the report where-in I ll have parent data propagated down to their respective children based on Timeline selection. I have pulled
those table in Data Model. But I am unable to create relationship between them. This is because both table have duplicate values (Parent value- Sys1) which is nothing but having Many-to-Many relationship which is directly not possible in Data Model.
Even I can not create a merged tables because both these tables have million of records.
Can anyone suggest me how should I achieve this above report where-in I want children to show their Parent's data along with timeline?
- Edited by Rameshwar Pawale 1 hour 45 minutes ago typo