Thank you for the clarification, but there are many scenario’s in which the multiple edges between two nodes will be required. The schema details are shared as follows:
To make the schema creation generic, we are representing all the dimensions as nodes and facts as edge in the graph.
Self Relation similar to BOM
Dimension: Material, Fact: Parent
Nodes: Material, Relations: Parent
Nodes and Relations also contains different properties associated with them.
There is a case that multiple relations exists between two material with property values differing.
Dimension: Customer, Material Fact: Forecast
Nodes: Customer with property CustomerId
Material with property MaterialId
Relation: forecast_details with properties week no and quantity
For example: Consider a Material M2 and Customer C9 and 5 weeks of data.
To represent this 5 weeks of data need to have 5 relationships between same two nodes with week no and quantity different.
Please go through the same and suggest how can I achieve the same.
Thanks & Regards,