My goal is to get the Schedule flag from "FACT Schedule" Tab as highlighted in yellow below;
I tried all ways to link them in the script (data model) when I select[New_Area]field the[SCH Schedule Flag]data is not responding as shown below (I think because[New_Area]&[SCH Task Discipline]is not connected)
My desired output should be like this:
when I select "MECHANICAL ENG" in[New_Area]
when I select "SOFTWARE ENG" in[New_Area]
when I select "CONTROLS ENG" in[New_Area]
Sorry for the long post, I tried all the ways and checked with all my sources but couldn't able to get the desired output.
Could anyone help me? I sincerely thank you again for all your valuable time and help. Attached are the files for reference
I think the cardinality of your link fields and link tables is wrong. If you select a single Link_Key_SAP_ORA or Link_Key_SAP_SCH value, you get multiple values on both sides of the link.This is why it looks like New-Area and SCH_schedule Flag are not associated.
Do you really intend this to be a many-to-many association? I think you model design needs to be reconsidered.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein