topic Re: Master Dimension for Quadrant Analysis in App Development

Master Dimension for Quadrant Analysis

SDT — Thu, 09 Feb 2023 22:05:19 GMT

Hello,

I have a data set with a range of customers and a range of products along with other measures and dimensions.

I have classified a subset of customers as either "A" or "B" and a subset of products as "A" or "B".

Products and customers are related to each other on orders.

I need to classify all combinations of customer and products (only when both have an A or B) into quadrants:

I tried several versions of a master measure and am getting results where the quadrant contains only one letter.

Here is one example I tried:

AGGR({1<CustomerAB={'A','B'}, ProductAB={'A','B'}>}
DISTINCT CustomerAB&ProductAB, Customer,Product)

I need to be able to set the quadrant regardless of other selections (hence the 1<> set analysis). The definitions of A or B are done in the load script independently for customer and for product.

Any help would be greatly appreciated.

Re: Master Dimension for Quadrant Analysis

sidhiq91 — Fri, 10 Feb 2023 03:45:51 GMT

@SDT Could you please post some sample data and expected output? that way it will help us to understand better and come up with a solution.

Re: Master Dimension for Quadrant Analysis

jbhappysocks — Fri, 10 Feb 2023 10:39:20 GMT

Hi, maybe there is an easier way to do it, but I think adding Only to your Aggr should do it?

AGGR({1<CustomerAB={'A','B'}, ProductAB={'A','B'}>}
DISTINCT Only(CustomerAB)&Only(ProductAB), Customer,Product)

Re: Master Dimension for Quadrant Analysis

SDT — Fri, 10 Feb 2023 13:33:58 GMT

That did it @jbhappysocks !

Thank you.