Hi everyone,
I have a classic fact table like this one (with almost 50 000 000 rows and more than 3000 brands):
| OrderID | Product | Brand |
|---|
| 1 | A | AAAA |
| 1 | B | AAAA |
| 1 | C | BBBB |
2 | D | CCCC |
| 2 | E | AAAA |
| 4 | F | BBBB |
| 4 | G | BBBB |
| 5 | H | CCCC |
I want to have the brand association. For exemple:
- if i select brand AAAA, associated brand are BBBB and CCCC
- If i select brand CCCC, associated brand is AAAA
The node is OrderID.
Is it possible to have a TOP 10 associated brand chart ? like this one:
| TOP 10 Brand (dimension) | Rank 1 Associated brand (expression) | Rank 2 Associated brand (expression) | Rank 3 Associated brand (expression) |
|---|
| AAAA | BBBB | CCCC | SSSS |
| XXXX | XXXX | XXXX | XXXX |
I can already have associated brands with this expression:
only({$<OrderID=P(OrderID), Brand=E(Brand)>} Brand)
Please see attached app.
Thanks for your help !
Quentin
