Brands association chart

Tue, 16 Jun 2015 15:03:22 GMT

Hi everyone,

I have a classic fact table like this one (with almost 50 000 000 rows and more than 3000 brands):

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

Re: Brands association chart

Fri, 19 Jun 2015 07:34:18 GMT

Anyone ?