Hi all,

Let's say that I have a cube with 3 dimensions, machines, products and measures. Products on rows, measures on columns and machines in context. Now, one machine is able to produce several products and each product can be produced by one machine only. I can create several subsets in the products dimension, one for each machine, or I can create an attribute in products dimension with the producing machine name.

Maybe this is trivial, but, in a cube view, how can I show in rows only the products for a machine selected in context? I am used to create views in MDX, simple ones, but this confuses me. I am open to any ideas.

Any advice would be appreciated.

------------------------------
Jose Luis Senas
Data Analyst
Kimberly-Clark Mexico
Mexico City
------------------------------

HI,

I am assuming you want an unsuppressed view otherwise you could just show all and suppress and see only valid rows.

You could use MDX on your rows to generate a list of Products that are linked to a Machine based on the attribute.

Because Machine is in the Context area (different axis to Product) you can use .CurrentMember in MDX on the Products to filter by e.g.

Filter(
DESCENDANTS([Products].[Products].[Total Products], 99, LEAVES),
[Products].[Products].CurrentMember.Properties("Machine")=
[Machine].[Machine].CurrentMember.Name)

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------

Hi George,

The solution worked as expected. That's what I was looking for.

Thanks a lot.

------------------------------
Jose Luis Senas
Data Analyst
Kimberly-Clark Mexico
Mexico City
------------------------------

Original Message:
Sent: Wed April 24, 2024 02:40 PM
From: George Tonkin
Subject: Filter rows based on context selection.

HI,

I am assuming you want an unsuppressed view otherwise you could just show all and suppress and see only valid rows.

You could use MDX on your rows to generate a list of Products that are linked to a Machine based on the attribute.

Because Machine is in the Context area (different axis to Product) you can use .CurrentMember in MDX on the Products to filter by e.g.

Filter(DESCENDANTS([Products].[Products].[Total Products], 99, LEAVES),[Products].[Products].CurrentMember.Properties("Machine")=[Machine].[Machine].CurrentMember.Name)

I am assuming you have an attribute to map Products to Machine. The result should be something like the below snip.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------

HI Jose,

Glad to hear it worked for you.

If you would like to learn some more on MDX, I recently posted some blog articles to get you going.

Personally I find MDX view powerful and versatile and a real game-changer for TM1.

Good luck!

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------

Original Message:
Sent: Thu April 25, 2024 10:32 AM
From: Jose Luis Señas Cuesta
Subject: Filter rows based on context selection.

Hi George,

The solution worked as expected. That's what I was looking for.

Thanks a lot.

------------------------------
Jose Luis Senas
Data Analyst
Kimberly-Clark Mexico
Mexico City
------------------------------


Original Message:
Sent: Wed April 24, 2024 02:40 PM
From: George Tonkin
Subject: Filter rows based on context selection.

HI,

I am assuming you want an unsuppressed view otherwise you could just show all and suppress and see only valid rows.

You could use MDX on your rows to generate a list of Products that are linked to a Machine based on the attribute.

Because Machine is in the Context area (different axis to Product) you can use .CurrentMember in MDX on the Products to filter by e.g.

Filter(DESCENDANTS([Products].[Products].[Total Products], 99, LEAVES),[Products].[Products].CurrentMember.Properties("Machine")=[Machine].[Machine].CurrentMember.Name)

I am assuming you have an attribute to map Products to Machine. The result should be something like the below snip.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg