Forum Discussion
Helper IIIHow to create relationship between two tables
Helper VHi,
This table I will call Problem
| Model Name | Problem | Value |
| A | Size | 10 |
| B | Size | 5 |
| C | Color | 3 |
| E | No Issue | 2 |
| E | Color | 1 |
This table I will call Order.
| Model Name | Value | Qty |
| A | 1 | 100 |
| A | 2 | 30 |
| C | 3 | 1 |
| D | 10 | 3 |
| C | 4 | 2 |
Create a reference to the Problem table and remove all but the model column.
Create a reference to the Order table and remove all but the model column.
Append the two new referenced tables together.
Remove the duplicates in Model column.
Join the new dimension table table to the two fact tables Order and Product.
You can now slice by model.
A video explaining the process: https://www.youtube.com/watch?v=2iEapc7yE_g
Cheers
John
SelflearningBiHi Thanks for helping, is it possible to slice by problem?
Actually I have lots of model, I would like to create a slicer that slice problem category and show the model/qty/value- johnmelbourne
Hi,
Sorry, I read your requirement incorrectly.
The original poster is partly correct, join both tables on Model. I assume you will have a many to many relationship. This will create a many to many realtionship but that will be ok. Make sure cross filter direction is set to both.
Then create a reference to the Problems table.
Remove all columns except the problem column.
Remove duplicates.Join the new Problem lookup (slicer / dimension) table to the other problem table on Problem. This will be a one-many relation. It will now slice both.
See images
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C- SelflearningBi
Hi thanks for showing the step, however, i found the result in value is come out incorrectly. I put model/ problem and value in a table but the value is not matching the raw data.