topic Re: Compatibility Map - Set Analysis in App Development

Compatibility Map - Set Analysis

Tee_dubs — Fri, 08 Mar 2019 07:26:16 GMT

I want to create a Dimension with set analysis to accomplish a "Compatibility map" using the Tree map visualization.

Once a "TASKNUMBER" is selected, I want to see all other TASKNUMBERS that share at least one of the same "ACCESS", "ZONE" and "PREPARATION" attributes.

Here is what I have so far.

aggr(ONLY({1<TASKNUMBER=, (Select all TASKNUMBERS regardless of selections)

ACCESS= p(ACCESS),

//(Select all possible ACCESS Values BASED ON SELECTION)

ZONE= p(ZONE),

//(Select all possible ZONE Values BASED ON SELECTION)

PREPARATION=P(PREPARATION)>}TASKNUMBER)

//(Select all possible PREPARATION Values BASED ON SELECTION)

,TASKNUMBER)

Re: Compatibility Map - Set Analysis

Anil_Babu_Samineni — Fri, 08 Mar 2019 08:18:42 GMT

Perhaps this?

Aggr(Only({<TASKNUMBER = E({<ACCESS = P(ACCESS), ZONE = P(ZONE), PREPARATION = P(PREPARATION)>} TASKNUMBER)>} TASKNUMBER), TASKNUMBER)

Re: Compatibility Map - Set Analysis

Tee_dubs — Fri, 08 Mar 2019 16:35:27 GMT

That doesn't work for me. However I managed it with 3 separate tree maps
with the relevant set analysis within the measure.